Skip to content
Dhanasvi
Sign inExplore
Create & track LinkedIn posts with Google Sheets, GPT-5.1, Unsplash, and Sona logo

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

Verified

Automates LinkedIn post creation from Google Sheets using AI with email approval.

n8nAI & LLMIntermediate👁 176 views
Open template
Updated 2026-06-15

What this workflow does

This workflow pulls ideas from Google Sheets, generates AI-written LinkedIn posts with proper formatting and hashtags, routes drafts for Gmail approval, and publishes approved content directly to LinkedIn while tracking status updates.

It is designed for professionals and content teams who manage LinkedIn posting through spreadsheets and want AI assistance with review controls before publication.

Who is this for?

Marketing professionals, content creators, and social media managers who plan and publish LinkedIn posts regularly.

What problem it solves

Manually creating, approving, and posting LinkedIn content from spreadsheets is repetitive and error-prone.

Live workflow preview

Interactive canvas of every node and connection — scroll and click to explore. Powered by n8n's preview.

Open the template on n8n to import and run it. View source template →

What it automates

Weekly content batching

Queue multiple post ideas in Google Sheets on Monday and let the workflow generate, approve, and publish one per day.

Image-assisted announcements

Provide an image URL in the sheet for product launches so the workflow downloads and attaches it automatically.

Text-only tip series

Set 'Include Image?' to No for quick professional tips that post without visuals after email approval.

How the workflow works

The 8 nodes in this automation, in order.

  1. 1Google SheetsgoogleSheets
  2. 2HTTP RequesthttpRequest
  3. 3Gmailgmail
  4. 4LinkedInlinkedIn
  5. 5Codecode
  6. 6AI Agent@n8n/n8n-nodes-langchain.agent
  7. 7OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
  8. 8Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured

Apps & integrations used

Google SheetsHTTP RequestGmailLinkedInAI AgentOpenAI Chat ModelStructured Output Parser

How to set up Create & track LinkedIn posts with Google Sheets, GPT-5.1, Unsplash, and Sona

  1. 1Import the workflow JSON into your n8n instance
  2. 2Add credentials for Google Sheets, Gmail, LinkedIn, and OpenAI
  3. 3Connect the Google Sheet containing your post ideas and status column
  4. 4Configure the Schedule trigger to run daily at midnight
  5. 5Set the Gmail node to your approval email address
  6. 6Activate the workflow and test with one row marked 'Ready'

How to customize this workflow

  • →Change the Schedule trigger to hourly or weekly
  • →Swap OpenAI Chat Model for another supported provider
  • →Add extra validation rules in the Structured Output Parser
  • →Insert an HTTP Request step to notify Slack on rejection

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

Pros

  • +Built-in email approval prevents unwanted posts
  • +Automatic status tracking in Google Sheets
  • +Handles both image and text-only posts
  • +Quality checks reduce manual editing

Cons

  • –Requires LinkedIn API access and credentials
  • –One post processed per run
  • –Depends on Unsplash and external image sources
Did you find this helpful?

Frequently asked questions

It pulls ready posts from Google Sheets, generates content with OpenAI, gets email approval, optionally adds an Unsplash image, and publishes to LinkedIn while updating the sheet.

User reviews

Verified reviews from the community shape this listing's rating.

Loading reviews…

Sign in to review

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

Add this badge to your website, or share the tool.

DFeatured on DhanasviCreate & track LinkedIn posts with Google Sheets, GPT-5.1, Unsplash, and Sona 0