Templates / Capture and schedule HVAC leads with OpenAI, Google Sheets, Slack and SMS

Capture and schedule HVAC leads with OpenAI, Google Sheets, Slack and SMS

Ready for 3.0

by Hyrum Hurst ✓ · 1,798 views · created 2026-01-15 · Lead Generation, AI Summarization

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 15 nodes and runs when someone submits an n8n form (“HVAC Service Request”). Along the way it connects Google Sheets, OpenAI Chat Model, Slack and Google Calendar and 1 more.

How it runs

Trigger: When someone submits an n8n form (“HVAC Service Request”).

  1. Workflow Configuration (Edit Fields (Set)): sets 5 fields: installationSlackChannel, repairSlackChannel, maintenanceSlackChannel…
  2. Normalize Lead Data (Edit Fields (Set)): sets 7 fields: leadName, leadEmail, leadPhone…
  3. Store Lead in Google Sheets (Google Sheets): append or update
  4. Classify Lead Urgency and Service Type (AI Agent): runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
  5. Route by Service Type (Switch): routes items into 3 branches
  6. Notify Installation Team (Slack): uses Slack
  7. Notify Repair Team (Slack): uses Slack
  8. Notify Maintenance Team (Slack): uses Slack
  9. Send Confirmation Email to Lead (Send Email): sends an email over SMTP
  10. Schedule Appointment (Google Calendar): uses Google Calendar

…plus 2 more steps. See the full node list below.

Services it uses

Google SheetsOpenAI Chat ModelSlackGoogle CalendarTwilio

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (12)

From the author

Who this workflow is for Door-to-door HVAC companies seeking automated lead capture and appointment scheduling. What this workflow does AI classifies incoming leads, routes them by service type, logs lead info in Google Sheets, notifies team via Slack, sends…

Excerpt from Hyrum Hurst's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.