Automation that streamlines inquiry intake from Google Forms, uses OpenAI to parse intent and generate structured responses, routes high-intent leads to a Google Sheets lead tracker with a Gmail concierge reply, routes general inquiries to a Google Sheets log with Slack team notification and Gmail reply, and sends Slack admin alerts for Google Forms or OpenAI failures.
Make · workflow canvasproduction build
Context
The concierge team needed to reduce manual triage on incoming form inquiries, automatically classify them by intent, respond faster to high-priority leads, and maintain a clean audit trail in Google Sheets while keeping the team informed via Slack.
Approach
Built a Make.com scenario that watches Google Forms responses, sends each submission to OpenAI for intent parsing and structured response generation, maps the AI output into workflow variables, routes high-intent leads to a Google Sheets lead tracker and sends a Gmail concierge reply, routes general inquiries to a general inquiry log sheet with Slack notification and Gmail reply, and includes separate Slack admin alerts for Google Forms trigger failures and OpenAI processing errors.
Architecture
Trigger
Google Forms Watch Response
OpenAI: Parse Intent + Generate Response
Variable Mapping: Parse AI Output into Variables
Router
High-Intent Leads: Google Sheets: Add Row to Lead Tracker
Gmail: Send Concierge Reply
General Inquiries
Google Sheets: Add Row to General Inquiry Log
Slack Notification
Gmail: Send Concierge Reply
Errors
Slack: Alert Admin on Form Error + Slack: Alert Admin on OpenAI Error
