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

  1. In n8n, add a Form Trigger node.

  2. 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

  3. 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

  1. Add a Filter node after the Form Trigger.

  2. 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

  1. Add a Google Sheets node.

  2. Set it to Append or Update Row.

  3. Map the columns as:

    • Company Name

    • Email

    • Support Area

    • Submitted At (use the expression {{$today}})

    • Selected (TRUE if "Workday" is selected, else FALSE)

  4. Connect your Google Sheets OAuth2 credentials.

Outcome: Each lead is saved automatically in your Google Sheet.

📧 Step 4: Send Automated Emails for Workday Leads

  1. Add a Switch node to check the Support Area:

    • If not blank, send an email.

    • Else, do nothing.

  2. 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

  1. Add a Microsoft Teams node.

  2. 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!!