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

Overview

This tutorial walks you through a powerful n8n automation that uses Dumpling AI, OpenAI’s GPT-4o, and Google Sheets to analyze customer reviews from your competitors and summarize their strengths, weaknesses, and customer feedback patterns.

Whether you’re in SaaS, e-commerce, or services — knowing how customers talk about your competitors gives you clear insight into what works, what doesn’t, and how to position your brand better.

Let’s go step by step.

🧰 Tools You’ll Need

n8n (Self-hosted or cloud)
Dumpling AI (with API key)
OpenAI GPT-4o API
Google Sheets (with competitor review URLs listed)

⚙️ Workflow Breakdown

Step 1: Fetch URLs from Google Sheets

Node: Read URLs from Google Sheet

This node retrieves a list of URLs to competitor review pages (e.g., Trustpilot, G2, Yelp).

Configuration:

Connect your Google account
Select your spreadsheet and sheet
Make sure review URLs are stored under a column titled, for example, competitor_urls

Why it’s important:

This makes your analysis dynamic and easily editable — just update the sheet to track different competitors.

Step 2: Fetch Google Reviews from Dumpling AI

Node Name: Fetch Google Reviews from Dumpling AI Type: HTTP Request

This node sends a POST request to Dumpling AI to retrieve Google Reviews for the given business.

Endpoint: https://app.dumplingai.com/api/v1/get-google-reviews
Method: POST
Payload:

{

“keyword”: “{{ $json[‘Business name’] }}”,

“reviews”: “20”,

“sortBy”: “newest”,

“language”: “en”,

“location”: “United States”

}

This returns up to 20 recent reviews per business.

Step 3: Split Out Reviews List

Node Name: Split Out Reviews List Type: Split Out Item

This node breaks the list of reviews into individual review entries so each one can be processed separately.

Field to split: items

Step 4: Aggregate Review Text

Node Name: Aggregate Review Text Type: Aggregate Items

This aggregates the individual review texts into a single array under the field review_text. This is necessary so all the reviews can be passed together to GPT-4o.

Field to aggregate: review_text

Step 5: GPT-4o: Extract Insights from Reviews

Node Name: GPT-4o: Extract Insights from Reviews Type: OpenAI GPT-4o

This node sends the aggregated review text to GPT-4o using the following structured prompt:

Prompt:

You are a review analysis assistant. Your task is to read a list of customer reviews about a business and extract two main insights:

1. **Challenges or complaints** people are consistently mentioning

2. **Things customers love** or speak highly about

Please analyze the tone, keywords, and patterns in the reviews. Do not just summarize each review. Instead, group similar feedback together and present the top recurring themes.

Respond in this format:

**Top Complaints or Challenges:**

– …

**What People Love About This Business:**

📊 Step 6: Save Summary to Google Sheets

Node Name: Save Summary to Google Sheets Type: Google Sheets

This node appends the result from GPT-4o into the same sheet where the business name was initially listed.

Mapped Columns:

Business name: ={{ $(‘Fetch Google Reviews from Dumpling AI’).item.json.keyword }}
Review text (summary): ={{ $json.message.content }}

Summary of Node Flow

Google Sheets Trigger – Detects a new business row
Fetch Google Reviews from Dumpling AI
Split Out Reviews List into separate reviews
Aggregate Review Text
GPT-4o: Analyze and extract insights
Save summary back into Google Sheet

Pro Tips

Make sure your API keys for Dumpling AI and OpenAI are connected properly.
You can customize the GPT prompt to extract brand sentiment, product feedback, or customer expectations.
Use a separate sheet tab to archive raw reviews if needed.

Use Cases

Competitive Analysis: Track customer perception of competing businesses
Reputation Management: Automatically monitor your own Google reviews
Product Research: Extract what people are asking for or missing

Conclusion

This workflow offers a reliable way to continuously gather and interpret customer sentiment from Google Reviews without any manual reading. By combining the web scraping power of Dumpling AI with the language understanding of GPT-4o, you can extract clear patterns and insights about your competitors or even your own brand in real time.

No more spreadsheets filled with raw text. No more sifting through individual reviews. This system transforms raw customer feedback into business intelligence you can act on immediately.

Set it once, monitor automatically, and make smarter, faster decisions based on actual customer voice.