Automate Google Sheets
Workflow Description
An automation template that extracts data from Google Sheets, processes it through AI-powered language models (Gemini), and automatically publishes analyzed results to Facebook on a scheduled basis.
How it works
- 1.Trigger automation at specified time intervals
- 2.Extract data from Google Sheets tables
- 3.Process data through LLM Chain with Gemini AI
- 4.Structure and validate output using parser
- 5.Publish formatted results to Facebook pages automatically
Use cases
- Generate and share weekly sales summaries on Facebook
- Automate monthly report generation from spreadsheets to social media
- Process customer feedback from surveys and rewrite responses using AI
Requirements
- Active Google Workspace account with spreadsheet editing permissions
- Valid API credentials for Gemini or active subscription
- Facebook Business account with connected app and valid access tokens
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (26)
Scheduled Start: Check for New Posts
Schedule Trigger
1. Get Next Post Idea from Sheet
Google Sheets
2. Prepare Input Variables (Topic, Audience, etc.)
Set
3a. Generate Content Concept (Gemini)
LLM Chain
(LLM Model for Concept)
Gemini Model
(Parse Concept JSON)
Output Parser Structured
3b. Generate Image Prompt Options (Gemini)
LLM Chain
(LLM Model for Prompts)
Gemini Model
(Parse Prompts JSON)
Output Parser Structured
3c. Generate Post Caption (Gemini)
LLM Chain
(LLM Model for Caption)
Gemini Model
(Parse Caption JSON)
Output Parser Structured
4. Generate Image using Prompt 1 (Replicate Flux)
HTTP Request
5. Prepare Data for Instagram API
Set
6a. Create Instagram Media Container
Facebook Graph Api
6b. Wait for Container Processing
Wait
6c. Publish Post to Instagram
Facebook Graph Api
7. Update Post Status in Sheet
Google Sheets
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note