AI Competitor Review Analyzer with Dumpling AI + GPT-4o + Google Sheets

Description

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:

Uses Dumpling AI to scrape the latest Google reviews (up to 20) for each business.
Splits and cleans the reviews for analysis.
Sends them to GPT-4o, which summarizes the most common complaints and praises.
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

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

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

OpenAI Setup
Use your API key with GPT-4o access
The prompt is already structured to generate grouped summaries from reviews

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