Automate Web Forms to Google Sheets & Gmail with n8n

Automate Web Forms to Google Sheets & Gmail with n8n

October 9, 2026 | Umair Alam | 5 min read

When a potential client fills out a contact form on your website, every minute counts. Research consistently reveals that businesses responding to inbound inquiries within 5 minutes are 9 times more likely to convert leads into paying customers compared to those who wait even an hour.

Yet, in most small businesses and freelancing setups, incoming inquiries sit unattended in an inbox for hours—or require tedious, manual copy-pasting into spreadsheets and CRM databases.

Proprietary automation platforms like Zapier or Make will gladly solve this problem for you, but at a steep cost: connecting a form webhook to Google Sheets and triggering an email notification costs 2 to 3 task executions per submission. At scale, you quickly face monthly SaaS subscription bills of $30 to $100+.

Feature Zapier / Make Self-Hosted n8n Pipeline
Monthly Cost $29.99 – $99+/month $0.00 (100% Free Forever)
Execution Limits Strict task quotas UNLIMITED Executions
Response Speed 1 to 15 min polling intervals Instant Real-Time Webhooks
Data Privacy Stored on 3rd-party servers 100% Private on Your Server

In this tutorial, you will learn how to build your own “Silent Secretary” automation robot using n8n. In just three simple, visual nodes, this workflow will:

  1. Capture inbound lead information using n8n’s native Form Trigger (no complex website code required).
  2. Automatically append every lead into a centralized Google Sheets CRM database.
  3. Instantly dispatch personalized notification and confirmation emails via Gmail.

Prerequisites & Architecture Overview

Before building the workflow, make sure you have the following ready:

  • An Active n8n Instance: If you don’t have n8n running yet, follow my master guide on How to Self-Host n8n for Free Forever with Docker & VPS.
  • A Google Account: Used to connect Google Sheets and Gmail via secure OAuth2 credentials.
  • A Target Google Sheet: A spreadsheet with labeled column headers to store your incoming leads.

Step 1: Setting Up the n8n Form Trigger Node

One of n8n’s most powerful native features is the n8n Form Trigger. Unlike traditional webhooks that require you to build custom frontend code, the Form Trigger generates a clean, responsive hosted web form URL out of the box.

  1. Open your n8n canvas and click Add first step (+).
  2. Search for n8n Form Trigger and select it.
  3. Set the Form Title to Client Inquiry & Discovery Form.
  4. Add your form fields:
    • Full Name (Text, Required)
    • Email Address (Email, Required)
    • Phone Number (Text, Optional)
    • Service Needed (Dropdown: Custom Automation, Web Development, AI Consulting)
    • Project Message (Textarea, Required)
  5. Copy the Test URL, submit a test entry in your browser, and confirm the incoming JSON payload appears in n8n.

Step 2: Logging Inbound Leads into Google Sheets

Create a new spreadsheet in Google Drive titled Inbound Leads CRM with the following header row:

Timestamp | Full Name | Email | Phone | Service | Message | Status

Configuring the Google Sheets Node in n8n:

  1. Connect a Google Sheets node to the output of your Form Trigger.
  2. Authenticate with your Google account using Google Sheets OAuth2 API.
  3. Set Operation to Append Row.
  4. Select your Inbound Leads CRM spreadsheet and Sheet1.
  5. Map your columns using n8n expressions:
    • Timestamp: {{ $now.format('YYYY-MM-DD HH:mm:ss') }}
    • Full Name: {{ $json.Full_Name }}
    • Email: {{ $json.Email_Address }}
    • Phone: {{ $json.Phone_Number }}
    • Service: {{ $json.Service_Needed }}
    • Message: {{ $json.Project_Message }}
    • Status: New Lead
  6. Click Test Step and watch the row populate live in Google Sheets!

Step 3: Triggering Instant Gmail Notifications

Speed to lead is everything. We will now configure Gmail to send instant alerts:

  1. Connect a Gmail node to the output of your Google Sheets node.
  2. Authenticate using Gmail OAuth2 credentials.
  3. Set Operation to Send.
  4. To: Enter your admin notification email address.
  5. Subject: New Lead: {{ $('n8n Form Trigger').item.json.Full_Name }} - {{ $('n8n Form Trigger').item.json.Service_Needed }}
  6. Body Type: Set to HTML and include lead details so you can immediately respond from your phone.

Pro Tip: Auto-Reply to the Client
Add a second branch to send a personalized confirmation email to {{ $('n8n Form Trigger').item.json.Email_Address }} thanking them for reaching out and confirming when your team will respond.

Step 4: Connecting Existing Website Forms (WordPress, Elementor, HTML)

If you already have a contact form on your WordPress site (e.g., Elementor Pro Forms, Contact Form 7, or Gravity Forms), you don’t need to rebuild it:

  1. Replace the Form Trigger with a standard Webhook node set to POST.
  2. In your WordPress form settings, select Actions After Submit → Webhook.
  3. Paste your n8n Production Webhook URL. All submissions will stream directly into your Google Sheets and Gmail pipeline!

Expanding Your Automation Pipeline

Once your lead capture engine is live, check out my companion automation guides:

Frequently Asked Questions (FAQ)

Does Google charge for using the Google Sheets or Gmail API?

No. Standard personal and Google Workspace accounts include thousands of free daily API calls, which easily covers standard business lead volume.

What happens if my self-hosted n8n server goes offline?

If the server is down, webhooks cannot be received. That is why I recommend running n8n on an affordable 24/7 cloud VPS (like Hostinger or DigitalOcean) rather than a local laptop that goes to sleep.

Summary & Next Steps

By connecting an n8n Form Trigger, Google Sheets, and Gmail, you eliminate manual data entry and respond to prospects within seconds—saving hundreds of dollars each year in SaaS subscription fees.

Umair Alam

Written by

Umair Alam

Business Automation Specialist & Technical Developer with 17+ years of experience in enterprise IT, database development, and modern web technologies. I specialize in bridging the gap between complex organizational workflows and automated digital systems.