Score HVAC leads and send Gmail replies with Claude and Google Sheets

Description

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 scheduled follow-ups unless the lead is marked booked.

How it works
Receives a Tally form submission via a webhook.
Normalizes the submitted fields into a consistent lead record (name, email, phone, service type, urgency, message, response ID) and cleans email/phone formatting.
Sends the lead details to Anthropic Claude to classify the lead (hot/warm/cold) and generate a short personalized reply email, then parses the JSON result.
Sends the drafted reply to the lead via Gmail, using a separate route for hot leads versus standard leads.
Emails a formatted lead brief (including the AI score, signals, and the sent email copy) to your sales team via Gmail.
Searches Google Sheets for an existing lead by email or phone and updates the matching row or appends a new row to log the lead.
Waits two days, checks the lead’s status in Google Sheets by response ID, and sends a Day 2 follow-up email via Gmail if the status is not “Booked”.
Optionally waits three more days and repeats the status check to send a Day 5 follow-up, while a separate booking webhook updates the Google Sheets row to “Booked” to stop further follow-ups.

Setup
Create and connect credentials for Anthropic, Gmail (OAuth2), and Google Sheets (OAuth2) in n8n.
In all Google Sheets nodes, replace YOUR_GOOGLE_SHEET_ID and ensure your sheet has the required columns (including Email, Phone, Response ID, and Status).
Set the sales notification recipient by updating the “Send Lead Brief to Sales” Gmail node’s sendTo value.
Copy the production webhook URLs for /hvac-speed-to-lead (Tally submissions) and /hvac-lead-booked (booking confirmations) and configure them in Tally and your booking system.
If you use deduplication, set the Google Sheets search to combine filters with OR (email OR phone) so existing leads are found and updated correctly.

Requirements
Anthropic (Claude) API account
Gmail account (OAuth2)
Google Sheets account (OAuth2)
Tally form (or any webhook-capable form tool)

Customization
Swap the scoring prompt for another trade (plumbing, roofing, etc.), adjust the Hot/Warm/Cold scoring criteria, or change the Day 2/Day 5 follow-up timing.