AutomationMart
Home/Browse/Extract & analyze Amazon reviews with Apify, Gemini AI & save to Google Sheets
n8n

Extract & analyze Amazon reviews with Apify, Gemini AI & save to Google Sheets

n8nn8n8 modulesv1.0
SlackGoogle SheetsGemini

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
Extract & analyze Amazon reviews with Apify, Gemini AI & save to Google Sheets workflow diagram

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.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n β†’ click the menu β†’ Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

About The ICP Person Scoring Automation Sorting through lists of potential leads manually to determine who's truly worth your sales team's time isn't just tedious, it's incredibly inefficient. Without proper qualification, your team might spend hours pursuing prospects who aren't the right fit for your product, while ideal customers slip through the cracks. How to Automate Identifying Your Ideal Customers With this automation, you'll learn how to automatically score and prioritize leads using da

Free

Monitor Instagram hashtag trends and email HTML reports with Apify and Gmail

Full walkthrough video: What it does This workflow automatically monitors trending content on Instagram using keywords you define. It scrapes the most engaging posts, calculates an engagement score based on likes and comments, ranks content in a leaderboard, and delivers a professional HTML email dashboard β€” while storing historical data in a structured table for long-term trend tracking. No manual research. No tab switching. Just the top-pe

Free

Queue Shopify orders for WhatsApp order review (Part 1 of 2)

Automatically queue fulfilled Shopify orders for WhatsApp review requests. This template watches for Shopify orders that have been fulfilled (shipped) and adds them to a Google Sheet queue for delayed review requests. Use Part 2 to process the queue and send messages. **How it works:** 1. Triggers when a Shopify order is updated 2. Filters for fulfilled orders with valid phone numbers 3. Adds order to Google Sheets queue with a calculated send date **Setup required:** - Shopify store connecti

Free

Monitor Amazon product prices with Bright Data and Google Sheets

Amazon Price Monitoring Workflow This workflow enables you to monitor the prices of Amazon product listings directly from a Google Sheet, using data provided by Bright Data’s Amazon Scraper API. It automates the retrieval of price data for specified products and is ideal for market research, competitor analysis, or personal price tracking. βœ… Requirements Before using this template, ensure you have the following: - A Bright Data account and access to the Amazon Scraper API. - An active API key fr

Free

Create Instagram posts from filtered Google Sheets rows and update the sheet with post details

Automatically create Instagram posts from Google Sheets by filtering rows, then update the sheet with post details using Instagram Business and Google Sheets modules.

Free

Create Slack messages for new successful ThriveCart orders

Every time a new successful order is completed in your ThriveCart, Make will send a Slack message with some information on it.

Free

AI-powered Asana task prioritization with GPT-4 and Pinecone memory

Replace manual task prioritization with intelligent AI reasoning that thinks like a Chief Operating Officer. This workflow automatically fetches your Asana tasks every morning, analyzes them using advanced AI models, and delivers the single most critical task with detailed reasoning - ensuring your team always focuses on what matters most. ✨ What This Workflow Does: - πŸ“‹ Automated Task Collection: Fetches all assigned Asana tasks daily at 9 AM - πŸ€– AI-Powered Analysis: Uses OpenAI GPT-4 to evaluat

Free

Generate UGC-style AI videos with Google Sheets, NanoBanana Pro and Veo 3.1

AI-Powered UGC Video Generator Automatically create consistent, professional UGC (User-Generated Content) videos at scale using cutting-edge AI models. This workflow combines three reference images into hyper-realistic selfie-style photos, then transforms them into engaging 8-second videos perfect for TikTok, Instagram Reels, and social media ads. ✨ What This Workflow Does Part 1: Image Generation - Combines 3 reference images (product + character + background) using NanoBanana Pro - AI agent ge

Free

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.

Log in to review
Free
No ratings yet

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.

β‚Ή2,499/ session
3 hrs Β· video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free