Automate personalized lead responses with website scraping, GPT-4o, and Airtable CRM

by Jordan ✓ · 297 views · created 2025-12-08 · Lead Nurturing, AI Summarization

What this workflow does

This AI workflow has 30 nodes and runs when an HTTP GET request hits its webhook URL (plus 1 other trigger). Along the way it connects Airtable, OpenAI and Gmail.

How it runs

Trigger: When an HTTP GET request hits its webhook URL (plus 1 other trigger).

1. Parse Webhook Data (Edit Fields (Set)): sets 1 field: body
2. Email from calendly? (Switch): routes items into 2 branches
3. key value pair (Code): runs custom JavaScript code
4. Booking email? (Switch): routes items into 2 branches
5. Check to see if record exist already (Airtable): search
6. Covert time to ISO (OpenAI): uses OpenAI
7. have they filled a form already? (Switch): routes items into 2 branches
8. Extract Appointment Date (Code): runs custom JavaScript code
9. Send a message (Gmail): uses Gmail
10. Create a record (Airtable): create

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

Services it uses

AirtableOpenAIGmail

Before you upgrade to n8n 3.0

Nodes used (13)

• Airtablen8n-nodes-base.airtable
• HTTP Requestn8n-nodes-base.httpRequest
• Markdownn8n-nodes-base.markdown
• Mergen8n-nodes-base.merge
• Aggregaten8n-nodes-base.aggregate
• OpenAI@n8n/n8n-nodes-langchain.openAi
• Gmailn8n-nodes-base.gmail
• Coden8n-nodes-base.code
• Switchn8n-nodes-base.switch
• Gmail Triggern8n-nodes-base.gmailTrigger
• Webhookn8n-nodes-base.webhook
• No Operation, do nothingn8n-nodes-base.noOp
• Edit Fields (Set)n8n-nodes-base.set

From the author

This n8n template automatically processes inbound form leads, researches their company via their website, and uses AI to write and send a highly personalized "speed to lead" email instantly. It also tracks subsequent appointment bookings to keep your CRM up…

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