Publish Instagram carousels from Google Sheets using Gemini and GCS
Ready for 3.0What this workflow does
This AI workflow has 45 nodes and runs on a schedule (every day at 12:00). Along the way it connects Google Sheets, Google Gemini Chat Model, Google Cloud Storage and Facebook Graph API and 1 more. It also calls generativelanguage.googleapis.com over HTTP.
How it runs
Trigger: On a schedule (every day at 12:00).
- Read Carousel Row (Google Sheets): read (sheet)
- Select First Eligible Carousel Row (Code): runs custom JavaScript code
- Carousel Row Eligible? (If): checks a condition and branches into true / false
- Mark Carousel Row Processing (Google Sheets): update (sheet)
- Prepare Carousel Inputs (Edit Fields (Set)): sets 7 fields: Topic, TargetAudience, BrandVoice…
- Generate Carousel Concept (Basic LLM Chain): sends a prompt to an LLM, with model: Gemini — Carousel Concept; output parser: Parse Carousel Concept
- Generate Carousel Caption (Basic LLM Chain): sends a prompt to an LLM, with model: Gemini — Carousel Caption; output parser: Parse Carousel Caption
- Generate 5–6 Carousel Slides (Basic LLM Chain): sends a prompt to an LLM, with model: Gemini — Carousel Slides; output parser: Parse Carousel Slides
- Build Carousel Slide Prompts (Code): runs custom JavaScript code
- Generate Carousel Slide Image (HTTP Request): calls generativelanguage.googleapis.com (POST)
…plus 28 more steps. See the full node list below.
Services it uses
HTTP calls to: generativelanguage.googleapis.com
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 (17)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - HTTP Request
n8n-nodes-base.httpRequest - Convert to File
n8n-nodes-base.convertToFile - Edit Image
n8n-nodes-base.editImage - Google Cloud Storage
n8n-nodes-base.googleCloudStorage - Facebook Graph API
n8n-nodes-base.facebookGraphApi - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Stop and Error
n8n-nodes-base.stopAndError - Wait
n8n-nodes-base.wait - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow runs daily, reads a queued carousel request from Google Sheets, uses Google Gemini to generate a concept, caption, and 5–6 slide prompts, creates slide images, uploads them to Google Cloud Storage, and publishes the carousel to…