Module 7 • Beginner6 min read

Lead Form to Google Sheet: Building an Automated Lead Tracker

Capturing website inquiries promptly is essential for business growth. In this practical tutorial, we will build an automated workflow that listens for incoming website contact form submissions and appends them to a clean Google Sheet instantly.

⚠ Independent Educational Guide

This guide is an independent educational tutorial created by TechIdea for local staging and learning purposes. TechIdea is not sponsored by, endorsed by, or affiliated with **n8n.io** or third-party automation tools.

Course Progress

n8n Automation Course for Beginners

Lesson 7 of 10

70% Complete

Previous Lesson

Automating Invoice Payment Reminders in n8n

Next Lesson

CRM Automation Guide: Syncing Leads and Activity Logs

What you will learn in this lesson

How to connect website form webhooks to n8n.

How to use Set nodes to structure incoming lead data.

How to configure Google Sheets nodes to append new rows dynamically.

How to test the complete lead capture pipeline.

Workflow Execution Blueprint

Click on any node below to inspect its execution role and data requirements.

Node 1: Submit Website Form

Execution Step #1 for Submit Website Form. Data is passed securely via standard JSON payloads.

Step-by-Step Integration Guide

1
Create a Google Sheet with header columns: Name, Email, Phone, Message, and Date.
2
In n8n, add a Webhook trigger node and copy the test URL.
3
Submit a test inquiry on your website contact form pointing to the webhook URL.
4
Inspect the captured JSON payload in n8n to ensure all form fields are present.
5
Add a Set node to map incoming variables into clean key-value pairs.
6
Connect a Google Sheets Action node, authenticate, and select 'Append Row'.
7
Map the Set node variables directly to your spreadsheet headers and activate the workflow.

Sample Incoming Trigger Payload (JSON)

Use this mock payload in your Webhook Tester node to simulate execution.

{
  "name": "Clara Oswald",
  "email": "clara@tardis.com",
  "message": "Consulting required."
}

Expected Node Output Result

Verify your workflow execution logs match this delivery status.

Row successfully appended to 'Lead_Tracker' spreadsheet.

Mistakes to avoid

- Changing spreadsheet header text after configuring node mapping.
- Forgetting to switch the webhook node from test mode to active production mode.
- Exposing webhook URLs in client-side HTML source code.

Actionable Pairings

Put this guide into practice

Explore free client-side tools, AI prompts, and automation templates tailored for this topic.

Interactive Tools

Automation Idea Generator

Explore free interactive utilities for this workflow.

AI Prompt Library

n8n Workflow Planning Blueprint

Copy structured AI prompts to plan this automation.

n8n Templates

Website Lead Form to Google Sheet

Import pre-built n8n node configurations instantly.

Frequently asked questions

Can I add email notifications to this workflow?

Yes. Simply connect a Gmail Action node after the Google Sheets node to send an instant confirmation email to the prospect.

Course Progress

n8n Automation Course for Beginners

Lesson 7 of 10

70% Complete

Previous Lesson

Automating Invoice Payment Reminders in n8n

Next Lesson

CRM Automation Guide: Syncing Leads and Activity Logs

Custom Services & Automation

Need a custom website, AI tool, SEO setup, or business automation for your business?

TechIdea.online shares free tools and guides. If you need a custom solution, you can contact our team for website development, SEO setup, AI tools, and automation support.

Web Dev

AI Solutions

SEO Audit

Automation

Contact Our Team

No obligation consultation

TechIdea Intelligence

Preparing your strategy studio

Step-by-Step Integration Guide

Create a Google Sheet with header columns: Name, Email, Phone, Message, and Date.

In n8n, add a Webhook trigger node and copy the test URL.

Submit a test inquiry on your website contact form pointing to the webhook URL.

Inspect the captured JSON payload in n8n to ensure all form fields are present.

Add a Set node to map incoming variables into clean key-value pairs.

Connect a Google Sheets Action node, authenticate, and select 'Append Row'.

Map the Set node variables directly to your spreadsheet headers and activate the workflow.