Extract marketing insights from Google Reviews using Dumpling AI + GPT-4
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What to replace before upgrading
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) 🤖 GPT-4: Extract Marketing Insights (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (9)
- Think Tool
@n8n/n8n-nodes-langchain.toolThink - n8n Form Trigger
n8n-nodes-base.formTrigger - HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Aggregate
n8n-nodes-base.aggregate - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets
What it does
📄 What this workflow does This workflow helps you analyze Google reviews of any business to generate powerful marketing insights. By simply submitting a business name and its Google Place ID, it fetches the top 30 reviews and uses GPT-4 (via LangChain Agent) to extract valuable customer insights such as marketing angles, customer motivations, product pain points, and voice of customer (VOC) quotes. The output is stored automatically in a connected Google Sheet. --- 👤 Who is this for - Marketing teams looking for messaging inspiration - Founders or product managers exploring customer feedback - Brand strategists gathering real-world insights - Agencies running VOC or sentiment analysis --- 🛠️ Requirements - Dumpling AI API key - OpenAI GPT-4 or GPT-4o access - Google Sheets connection - A form or manual input with: - Business Name - Google Place ID --- ⚙️ How to set up 1. Connect Credentials - Dumpling AI (via HTTP Header Auth) - OpenAI (GPT-4) - Google Sheets (OAuth2) 2. Prepare your Google Sheet - Create columns: Business Name, Place ID, Marketing Angles, Customer Motivations, Frictions and Barriers, Product Opportunities, VOC Snippets 3. Update Nodes - Replace the Google Sheets Document ID and Tab Name with yours - Check that the Dumpling API node is linked to your credential - Optional: tweak the prompt in the LangChain Agent node to fit your tone or goals --- 🤖 How it works (Workflow Steps) 1. User submits business name + Google Place ID 2. Dumpling AI fetches top 30 reviews 3. Workflow aggregates review text 4. GPT-4 via LangChain analyzes the reviews 5. Insights are parsed and logged to Google Sheets --- 💡 Customization Ideas - Push output to Notion, Airtable, or Slack - Add sentiment scoring to prioritize themes - Create summaries for each insight category - Schedule insights to be emailed weekly --- This is a plug-and-play VOC research workflow — great for founders, marketers, and product teams who want actionable data from real customers without doing manual review scraping or summarizing.