Automated Web Form Data Collection to Google Sheets

Overview

This n8n workflow collects data from web forms and automatically stores it in a Google Sheet. It includes data cleanup, date stamping, optional batching, and throttling for smooth handling of single or bulk submissions.

What It Does

• Accepts data submitted via HTTP POST
• Cleans and structures incoming JSON data
• Adds the current date automatically
• Appends structured data into a predefined Google Sheet
• Supports optional batch processing and delay for large submissions

Features

• Webhook trigger for external form submissions
• JavaScript-based data cleaning and formatting
• Looping and delay nodes for bulk submissions
• Direct Google Sheets integration via OAuth2
• Custom date field (submitted_date) auto-generated per entry

Who Is It For

• Developers or marketers collecting lead data via forms
• Small businesses tracking submissions from landing pages or contact forms
• Event organizers managing RSVP or booking forms
• Anyone needing automated storage of structured form data in Google Sheets

Prerequisites

• n8n instance (self-hosted or cloud)
• Google account with edit access to the target sheet
• Google Sheets OAuth2 API credentials configured in n8n
• Web form capable of sending POST requests with fields: business_name, location, whatsapp, email, name

Google Sheet Format

Setup Instructions

1. Configure Webhook node with path (accepts POST requests)
2. Clean incoming data with a JavaScript (Code) node and add submitted_date
3. Optionally use Split In Batches node for bulk submissions
4. Append each submission to Google Sheet via Google Sheets node
5. Optionally add a Wait node for throttling (e.g., 5-second delay)

How to Use

1. Import the workflow into your n8n instance
2. Update the Webhook URL in your form’s POST action
3. Connect your Google Sheets account in n8n
4. Ensure the target sheet matches required column structure
5. Submit data from your form — entries appear automatically in the sheet

Notes

• Use Sticky Notes in n8n to understand each node’s purpose
• Delay duration can be adjusted or disabled for single submissions
• Consider securing webhook with headers or tokens

Ideal Use Cases

• Contact forms
• Lead capture pages
• Event signups or bookings
• Newsletter or email list opt-ins
• Surveys or feedback forms

Support

• WhatsApp Support
• Discord Community
• Facebook Group
• Website
• Developer Portfolio