How to Connect Google Sheets Forms to Form2Lead
Step-by-step developer instructions for Google Sheets applications.
How do you send Google Sheets form submissions to Form2Lead?
Point your form’s Form2Lead webhook at an Apps Script Web App, Zapier, or Make step that appends one row per submission to Google Sheets. Form2Lead has no native one-click Sheets sync — the webhook bridge keeps every lead in a live sheet, and CSV export covers snapshots.
Why use Form2Lead with Google Sheets?
Google Sheets is the most-requested Form2Lead destination, and the honest setup is a webhook bridge rather than a sync toggle: enable your form’s HMAC-signed outbound webhook, receive it with a free Apps Script Web App or a Zapier / Make / n8n step, and each valid submission becomes a sheet row within seconds. Spam never reaches the sheet — the invisible honeypot and IP rate limiting reject bots before the webhook fires. For one-off reports, skip the plumbing entirely and use one-click CSV export with File → Import.
Prerequisites
- ✔A Google account with access to Google Sheets
- ✔A Form2Lead form with webhooks enabled
- ✔Your target spreadsheet ID (or a Zapier / Make / n8n account for the no-code path)
Step-by-Step Integration Guide
01. Choose Your Path: Live Rows or CSV Snapshot
For a continuously updated sheet, use the webhook bridge below. For a one-off report or monthly rollup, open the form’s Submissions view, filter by date range, hit Export, and use File → Import in Google Sheets — every payload key becomes a column in a UTF-8 CSV.
02. Add the Webhook Destination in Form2Lead
In your form’s settings, paste the receiver URL — your Apps Script Web App URL (deployed with access set to “anyone”) or the catch-hook URL from Zapier, Make, or n8n. Form2Lead POSTs HMAC-signed JSON for every valid submission with automatic retries and backoff.
03. Deploy the Apps Script Receiver (Code Path)
In Google Sheets, open Extensions → Apps Script, paste the doPost handler below, and deploy as a Web App. It parses each webhook payload and appends one row per submission. Verify the HMAC signature header before trusting the payload in production.
function doPost(e) {
const data = JSON.parse(e.postData.contents);
const sheet = SpreadsheetApp.openById('YOUR_SHEET_ID').getSheets()[0];
sheet.appendRow([new Date(), data.name || '', data.email || '', data.message || '']);
return ContentService.createTextOutput(JSON.stringify({ ok: true }))
.setMimeType(ContentService.MimeType.JSON);
}04. Test and Verify the First Row
Submit a test lead on your live form and confirm the row appears within seconds, then lock the form’s Allowed Domains to your site origin so only your pages can submit.
Google Sheets Integration FAQ
Is there a native one-click Google Sheets integration?
No — Form2Lead has no native Sheets sync and there is no one-click connect button. The supported paths are the webhook bridge (Apps Script Web App, Zapier, Make, or n8n appending one row per submission) and one-click CSV export for snapshots.
Do I need a paid Zapier plan to get leads into Sheets?
No. The Apps Script path is free and needs no extra subscription — the Web App receiver above runs inside your own Google account. Use Zapier or Make only if you prefer a no-code webhook trigger plus a Sheets “append row” action.
Will spam submissions reach my sheet?
No. Spam is filtered before webhooks fire: the invisible `_gotcha` honeypot and IP rate limiting reject automated submissions, and flagged attempts sit in the dashboard’s Spam tab — your sheet only receives valid leads.
What if I only need past submissions in a sheet once?
Use CSV export instead of a webhook. Filter the Submissions view by date range, hit Export, and import the file into Sheets. Note plan retention windows (14 days on Basic, 30 on Starter, 120 on Growth) — export on a schedule if you need running history.