Extract & analyze Amazon reviews with Apify, Gemini AI & save to Google Sheets
UnknownWhat this workflow does
This AI workflow has 8 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Slack, Google Sheets, Google Gemini and Apify (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Workflow Configuration (Edit Fields (Set)): sets 2 fields: maxReviews, apifyActorId
- Run an Actor and get dataset (Apify): run actor and get dataset
- Loop Over Reviews (Loop Over Items (Split in Batches)): loops over the items in batches
- Slack: uses Slack
- Message a model (Google Gemini): uses Google Gemini
- Code: runs custom JavaScript code
- Create spreadsheet (Google Sheets): work with spreadsheet
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 @apify/n8n-nodes-apify is verified or supports 3.0 (used in Run an Actor and get dataset).
Nodes used (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Slack
n8n-nodes-base.slack - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - Apify
@apify/n8n-nodes-apify.apify
From the author
Template Description 📝 Template Title Analyze Amazon product reviews with Gemini and save to Google Sheets 📄 Description This workflow automates the process of analyzing customer feedback on Amazon products. Instead of manually reading through hundreds of…