Generate market research reports from Google Maps reviews with Gemini AI

by Charles ✓ · 1,532 views · created 2025-08-03 · Market Research, AI Summarization

What this workflow does

This AI workflow has 14 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Gemini Chat Model and Gmail. It also calls serpapi.com over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. User Input Configuration (Edit Fields (Set)): sets or maps fields
2. Dynamic Search Places (HTTP Request): calls serpapi.com
3. Enhanced Extract Data (Code): runs custom JavaScript code
4. Loop Over Places (Loop Over Items (Split in Batches)): loops over the items in batches
5. Collect All Data (Aggregate): combines items into one
6. Get Reviews Content (HTTP Request): calls an HTTP API
7. Prepare Analysis Data (Code): runs custom JavaScript code
8. Enhanced Combine Data (Code): runs custom JavaScript code
9. AI Market Analysis (AI Agent): runs an AI agent, with model: Google Gemini Chat Model
10. Prepare Email Content (Code): runs custom JavaScript code

…plus 2 more steps. See the full node list below.

Services it uses

Google Gemini Chat ModelGmail

HTTP calls to: serpapi.com

Before you upgrade to n8n 3.0

Nodes used (9)

• Manual Triggern8n-nodes-base.manualTrigger
• Edit Fields (Set)n8n-nodes-base.set
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Aggregaten8n-nodes-base.aggregate
• AI Agent@n8n/n8n-nodes-langchain.agent
• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• Gmailn8n-nodes-base.gmail

From the author

🚀 Market Research Analytics System > Transform Google Maps data into actionable business insights with AI-powered analysis 📋 Overview This n8n workflow automatically collects business data from Google Maps, analyzes customer reviews using AI, and…

View the original on n8n.io → Check your own copy