An end-to-end automated customer feedback

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, Google Gemini AI, Google Sheets, Gmail, Slack, Looker Studio.