G
GTM Vault
Browse
  • Dashboard
    • Automations
    • Skills
    • Prompts
    • Makers
  • Sign in
Loading setup wizard...
Back to Create & track LinkedIn posts with Google Sheets, GPT-5.1, Unsplash, and Sona

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

This workflow checks Google Sheets daily for post ideas, uses GPT to generate professional LinkedIn content with relevant images from Unsplash, sends drafts via email for approval, then publishes approved posts directly to LinkedIn while tracking status.

What This Automation Does
1

Check Google Sheets for ready posts

Runs daily to fetch posts marked as 'Ready' status from your Google Sheet and updates one post to 'In Progress' for processing.

2

Generate AI content with GPT

Creates engaging LinkedIn post content based on your topic, content type, and tone specifications with proper hashtags and formatting.

3

Validate content quality

Checks character limits and hashtag requirements, regenerating content if quality standards are not met.

4

Send email approval request

Formats the post as HTML email and sends preview to Gmail for your review and explicit approval before posting.

5

Handle image selection

Downloads your provided images or uses AI to select the best image from Unsplash search results based on post content.

6

Publish to LinkedIn and update status

Posts approved content to LinkedIn profile and updates Google Sheet status to 'Posted' or 'Rejected' for tracking.

Prerequisites

  • OpenAI API key with GPT access
  • Google Sheets account with structured post data
  • Gmail account for approval workflow
  • LinkedIn account with API access
  • Unsplash API key for image selection

Services Used

OpenAIGoogle SheetsLinkedInGmail

Services with alternatives — you can swap them in the next step.