Generate & schedule social media content with GPT-4 and Buffer from Google Sheets
Needs changesWhat this workflow does
This AI workflow has 10 nodes and runs on a schedule (legacy Cron node). Along the way it connects Google Sheets and OpenAI. It also calls api.bufferapp.com over HTTP.
How it runs
Trigger: On a schedule (legacy Cron node).
- Configuration Variables (Edit Fields (Set)): sets 5 fields: GOOGLE_SHEET_ID, CONTENT_WORKSHEET, BRAND_VOICE…
- Read Content Calendar (Google Sheets): uses Google Sheets
- Filter Today's Content (Code): runs custom JavaScript code
- Check if Content Exists (If): checks a condition and branches into true / false
- Generate Social Content with AI (OpenAI): create (chat)
- No Content Response (Respond to Webhook): sends the response back to the webhook caller
- Process Generated Content (Code): runs custom JavaScript code
- Schedule Post via Buffer (HTTP Request): calls api.bufferapp.com (POST)
- Update Sheet Status (Google Sheets): update
Services it uses
HTTP calls to: api.bufferapp.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Cron in Daily Content Generation Trigger: replace with Schedule Trigger.
| Removed in 3.0 | Replace with |
|---|---|
| Cron Daily Content Generation Trigger | Schedule Trigger |
Nodes used (8)
- Cron
n8n-nodes-base.cron - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - OpenAI
@n8n/n8n-nodes-langchain.openAi - HTTP Request
n8n-nodes-base.httpRequest - Respond to Webhook
n8n-nodes-base.respondToWebhook
From the author
Who's it for Marketing teams, social media managers, content creators, and small businesses looking to maintain consistent social media presence across multiple platforms. Perfect for organizations that want to automate content creation while maintaining…