Get Started
Back to Templates

Automate Personalized Lead Responses with Website Scraping, GPT-4o, and Airtable CRM

Created by

Created by: Jordan || jordan-ai-16

Jordan

Last update

Last update 10 hours ago

Categories

Share

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 to date.

Use cases are focused on high velocity sales: Perfect for agency owners, founders, and sales teams who need to respond to new leads in seconds while maintaining a high quality, personal touch.

Good to know

At the time of writing, this template is optimized for GPT-4o to ensure the highest quality personalization.
This template was originally designed using a Lovable form, but it works with any form builder (Typeform, Webflow, WordPress) that can send data via a webhook.

How it works

  • The workflow starts when a new lead submits your contact form via the Webhook node.
  • It immediately checks your Airtable CRM to ensure the lead is new and not a duplicate.
  • The system scrapes the provided website URL and uses custom code to clean the HTML data.
  • AI analyzes the cleaned website data to generate a concise summary of the business.
  • A second AI step uses this summary and the lead's goals to draft and send a personalized email via Gmail.
  • The lead data and website summary are logged into your Airtable base.
  • A parallel flow monitors your inbox for booking confirmations and updates the CRM automatically.

How to use

  • Create the necessary Base and Table in Airtable to store your leads.
  • Connect your website form to the Webhook URL in the workflow.
  • Update the OpenAI node prompts with your specific email signature and phone number.
  • Run a test submission to ensure the website scraper is capturing data correctly.

Requirements

  • Airtable account
  • OpenAI account (GPT-4o model recommended)
  • Gmail account

Customising this workflow

You can easily adapt this for different communication channels. Try swapping the Gmail node for a Slack notification to alert your team of high value leads, or connect it to HubSpot instead of Airtable for enterprise CRM management.