📄 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.
