Collect reviews, analyze sentiment, and generate reports with Decodo and Google Gemini
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 14 nodes and runs on a schedule (every day) (plus 1 other trigger). Along the way it connects Airtable, Google Gemini Chat Model, Google Sheets and Gmail and 1 more.
How it runs
Trigger: On a schedule (every day) (plus 1 other trigger).
- Search records (Airtable): search
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Decodo: uses Decodo
- Code: runs custom JavaScript code
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model
- Analyzer (AI Agent): runs an AI agent, with model: Google Gemini Chat Model
- Delay until next cycle (Wait): waits 50 seconds
- Send a message (Gmail): uses Gmail
- Append row in sheet (Google Sheets): append
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @decodo/n8n-nodes-decodo is verified or supports 3.0 (used in Decodo).
Nodes used (10)
- Airtable
n8n-nodes-base.airtable - Decodo
@decodo/n8n-nodes-decodo.decodo - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - Wait
n8n-nodes-base.wait
From the author
This n8n workflow automates review collection, analysis, and reporting by scraping review links from Airtable, extracting structured review data, storing it in Google Sheets, and generating AI-powered sentiment insights using Google Gemini. Use Cases…