Extract & analyze Amazon reviews with Apify, Gemini AI & save to Google Sheets
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 reviews, this template scrapes reviews (specifically targeting negative feedback), uses Google Gemini (AI) to analyze the root causes of dissatisfaction, and generates specific improvement suggestions. The results are automatically logged into
At a glance
Extract & analyze Amazon reviews with Apify, Gemini AI & save to Google Sheets is a ready-made n8n workflow you import as a workflow JSON file β no build required. It connects Slack, Google Sheets, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Slack, Google Sheets, Gemini
- Modules
- 8
- Price
- Free
- Version
- v1.0

About this workflow
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 reviews, this template scrapes reviews (specifically targeting negative feedback), uses Google Gemini (AI) to analyze the root causes of dissatisfaction, and generates specific improvement suggestions. The results are automatically logged into a Google Sheet for easy tracking, and a Slack notification is sent to keep your team updated. This tool is essential for understanding "Voice of Customer" data efficiently without manual data entry. π§ Who is this for - Product Managers looking for product improvement ideas. - E-commerce Sellers (Amazon FBA, D2C) monitoring brand reputation. - Market Researchers analyzing competitor weaknesses. - Customer Support Teams identifying recurring issues. βοΈ How it works 1. Data Collection: The workflow triggers the Apify actor (junglee/amazon-reviews-scraper) to fetch reviews from a specified Amazon product URL. It is currently configured to filter for 1 and 2-star reviews to focus on complaints. 2. AI Analysis: It loops through each review and sends the content to Google Gemini. The AI determines a sentiment score (1-5), categorizes the issue (Quality, Design, Shipping, etc.), summarizes the complaint, and proposes a concrete improvement plan. 3. Formatting: A Code node parses the AI's response to ensure it is in a clean JSON format. 4. Storage: The structured data is appended as a new row in a Google Sheet. 5. Notification: A Slack message is sent to your specified channel to confirm the batch analysis is complete. π οΈ Requirements - n8n (Self-hosted or Cloud) - Apify Account: You need to rent the junglee/amazon-reviews-scraper actor. - Google Cloud Account: For accessing the Gemini (PaLM) API and Google Sheets API. - Slack Account: For receiving notifications. π How to set up 1. Apify Config: Enter your Apify API token in the credentials. In the "Run an Actor" node, update the startUrls to the Amazon product page you want to analyze. 2. Google Sheets: Create a new Google Sheet with the following header columns: sentimentscore, category, summary, improvement. Copy the Spreadsheet ID into the Google Sheets node. 3. AI Prompt: The "Message a model" node contains the prompt. It is currently set to output results in Japanese. If you need English output, simply translate the prompt text inside this node. 4. Slack: Select the channel where you want to receive notifications in the Slack node.
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n β click the menu β Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
LinkedIn person ICP scoring automation with Airtop & Google Sheets
Monitor Instagram hashtag trends and email HTML reports with Apify and Gmail
Queue Shopify orders for WhatsApp order review (Part 1 of 2)
Monitor Amazon product prices with Bright Data and Google Sheets
Create Instagram posts from filtered Google Sheets rows and update the sheet with post details
Create Slack messages for new successful ThriveCart orders
AI-powered Asana task prioritization with GPT-4 and Pinecone memory
Generate UGC-style AI videos with Google Sheets, NanoBanana Pro and Veo 3.1
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint β instant download
- Setup guide PDF included
- 5 downloads Β· valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you