- The Artificial Newsletter
- Posts
- Build a No-Code Website Lead Capture Bot with n8n
Build a No-Code Website Lead Capture Bot with n8n
— Issue #22 of The Artificial Newsletter
Intro: In this tutorial, I’ll walk you through building a complete lead capture bot for your website using n8n, without writing a single line of code. This bot will capture leads from a web form, store them in a Google Sheet, send automated follow-up emails, and notify your team on Microsoft Teams. This is a complete DIY automation project you can implement in a few hours.
🏋️ Prerequisites
An n8n account (Cloud or Self-hosted)
A Google account (for Sheets)
A Microsoft Teams account (optional, for notifications)
A Gmail account (for sending emails)
🔧 Step 1: Create a Webhook Form Trigger in n8n
In n8n, add a Form Trigger node.
Configure it as:
Title:
Capture Leads from Website
Description:
Anyone coming to our website
Fields:
Company Name (Required)
Email Address (Required)
Support Area (Dropdown-configure as per your requirements): example- Workday, Odoo, Automation Services
Deploy the form and copy the public form URL.
Outcome: Now you have a form ready to capture leads directly from your website.

🔄 Step 2: Filter Incoming Leads
Add a Filter node after the Form Trigger.
Set the filter condition:
Only allow entries where Support Area is not empty (expression:
)
This prevents blank submissions from cluttering your data.

🗃️ Step 3: Append Lead Details to Google Sheets
Add a Google Sheets node.
Set it to Append or Update Row.
Map the columns as:
Company Name
Email
Support Area
Submitted At (use the expression
{{$today}}
)Selected (
TRUE
if "Workday" is selected, elseFALSE
)
Connect your Google Sheets OAuth2 credentials.
Outcome: Each lead is saved automatically in your Google Sheet.
📧 Step 4: Send Automated Emails for Workday Leads
Add a Switch node to check the Support Area:
If not blank, send an email.
Else, do nothing.
Add a Gmail node:
To:
{{ $json.Email }}
Subject:
Your Free Trial
Body:
Dear User, get your free Trial by XYZ Consulting
📢 Step 5: Notify Your Team on Microsoft Teams
Add a Microsoft Teams node.
Send a message to your chosen channel:
Outcome: Your sales/support team gets notified in real-time.
🔹 Final Flow
When form is submitted ➔ Filter data ➔ Add to Google Sheet ➔ Send Email if Workday ➔ Notify Team
This simple flow ensures:
No leads are missed.
Leads are immediately nurtured.
Your team is always in the loop.
🌐 Deploy It on Your Website
Add the form link on your website’s "Contact Us" or "Get a Quote" page.
Style it with your branding.
🔗Let us know if you would like to get the json file for this workflow!!