How can I send form data and submissions from Webflow to a new row in a Google Sheets spreadsheet document securely and for free?
- Create a Google Sheet, use Apps Script to write a doPost handler, and deploy it as a Web App with access set to “anyone.”
- In Webflow, disable default form handling, set form action to the Web App URL, and use POST method.
- Process incoming form data in the script to append it to the sheet; optionally, use Make.com for a no-code alternative.
To send Webflow form submissions to Google Sheets for free and securely, you’ll need to use a third-party automation service like Make (formerly Integromat) or a custom solution like a Google Apps Script Web App.
1. Use Google Apps Script (Free & Secure)
This method is free and data stays within your Google account.
- Go to Google Sheets and create a new sheet with labeled headers (e.g., Name, Email, Message).
- From the sheet, click Extensions > Apps Script.
- Replace the default code with a script to handle POST requests and append data to the sheet (you’ll need to write a handler for
doPost(e)). - Deploy the script as a Web App:
- Click Deploy > Manage deployments
- Set access to Anyone
- Copy the Web App URL
⚠️ This Web App URL will act as your form action, so keep it private.
2. Point Webflow Form to Web App URL
- In Webflow, go to your form settings.
- Disable Webflow form handling by removing the built-in
form-name. - Set Form Action to your Google Apps Script Web App URL.
- Set method to POST
Your form will now bypass Webflow’s default submission handling.
3. Structure the Payload in Apps Script
In your Google Apps Script:
- Extract data from
e.parameterto match the field names passed from the Webflow form inputs. - Append each submission as a new row in the sheet.
- Add validation or CAPTCHA if needed for spam protection (e.g., Google reCAPTCHA v2/v3)
4. Optional: Use Make (Integromat) for Simpler Setup
If you prefer a no-code option:
- Sign up at make.com and create a free scenario
- Trigger: Webhook
- Action: Google Sheets > Add Row
- Paste the webhook URL into your Webflow form’s action field (as above)
- Map form fields to sheet columns
Free Make plan allows a limited number of operations per month, suitable for small sites.
Summary
Use a Google Apps Script Web App to securely and freely send Webflow form submissions to Google Sheets. Alternatively, use the free plan of Make.com for a low-code solution. Either method lets you bypass Webflow's built-in form system and store submission data directly in a spreadsheet.