Automated Web Form Submission Capture to Google Sheets - n8n Workflow

Marketing professionals needing quick lead capture solutions.
Technical users looking for reliable n8n templates for data logging.
Developers who need an easy backend for simple web forms.
Businesses requiring automatic synchronization of registration or contact data.

Manually transferring data from web forms to spreadsheets is inefficient and prone to errors. This specialized n8n workflow provides a scalable and immediate automation solution. It transforms your active n8n instance into a powerful data intake pipeline. By utilizing a public Webhook as the starting n8n trigger, it securely receives data from any frontend application. The workflow ensures data quality by running a Code n8n node to clean, validate, and timestamp the submission before storing it. This n8n workflow is ideal for capturing lead generation data, event registrations, or contact form submissions, guaranteeing that every new entry is recorded accurately in your designated Google Sheet document.

This n8n workflow operates through five key stages:

1. Trigger Reception: The automation starts when the Webhook n8n node receives an HTTP POST request from a web form. This node acts as the essential n8n trigger, instantly capturing the submitted JSON payload.


2. Data Cleaning and Stamping: The flow moves to the Clean response data (Code) n8n node. This JavaScript node performs two critical functions: it extracts only the necessary fields (Name, Email, Business Name, etc.) from the potentially messy webhook body, and it automatically generates and appends a submitted_date stamp for accurate time-logging.


3. Batch Preparation: The data is then passed to the Loop Over Items (Split In Batches) n8n node. While this setup works perfectly for single submissions, its primary role is to scale the n8n workflow by handling multiple records submitted simultaneously, ensuring stable processing.


4. Data Storage: The Store Data in Sheet (Google Sheets) n8n node takes the cleaned, structured data item and appends it as a new row to a pre-defined Google Sheet. It uses explicit column mapping to ensure fields like Name, Email , and Date land in the correct columns.


5. Rate Limiting (Optional): Finally, the Wait n8n node introduces a 5-second delay. This mechanism is crucial when processing large batches to prevent hitting API rate limits associated with the Google Sheets service, maintaining the reliability of the n8n workflow.

To deploy this comprehensive n8n workflow solution, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON code and paste it into your active n8n instance using the 'Import Workflow' function.


2. Set Up Google Sheets Credentials: Navigate to the Credentials section and add or select your existing Google Sheets OAuth2 API credentials. This credential set must have write access to the target spreadsheet.


3. Configure Google Sheets Node: Open the 'Store Data in Sheet' n8n node. Select the Document ID and Sheet Name where you intend to store the form data. Ensure the column headers in your sheet exactly match the mapped fields (e.g., Email with a trailing space).


4. Activate the Webhook Trigger: Click on the 'Webhook' n8n trigger node and copy the generated Test or Production URL. This URL is the endpoint to which your web form must send its data via an HTTP POST request.


5. Activate the n8n Workflow: Set the overall workflow status to 'Active' to start listening for incoming form submissions.

This n8n workflow utilizes several core n8n node types to achieve its goal:

Webhook (n8n Trigger)
Function: Acts as the starting n8n trigger for the workflow, listening for external data submissions.
Key Configuration: Configured to accept HTTP POST requests. The unique path is 93a81ced-e52c-4d31-96d2-c91a20bd7453.

Clean response data (Code n8n node)
Function: Cleans up the raw JSON payload from the webhook, standardizes the fields, and injects the current date (YYYY-MM-DD format) into a field named submitteddate.
Key Configuration: Uses JavaScript to extract and map input fields: businessname, location, whatsapp, email, and name.

Loop Over Items (Split In Batches n8n node)
Function: Controls the flow by splitting incoming data into individual or small batches. This future-proofs the n8n workflow for high-volume submissions.
Key Configuration: Basic setup, used primarily for flow control before the Google Sheets write operation.

Store Data in Sheet (Google Sheets n8n node)
Function: Authenticates with Google Sheets and appends the cleaned data as a new row in the specified spreadsheet.
Key Configuration: Operation: append. Data is mapped to specific sheet columns: Date, Name, Email , Location, Business Name, and WhatsApp Number. Requires OAuth2 credentials.

Wait
Function: Implements a pause (delay) in the execution flow, typically 5 seconds, to manage API throttling when processing large datasets or multiple items from the batch loop.