AutomationMart
Home/Browse/AI competitor review analyzer with Dumpling AI + GPT-4o + Google Sheets
n8n

AI competitor review analyzer with Dumpling AI + GPT-4o + Google Sheets

n8nn8n6 modulesv1.0
AirtableGoogle SheetsOpenAI

Who is this for? This workflow is perfect for marketers, SEO specialists, product teams, and competitive analysts who want to monitor and summarize public reviews of their competitors. It’s especially helpful for small teams who want fast insights from Google reviews without spending hours manually reading and sorting them. --- What problem is this workflow solving? Manually going through competitor reviews is time-consuming and repetitive. You risk missing patterns or insights, and it’s hard to

At a glance

AI competitor review analyzer with Dumpling AI + GPT-4o + Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Airtable, Google Sheets, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Airtable, Google Sheets, OpenAI
Modules
6
Price
Free
Version
v1.0
AI competitor review analyzer with Dumpling AI + GPT-4o + Google Sheets workflow diagram

About this workflow

Who is this for? This workflow is perfect for marketers, SEO specialists, product teams, and competitive analysts who want to monitor and summarize public reviews of their competitors. It’s especially helpful for small teams who want fast insights from Google reviews without spending hours manually reading and sorting them. --- What problem is this workflow solving? Manually going through competitor reviews is time-consuming and repetitive. You risk missing patterns or insights, and it’s hard to share summaries with your team quickly. This workflow automatically scrapes reviews from Google and generates a structured summary of pain points and positive feedback. That way, you can focus on strategy instead of sorting through dozens of reviews. --- What this workflow does This automation watches for new competitor entries in a Google Sheet, then: 1. Uses Dumpling AI to scrape the latest Google reviews (up to 20) for each business. 2. Splits and cleans the reviews for analysis. 3. Sends them to GPT-4o, which summarizes the most common complaints and praises. 4. Saves the structured result back to the same Google Sheet. You’ll instantly get an overview of what people are saying about any competitor. --- Setup 1. Google Sheet Setup - Create a Google Sheet with at least one column: Business - Add names or search queries for the competitors you want to analyze - Optional: Add columns for Summary of Reviews and Pain Points 2. Connect Dumpling AI - Sign up at Dumpling AI - Create an agent using the get-google-reviews endpoint - Copy your agent key - Use it in the HTTP Request node in this workflow 3. OpenAI Setup - Use your API key with GPT-4o access - The prompt is already structured to generate grouped summaries from reviews 4. Run the Workflow - Trigger it manually or schedule it - Make sure your Google Sheets, OpenAI, and Dumpling AI connections are active --- How to customize this workflow to your needs - You can expand the number of reviews retrieved by changing the Dumpling AI agent config - Replace Google Sheets with Airtable if you want more robust data views - Add more fields like star ratings or review dates in your agent for richer analysis - Change the GPT prompt to highlight emotional tone, urgency, or feature mentions --- 🧠 Node Details - Google Sheets Trigger: Watches for new competitor names - HTTP Request (Dumpling AI): Scrapes 20 recent reviews from Google - SplitOut Node: Breaks review array into individual items - Code Node: Extracts and combines review text - Edit Fields Node: Structures the review content before GPT - GPT-4o Node: Analyzes and summarizes top pain points and praise - Google Sheets Output: Saves the summary back to the same sheet --- Dependencies - Dumpling AI account and review scraping agent setup - OpenAI API key with GPT-4o access - Google Sheets OAuth2 credentials ---

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

Select Microsoft SQL Server database table rows and add them to Google Sheets

Use this template to automatically select rows from a Microsoft SQL Server database table and add them to your Google Sheets spreadsheet.

Free

Save new Base.com orders to a Google Sheets spreadsheet

Every time a new order is created in Base.com, Make will automatically add it to a new row in a Google Sheet spreadsheet. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1yGYB6mOdGQL8ZJUSVcQ9dzJTPJYyI3zVoCnjA_VABic/edit?usp=sharing)

Free

Validate e-mail addresses by MailerCheck and create new customers in WooCommerce for new Google Sheets rows

Every time a new row is added to a Google Sheet, Make will automatically validate the email address by MailerCheck and create new customer in WooCommerce. The example uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1Dy6ojlUqe5BX8p754tzkpCahaJ8zuQmem3l77gLR-T8/edit?usp=sharing).

Free

Create new enrollments in Coassemble from new rows in a Google Sheets spreadsheet

This template regularly checks for new rows in a Google Sheet spreadsheet and uses the retrieved information to create a new enrollments in Coassemble.

Free

Automate weekly Hollywood film briefing via Tavily and Gemini

This n8n template demonstrates how to build a weekly Hollywood film industry briefing using Tavily for real-time search and Google Gemini for summarization. It sends a concise, emoji‑styled email with movie releases, box office results, industry news, and must‑watch recommendations every week automatically. Use cases: Great for film journalists, entertainment bloggers, or movie enthusiasts who want automated weekly updates without manually checking multiple sources. --- Goo

Free

Google Sheets MCP - AI-powered spreadsheet management

Google Sheets MCP Workflow – AI Meets Spreadsheets! 😄 ✨ What It Does This n8n workflow lets you chat with your spreadsheets using AI + MCP! From reading and updating data to creating sheets, it’s your smart assistant for Google Sheets 📈🤖 🚀 Cool Features 💬 Natural language commands (e.g. "Add a new lead: John Doe") ✏️ Full CRUD (Create, Read, Update, Delete) 🧠 AI-powered analysis & smart workflows 🗂️ Multi-sheet support 🔗 Works with ChatGPT, Claude, and more (via MCP) 💡 Use Cas

Free

Voice & text Telegram assistant with GPT-4.1-mini and conversation memory

Personal AI Assistant on Telegram Who It’s For: - This workflow is designed for developers, founders, community managers, and automation enthusiasts who want to bring a personal AI assistant directly into their Telegram chat. - It lets users interact naturally—either through text or voice messages—and get instant, AI-powered replies without switching apps or opening dashboards. ⚡ What It Does / How It Works 📥 Message Trigger: A Telegram Trigger node listens for incoming messages. 🧭 Sma

Free

Collect & store restaurant customer feedback with Google Sheets and email forms

This n8n template demonstrates how to create an automated customer feedback collection system for restaurants. The workflow triggers when new customer emails are added to an Excel sheet, automatically sends personalized feedback forms, and stores all responses in a separate Excel tracking sheet. Perfect for restaurants wanting to systematically gather customer insights and improve service quality. Good to know Each feedback form is personalized with the customer's name and email All responses

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