An end-to-end automated customer feedback pipeline designed to shield public business ratings while converting positive customer sentiment into 5-star public reviews.
Key System Features:
• Real-time Intake & Routing: Captures responses via Google Forms and logs them into a Master Database in Google Sheets.
• Smart AI Sentiment Branching: Evaluates sentiment using Google Gemini AI to trigger custom email workflows:
Positive Feedback: Auto-sends an email encouraging customers to post on official Google Business pages.
Neutral Feedback: Triggers a private follow-up request to gather actionable feedback off public channels.
Negative Feedback: Suppresses review links and instantly alerts management via email/Slack while pre-drafting a personalized recovery response. • Executive Intelligence: Automatically aggregates weekly feedback trends and generates executive summary digests complete with direct interactive Looker Studio dashboard links.
Tech Stack: Make.com (http://Make.com), Google Gemini AI, Google Sheets, Gmail, Slack, Looker Studio.
1
48
