G
GTM Vault
Browse
  • Dashboard
    • Automations
    • Skills
    • Prompts
    • Makers
  • Sign in
All Automations

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

Automate LinkedIn content creation by managing ideas in Google Sheets, generating AI posts, and publishing with approval workflow.

workflowcontent
Sona Labsby Sona Labson n8n
Nodes

33

Triggers

1

Platform

n8n

Tech Stack
OpenAI
OpenAI
AI Agent
Google Sheets
Google Sheets
LI
Linked In
Gmail
Gmail
How It Works

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.

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
Attached Files
workflow.json

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.

What You'll Need

OpenAIGoogle SheetsLinkedInGmail
  • 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

This automation has 10 configurable settings you'll customize during setup.