Publish brand-compliant Instagram posts with OpenAI, Google Sheets and S3
Ready for 3.0What this workflow does
This AI workflow has 29 nodes and runs on a schedule (every day) (plus 1 other trigger). Along the way it connects Google Sheets, Facebook Graph API, AWS S3 and OpenAI.
How it runs
Trigger: On a schedule (every day) (plus 1 other trigger).
- Set Workflow Config (Edit Fields (Set)): sets or maps fields
- Format Error Alert (Edit Fields (Set)): sets 1 field: alertMessage
- Fetch Logo Image (HTTP Request): calls an HTTP API
- Resize Logo Image (Edit Image): resize
- Fetch Brand Context (HTTP Request): calls an HTTP API
- If: checks a condition and branches into true / false
- Read Instagram Posts (Google Sheets): uses Google Sheets
- Handle Missing Context (Edit Fields (Set)): sets 1 field: error
- If: checks a condition and branches into true / false
- Sort: sorts the items
…plus 17 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (14)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Edit Image
n8n-nodes-base.editImage - Google Sheets
n8n-nodes-base.googleSheets - Sort
n8n-nodes-base.sort - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait - Code
n8n-nodes-base.code - Facebook Graph API
n8n-nodes-base.facebookGraphApi - AWS S3
n8n-nodes-base.awsS3 - Edit Fields (Set)
n8n-nodes-base.set - Error Trigger
n8n-nodes-base.errorTrigger - OpenAI
@n8n/n8n-nodes-langchain.openAi
From the author
Quick overview This workflow runs daily to read a Google Sheets content calendar, use OpenAI to generate brand-compliant Instagram captions and images from a master brand context file, watermark each image with your logo, publish posts via the Facebook Graph…