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

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!