Marketing

AI Social Media Posting with Approval

Generates posts and images for LinkedIn, X and Instagram with AI, holds them in a Google Sheet for approval, then publishes approved posts and saves the live links.

The AI Social Media Posting with Approval workflow on the n8n canvas, with its 35 nodes and connections
The workflow on the n8n canvas. Click to open it full size.

At a glance

Category
Marketing
Nodes
35
Apps
Google Sheets, OpenAI
Price
Free
Download JSON
On this page

How it works

  1. On schedule, topics are read from the sheet and prompts are generated.
  2. AI writes platform-specific copy and creates an image.
  3. Drafts are saved to the sheet for approval.
  4. Approved posts are published to each platform.
  5. Post URLs are written back to the sheet.

Use cases

  • Social media agencies
  • Founders and personal brands
  • Consistent content calendars

What you need

This workflow connects to these apps.

  • Google Sheets
  • OpenAI
  • n8n

You'll need an n8n instance, on n8n Cloud or self-hosted, and these credentials. Our credentials guide shows how to create each one.

  • Facebook Graph account
  • Google Sheets account
  • Http Bearer Auth account
  • LinkedIn account
  • OpenAI account
  • X OAuth account
  • X account

Data setup

Create these tables with these exact column names before the first run.

TableColumns
Auto social media post → Sheet1Google SheetsIdLinkedIn ContentLinkedIn images urlTwitter ContentTwitter images urlPrompt StatusPosting StatusLinkedin Post URLPosted DateTwitter Post URLLinkedIn images promptLinkedIn Content PromptInstagram Content PromptInstagram images promptTwitter images promptTwitter Content PromptInstagram ContentInstagram images urlInstagram Post URL

Setup

  1. Download the JSON and import it into n8n with Import from File, or copy it and paste it onto an empty canvas. The import guide walks through both.
  2. Connect the credentials listed above.
  3. Point the Sheets, Airtable, Drive, and Slack nodes at your own files and channels.
  4. Replace placeholder emails, phone numbers, and form links with your own.
  5. Times use the America/New York timezone and dates use MM/DD/YYYY. Change them if you need to, then test and activate. The setup guide covers this step by step.

Nodes

NodeType
Schedule TriggerscheduleTrigger
Create a postlinkedIn
Schedule Trigger1scheduleTrigger
Loop Over ItemssplitInBatches
Prompt GenerateopenAi
Schedule Trigger2scheduleTrigger
Check Platformswitch
Append LinkedIn DatagoogleSheets
Append Twitter DatagoogleSheets
LoopsplitInBatches
Loop Over Items2splitInBatches
Switch According Platformswitch
Image GeneratehttpRequest
Content for TwitteropenAi
Content For LinkedInopenAi
Create Tweettwitter
Append Linkedin Post UrlgoogleSheets
Append Twitter Post UrlgoogleSheets
Download ImagehttpRequest
Upload ImagehttpRequest
Download ImghttpRequest
Get Post DatagoogleSheets
Get Content + Image PromptgoogleSheets
Append Content + Img PromptgoogleSheets
Get Topic + Img DescgoogleSheets
Content for InstagramopenAi
Append instagram DatagoogleSheets
Set Image & Captionset
Creating Container IDfacebookGraphApi
Facebook Graph APIfacebookGraphApi
Append instagram Post UrlgoogleSheets
HTTP RequesthttpRequest
Split Itemscode
Split Datacode

Frequently asked questions

Generates posts and images for LinkedIn, X and Instagram with AI, holds them in a Google Sheet for approval, then publishes approved posts and saves the live links. It's a 35-node n8n workflow.

An n8n instance, on n8n Cloud or self-hosted, and credentials for Facebook, Google Sheets, HTTP, LinkedIn, OpenAI, and X. It uses only nodes that ship with n8n, so there's nothing else to install.

It works with 1 table in Google Sheets. Create it with the column names listed under Data setup on this page before the first run.

Download the JSON, then in n8n create a new workflow, open the menu in the top right, and choose Import from File. You can also copy the JSON and paste it onto an empty canvas.

Yes. It's free to download, import, and change, with no sign-up. You only pay for the apps it connects to, where those aren't free on your plan.

Keep exploring
  • n8n canvas of the Scheduled Google Analytics Email Report workflow

    Marketing3 nodes

    Scheduled Google Analytics Email Report

    Pulls key Google Analytics metrics on a schedule and emails a clean performance summary, so clients and stakeholders stay updated without logging in.

  • n8n canvas of the AI Crop Advisory for Farmers workflow

    Agriculture27 nodes

    AI Crop Advisory for Farmers

    Gives farmers practical, AI-generated crop advice based on their soil, crop and live weather. Advice is delivered instantly on sign-up and refreshed daily over WhatsApp.

  • n8n canvas of the AI Email Classifier & Slack Router workflow

    AI Automation11 nodes

    AI Email Classifier & Slack Router

    Reads incoming emails, has AI classify each one (support, sales, billing, HR and so on) and notifies the right team on Slack straight away.