Analyze and summarize Google Reviews with SerpAPI, GPT-4 and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 8 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI and Google Sheets. It also calls serpapi.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Pull Sample Restaurants (Google Sheets): uses Google Sheets
- Get Data (HTTP Request): calls serpapi.com
- Cleans It Up (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- Analyze Review Sentiment (OpenAI): uses OpenAI
- Failed Reviews (e.g. review text = empty) (Google Sheets): append
- Export Data (Google Sheets): append
Services it uses
HTTP calls to: serpapi.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - If
n8n-nodes-base.if - OpenAI
@n8n/n8n-nodes-langchain.openAi - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets
From the author
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…