📝 Automated Web Form Data Collection to Google Sheets

Collect data from web forms and store it automatically in Google Sheets using n8n. Includes data cleaning, date stamping, optional batching, and throttling.

---

Overview

This workflow allows you to:

• Accept form submissions via HTTP POST
• Clean and structure incoming JSON data
• Automatically add the submission date
• Append structured data to a Google Sheet
• Handle bulk submissions with optional batching and delay

---

Features

• Webhook trigger for external form submissions
• JavaScript-based data cleaning and formatting
• Looping and delay nodes for batch processing
• Google Sheets integration via OAuth2
• Auto-generated submitted_date for each entry

---

Who This Is For

• Developers or marketers collecting leads
• Small businesses tracking landing page submissions
• Event organizers managing RSVPs or bookings
• Anyone needing automated data storage into Google Sheets

---

Prerequisites

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

---

Google Sheet Format

Ensure your sheet contains exact column names (case-sensitive):

Business Name	Location	WhatsApp Number	Email	Name	Date
SpaGreen	Bangladesh	8801322827753	spagreen@gmail.com	Abdul Mannan	2025-09-14
Dev Code Journey	Bangladesh	8801322827753	admin@gmail.com	Shakil Ahammed	2025-09-14

⚠️ The Email column must match exactly, including any trailing space.

---

Setup Instructions

1️⃣ Configure Webhook

• Webhook path: /93a81ced-e52c-4d31-96d2-c91a20bd7453
• Accept POST requests from your form

2️⃣ Clean Incoming Data

• Use a Code node to extract fields
• Add submitted_date in YYYY-MM-DD format

3️⃣ Loop Over Items (Optional)

• Split In Batches for bulk submissions
• Single submissions work without adjustment

4️⃣ Append to Google Sheet

• Map fields to columns:
  • Business Name
  • Location
  • WhatsApp Number
  • Email
  • Name
  • Date (auto-filled)

5️⃣ Add Delay (Optional)

• Use Wait node (e.g., 5 seconds) to throttle requests for large batches

---

How to Use

1. Import the workflow into n8n
2. Update the Webhook URL in your frontend form
3. Connect your Google Sheets account
4. Verify the sheet column structure matches
5. Submit data via your form → entries appear in the sheet automatically

---

Notes & Tips

• Use Sticky Notes in workflow to track node purpose
• Modify delay duration or disable looping for single entries
• Secure webhook with headers or tokens for added safety

---

Ideal Use Cases

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

---

Support

• WhatsApp Support
• Discord: SpaGreen Community
• Facebook Group: SpaGreen Support
• Website
• Developer Portfolio: Codecanyon SpaGreen