Generate and schedule social media posts with OpenAI, Google Sheets and Buffer

by Mostafa · 485 views · created 2026-02-09 · Social Media, Multimodal AI

What this workflow does

This AI workflow has 19 nodes and runs on a schedule (cron 0 6 * * *) (plus 1 other trigger). Along the way it connects Google Sheets, OpenAI and Slack. It also calls api.bufferapp.com over HTTP.

How it runs

Trigger: On a schedule (cron 0 6 * * *) (plus 1 other trigger).

1. Get Pending Content (Google Sheets): uses Google Sheets
2. Prepare Error Data (Edit Fields (Set)): sets 5 fields: error_message, content_id, execution_id…
3. Validate Required Fields (If): checks a condition and branches into true / false
4. Update Sheet - Failed (Google Sheets): update
5. Process Each Item (Loop Over Items (Split in Batches)): loops over the items in batches
6. Send Error Alert (Slack): uses Slack
7. Generate LinkedIn Post (OpenAI): uses OpenAI
8. Send Success Summary (Slack): uses Slack
9. Generate Twitter Post (OpenAI): uses OpenAI
10. Generate Facebook Post (OpenAI): uses OpenAI

…plus 6 more steps. See the full node list below.

Services it uses

Google SheetsOpenAISlack

HTTP calls to: api.bufferapp.com

Before you upgrade to n8n 3.0

Nodes used (10)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Ifn8n-nodes-base.if
• No Operation, do nothingn8n-nodes-base.noOp
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• OpenAI@n8n/n8n-nodes-langchain.openAi
• Edit Fields (Set)n8n-nodes-base.set
• HTTP Requestn8n-nodes-base.httpRequest
• Slackn8n-nodes-base.slack
• Error Triggern8n-nodes-base.errorTrigger

From the author

Automate your social media content pipeline from idea to scheduled post. This workflow reads content ideas from a Google Sheet, uses OpenAI to generate platform-optimized posts for LinkedIn, X (Twitter), and Facebook, then schedules them via Buffer — all with…

View the original on n8n.io → Check your own copy