Analyze and Summarize Google Reviews with SerpAPI, GPT-4 and Google Sheets

Description

Try It Out!
This n8n template helps you analyze Google Maps reviews for a list of restaurants, summarize them with AI, and identify optimization opportunities—all in one automated workflow.
Whether you're managing multiple locations, helping local restaurants improve their digital presence, or conducting a competitor analysis, this workflow helps you extract insights from dozens of reviews in minutes.

How It Works?
Start with a pre-filled list of restaurants in Google Sheets.
The workflow uses SerpAPI to scrape Google Maps reviews for each listing.
Reviews with content are passed to ChatGPT for summarization.
Empty or failed reviews are logged in a separate tab for easy follow-up.
Results are stored back in your Google Sheet for analysis or sharing

How To Use
Customize the input list in Google Sheets with your own restaurants.
Update the OpenAI prompt if you want a different style of summary.
You can trigger this manually or swap in a schedule, webhook, or other event.

Requirements
A SerpAPI account to fetch reviews
An OpenAI account for ChatGPT summarization
Access to Google Sheets and n8n

Who Is It For?
This is helpful for people looking to analyze a large batch of Google reviews in a short amount of time. Additionally, it can be used to compare restaurants and see where each can be optimized.


How To Set-Up?
Use a SerpAPI endpoint to include in the HTTP request node. Refer to this n8n documentation for more help! https://docs.n8n.io/integrations/builtin/cluster-nodes/sub-nodes/n8n-nodes-langchain.toolserpapi/.

Happy Automating!