Google Sheets + GPT-4o: competitor reviews summarized
You start with good intentions: “Let’s scan competitor reviews this week.” Then you open Google, read 80 opinions, lose the thread, and still can’t answer the one question that matters: what do customers consistently love and hate?
This hits marketers and product folks hardest, honestly. But consultants pulling quick competitive intel and founders doing positioning work feel it too. A Sheets review summary automation turns messy public reviews into clean themes you can actually use, without a day of copy-paste.
Below, you’ll see how the workflow pulls Google reviews, summarizes them with GPT-4o, and writes the results back into the same spreadsheet so your team can act on it.
How This Automation Works
See how this solves the problem:
n8n Workflow Template: Google Sheets + GPT-4o: competitor reviews summarized
flowchart LR
subgraph sg0["Google Sheets Trigger – New Business Added Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "Google Sheets Trigger – New ..", pos: "b", h: 48 }
n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Fetch Google Reviews from Du.."]
n2@{ icon: "mdi:swap-vertical", form: "rounded", label: "Split Out Reviews List", pos: "b", h: 48 }
n3@{ icon: "mdi:cog", form: "rounded", label: "Aggregate Review Text", pos: "b", h: 48 }
n4@{ icon: "mdi:robot", form: "rounded", label: "GPT-4o: Extract Insights fro..", pos: "b", h: 48 }
n5@{ icon: "mdi:database", form: "rounded", label: "Save Summary to Google Sheets", pos: "b", h: 48 }
n3 --> n4
n2 --> n3
n1 --> n2
n4 --> n5
n0 --> n1
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n0 trigger
class n4 ai
class n5 database
class n1 api
classDef customIcon fill:none,stroke:none
class n1 customIcon
The Challenge: Turning competitor reviews into usable insights
Reading competitor reviews sounds simple until you try to do it consistently. You search a business, scroll, skim, then realize you’re not sure if “slow service” is a one-off rant or a repeating pattern. Next week you do it again, and you’re starting from scratch because nothing is structured or shareable. Worse, the loudest reviews stick in your memory, even when they are outliers. The real signal (common themes) gets buried under volume and distraction.
It adds up fast. Here’s where it typically breaks down in real teams.
- You spend about 1–2 hours per competitor just to get a “gut feel,” and nobody trusts gut feel in a meeting.
- Copying reviews into a doc gets messy, which means the next person can’t validate what you summarized.
- Patterns slip through because you are switching tabs and trying to remember what you read an hour ago.
- Sharing takes extra work, so insights live in Slack threads and disappear by Friday.
The Fix: Google review scraping + GPT-4o summaries inside Sheets
This workflow turns your spreadsheet into a lightweight competitor monitoring system. You add a competitor name (or search query) as a new row in Google Sheets. That single action triggers n8n to fetch up to 20 recent Google reviews for that business through a Dumpling AI scraping request. The workflow then breaks the reviews into items, cleans and combines the text into a single analysis-ready block, and sends it to GPT-4o with a prompt designed for grouping themes. Finally, it writes a structured summary back into the same sheet, so you have “Top praise” and “Pain points” sitting right next to the competitor name.
The flow starts in Google Sheets and ends in Google Sheets. In the middle, Dumpling AI collects the raw voice-of-customer data, and GPT-4o turns it into a clear set of repeating themes your team can use immediately.
What Changes: Before vs. After
| What This Eliminates | Impact You’ll See |
|---|---|
|
|
Real-World Impact
Say you track 10 competitors. Manually, if you spend about 15 minutes just finding and skimming 20 reviews per competitor, that’s around 2.5 hours, and you still have to write a summary. With this workflow, adding the 10 names into Google Sheets takes maybe 10 minutes total. Dumpling AI pulls the reviews, GPT-4o summarizes, and the sheet updates on its own. You usually get the same insights back in under an hour of hands-off processing, while you do something else.
Requirements
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Google Sheets to store competitor names and results.
- Dumpling AI to scrape Google reviews via HTTP Request.
- OpenAI API key (get it from your OpenAI account dashboard).
Skill level: Beginner. You’ll connect accounts, paste an API key, and confirm your sheet columns match the workflow.
Need help implementing this? Talk to an automation expert (free 15-minute consultation).
The Workflow Flow
A new competitor is added to your sheet. The Google Sheets Trigger watches for a new row (or a new entry in your “Business” column), then kicks off the run automatically.
Reviews are pulled from Google. An HTTP Request hits Dumpling AI’s get-google-reviews agent and retrieves up to 20 recent reviews for that business query, which gives you enough volume to spot patterns without going overboard.
Text gets cleaned and packaged for analysis. The workflow splits reviews into individual items, aggregates the content, and sets the fields into a predictable structure so the AI receives consistent input every time.
GPT-4o extracts themes, then the sheet updates. The OpenAI Chat Model node generates grouped praise and pain-point themes, and the Google Sheets “Update” node writes that output back into your summary columns.
You can easily modify the number of reviews pulled or the summary format based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Google Sheets Trigger
This workflow starts when a new row is added to your Google Sheet.
- Add the Spreadsheet Row Watcher node as the trigger.
- Set Event to
rowAdded. - Select the Document with
Google reviewand Sheet withSheet1. - Credential Required: Connect your googleSheetsTriggerOAuth2Api credentials.
Step 2: Connect Dumpling API Retrieval
This step pulls the latest reviews for each business name added to the sheet.
- Add the Dumpling Review Retrieval node and connect it to Spreadsheet Row Watcher.
- Set URL to
=https://app.dumplingai.com/api/v1/get-google-reviews. - Set Method to
=POSTand enable Send Body. - Set Body Content Type to
jsonand paste the JSON body exactly: - Use
{ "keyword": "{{ $json['Business name'] }}", "reviews": "20", "sortBy": "newest", "language": "en", "location": "United States" }. - Credential Required: Connect your httpHeaderAuth credentials.
keyword field must reference {{ $json['Business name'] }} exactly to match your sheet column.Step 3: Set Up Review Processing and AI Insight Extraction
This stage splits reviews, aggregates them, and generates insights using the AI model.
- Add Divide Review Items and set Field to Split Out to
items. - Add Combine Review Text and aggregate Field to Aggregate as
review_text. - Add AI Insight Extraction and select Model
gpt-4o. - In Messages, keep the system prompt and set the user content to the provided prompt that ends with
{{ $json.review_text }}. - Credential Required: Connect your openAiApi credentials.
Step 4: Configure Output to Google Sheets
This final step writes AI insights back to your summary sheet.
- Add Update Summary Sheet and connect it to AI Insight Extraction.
- Set Operation to
appendOrUpdate. - Select Document
Google reviewand SheetSheet1. - Map Review text to
{{ $json.message.content }}. - Map Business name to
{{ $('Dumpling Review Retrieval').item.json.keyword }}. - Credential Required: Connect your googleSheetsOAuth2Api credentials.
Step 5: Test and Activate Your Workflow
Verify that the workflow runs end-to-end and then enable it for production use.
- Click Execute Workflow and add a new row with a Business name in the source sheet.
- Confirm Dumpling Review Retrieval returns items, Combine Review Text aggregates
review_text, and AI Insight Extraction outputs a summary. - Check Update Summary Sheet for a new or updated row with the AI insights and business name.
- Toggle the workflow Active to enable ongoing monitoring.
Watch Out For
- Google Sheets permissions can be picky. If the sheet won’t update, check the n8n Google Sheets credential and confirm it still has access to that exact file.
- If Dumpling AI returns an empty list (bad query, rate limit, or the place can’t be found), the summary step can fail or produce junk. Test one competitor name first and adjust the search query text in the sheet.
- GPT-4o prompts that are too generic lead to generic summaries. Add your lens early (for example: “pricing complaints,” “delivery speed,” “support quality”) or you’ll be rewriting output by hand.
Common Questions
About 30 minutes if your accounts are ready.
Yes. No coding required, but you will need to connect Google Sheets and paste in two API keys.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API usage and your Dumpling AI plan for scraping.
Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.
You can adjust the Dumpling Review Retrieval request to pull more than 20 reviews, then tweak the AI Insight Extraction prompt to group themes the way your team thinks (pricing, support, onboarding, reliability). If you prefer different storage, you can replace the Update Summary Sheet step with Airtable or Excel. Some teams also add extra columns like star rating and review date so the summary can separate “recent complaints” from older ones.
Usually it’s an expired Google OAuth connection or the sheet was moved to a different Drive location. Reconnect the Google Sheets credential in n8n, then re-select the spreadsheet inside the Spreadsheet Row Watcher and Update Summary Sheet nodes. Also confirm the account you connected has edit access, not view-only.
In practice, most small teams run dozens of competitors per week without issues, because each row triggers one scrape and one GPT call.
Often, yes, especially if you want more control over how reviews get cleaned before the AI sees them. n8n makes it easier to split items, aggregate text, and add conditional logic without constantly bumping into pricing limits. You can also self-host, which matters when you start running this across many competitors and multiple locations. Zapier or Make can still work if your version is extremely simple, but review scraping plus summarization tends to get fiddly. If you want a second opinion before you commit, Talk to an automation expert.
Once this is running, competitor review research stops being a recurring chore and becomes a simple spreadsheet habit. The workflow handles the sorting and summarizing so you can focus on what to change in your messaging and product.
Need Help Setting This Up?
Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.
