Lead Capture • Beginner 15 minutesBest for Freelancers & Small Businesses

Automate Website Lead Form Submissions to Google Sheets

Instantly capture incoming website inquiries and append them to a structured Google Spreadsheet spreadsheet without manual data entry.

Tools Connected:Website Form (Webhook)n8n / MakeGoogle Sheets

⚠ Independent Educational Template

This guide is an independent educational workflow configuration blueprint created by TechIdea. We are not sponsored by, endorsed by, or affiliated with **n8n.io** or third-party platform providers.

The Manual Bottleneck Solved

Manual data copying from email notifications to spreadsheets is slow, prone to human error, and delays incoming sales follow-ups.

Workflow Node Architecture Blueprint

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

Node 1: Website Form Submission

Execution Step #1 for Website Form Submission. Data is parsed securely via JSON variables.

Step-by-Step Node Setup Guide

1
Create a new Google Sheet with header columns: Name, Email, Phone, Message, and Timestamp.
2
In n8n or your automation platform, add a Webhook Trigger node and copy the generated Test URL.
3
Configure your website contact form (WordPress, Webflow, custom HTML) to POST data to the Webhook URL.
4
Submit a test inquiry on your website form to populate the Webhook Trigger with sample JSON data.
5
Add a Google Sheets node, authenticate your Google Service Account, and select action 'Append Row'.
6
Map incoming JSON data fields (Name, Email, Message) directly to your matching spreadsheet columns.
7
Save and activate the workflow to handle incoming inquiries automatically 24/7.

Sample Incoming Trigger Payload (JSON)

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

{
  "name": "Jane Doe",
  "email": "jane@example.com",
  "phone": "+91 98765 43210",
  "message": "Interested in website redesign services."
}

Expected Node Output Result

Verify your workflow execution logs match this delivery status.

Row successfully appended to 'Incoming_Leads_2026' sheet at row #42.

Security & Authentication Notice

Do not expose your webhook trigger URL in frontend public code. Always send form data via a secure backend handler or protected form provider.

Pre-Activation Staging Checklist

Verify that empty form fields do not break the spreadsheet row layout.
Check that timestamp formatting aligns with your local time zone.
Ensure your Google Service Account has Editor permissions on the target spreadsheet.

Mistakes to avoid

- Forgetting to switch the Webhook node from Test mode to Production mode.
- Changing spreadsheet column header names after configuring the mapping node.
- Exposing the private Webhook URL publicly on client-side JavaScript.

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.

Open Tool

JSON Formatter

Explore free interactive utilities for this workflow.

Open Tool

AI Prompt Library

n8n Workflow Planning Blueprint

Copy structured AI prompts to plan this automation.

Open Prompt

Google Sheets Sync Prompts

Copy structured AI prompts to plan this automation.

Open Prompt

Google Sheets Automation Basics

Start Lesson

Frequently asked questions

Does this require a paid n8n subscription?

No. You can self-host n8n for free or use the free tier of cloud automation platforms to run this lightweight workflow.

What happens if Google Sheets goes offline?

n8n caches failed execution attempts. You can configure automatic retry rules to re-attempt appending the row once connectivity is restored.

Explore Other Automation Templates

Billing & Collections