Extract Marketing Insights from Google Reviews Using Dumpling AI + GPT-4

📄 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

Connect Credentials
Dumpling AI (via HTTP Header Auth)
OpenAI (GPT-4)
Google Sheets (OAuth2)

Prepare your Google Sheet
Create columns:
Business Name, Place ID, Marketing Angles, Customer Motivations,
Frictions and Barriers, Product Opportunities, VOC Snippets

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)

User submits business name + Google Place ID
Dumpling AI fetches top 30 reviews
Workflow aggregates review text
GPT-4 via LangChain analyzes the reviews
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.