Automated AI content creation & Instagram publishing from Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 18 nodes and runs on a schedule (every day). Along the way it connects Google Sheets, Google Gemini Chat Model and Facebook Graph API. It also calls api.replicate.com over HTTP.
How it runs
Trigger: On a schedule (every day).
- 1. Get Next Post Idea from Sheet (Google Sheets): uses Google Sheets
- 2. Prepare Input Variables (Topic, Audience, etc.) (Edit Fields (Set)): sets 4 fields: Topic, TargetAudience, BrandVoice…
- 3a. Generate Content Concept (Gemini) (Basic LLM Chain): sends a prompt to an LLM, with model: (LLM Model for Concept); output parser: (Parse Concept JSON)
- 3b. Generate Image Prompt Options (Gemini) (Basic LLM Chain): sends a prompt to an LLM, with model: (LLM Model for Prompts); output parser: (Parse Prompts JSON)
- 3c. Generate Post Caption (Gemini) (Basic LLM Chain): sends a prompt to an LLM, with model: (LLM Model for Caption); output parser: (Parse Caption JSON)
- 4. Generate Image using Prompt 1 (Replicate Flux) (HTTP Request): calls api.replicate.com (POST)
- 5. Prepare Data for Instagram API (Edit Fields (Set)): sets 2 fields: ImageURL, Caption
- 6a. Create Instagram Media Container (Facebook Graph API): uses Facebook Graph API
- 6b. Wait for Container Processing (Wait): pauses before continuing
- 6c. Publish Post to Instagram (Facebook Graph API): uses Facebook Graph API
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: api.replicate.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 (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - HTTP Request
n8n-nodes-base.httpRequest - Facebook Graph API
n8n-nodes-base.facebookGraphApi - Wait
n8n-nodes-base.wait
From the author
Automated AI Content Creation & Instagram Publishing from Google Sheets This n8n workflow automates the creation and publishing of social media content directly to Instagram, using ideas stored in a Google Sheet. It leverages AI (Google Gemini and Replicate…