Create & track LinkedIn posts with Google Sheets, GPT-5.1, Unsplash, and Sona

Automate LinkedIn content creation by managing ideas in Google Sheets, generating professional AI-written posts, intelligently selecting relevant Unsplash images, sending drafts for email approval, and publishing directly to LinkedIn.

How it works

Step 1: Scheduled Sheet Check - Workflow runs daily at midnight (customizable to hourly/weekly) - Fetches posts from Google Sheet marked with Status = "Ready" - Processes one post per run, updates status to "In Progress"

Step 2: AI Content Generation - GPT-5.1 creates engaging LinkedIn post based on your inputs - Generates content with proper hashtags, formatting, and tone - Follows your specified content type (tip, story, announcement, etc.)

Step 3: Quality Validation - Automatically checks character limits (3000 max) - Validates minimum hashtag requirements (3+) - Loops back to regenerate if quality checks fail

Step 4: Email Approval Workflow - Formats post as HTML email with professional styling - Sends preview to your Gmail for review - Waits for your approval response before proceeding - Nothing posts without explicit confirmation

Step 5: Smart Image Handling - If you provided image URL: Downloads from Google Drive, Dropbox, or direct links - If no URL is provided: Fetch 10 images from Unsplash and use AI to select the best one. - If "Include Image?" is "No": Posts text-only content - Automatically converts share links to downloadable formats

Step 6: LinkedIn Publishing & Tracking - Posts approved content directly to your LinkedIn profile - Uses appropriate API endpoint based on whether image is included - Updates Google Sheet status to "Posted" for successful posts - Marks "Rejected" posts in sheet for review and editing