Score HVAC leads and send Gmail replies with Claude and Google Sheets
Ready for 3.0Ready 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 23 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Anthropic, Gmail and Google Sheets.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Normalize Lead Data (Code): runs custom JavaScript code
- Update Status to Booked (Google Sheets): update
- Score & Draft with Claude (Anthropic): uses Anthropic
- Parse Claude Response (Code): runs custom JavaScript code
- Route: Hot vs Standard (If): checks a condition and branches into true / false
- Send Reply - Hot Lead (Gmail): uses Gmail
- Send Reply - Standard Lead (Gmail): uses Gmail
- Merge: merges the data from its input branches
- Search Google Sheets by Email/Phone (Google Sheets): uses Google Sheets
- Send Lead Brief to Sales (Gmail): uses Gmail
…plus 11 more steps. See the full node list below.
Services it uses
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 (8)
- Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - Anthropic
@n8n/n8n-nodes-langchain.anthropic - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Merge
n8n-nodes-base.merge - Google Sheets
n8n-nodes-base.googleSheets - Wait
n8n-nodes-base.wait
From the author
Quick overview This workflow captures HVAC leads from a Tally form webhook, normalizes the submission data, uses Anthropic Claude to score and draft a reply, emails the lead and your sales team via Gmail, logs/deduplicates the lead in Google Sheets, and sends…