How can I send form data and submissions from Webflow to a new row in a Google Sheets spreadsheet document securely and for free?
TL;DR
- Create a Google Sheet with headers matching form fields and copy its URL.
- In Make, create a free account, set up a new webhook, and copy its URL.
- In Webflow, paste the Make webhook URL into the form action field and submit a test form.
- In Make, connect the webhook to Google Sheets, authenticate, and map form fields to sheet columns.
- Activate the scenario and test by submitting a new Webflow form to confirm data is added to Google Sheets.
You can send Webflow form submissions to Google Sheets securely and for free using Make (formerly Integromat) or Pipedream. Here’s how:
1. Create a Google Sheet
- Open Google Sheets and create a new spreadsheet.
- Add column headers that match your form fields (e.g., Name, Email, Message).
- Copy the Sheet URL (you will need this later).
2. Set Up a Webhook in Make (Free Tier)
- Go to Make and create a free account.
- Click Create a new Scenario and select Webhooks.
- Click Add a new webhook and copy the webhook URL generated.
3. Connect Webflow to Make
- In Webflow, go to Project Settings > Forms.
- In the Form Action field, paste the Make webhook URL.
- Submit a test form to send sample data to Make.
4. Connect Make to Google Sheets
- Add a Google Sheets module in Make.
- Choose Add a Row to a Spreadsheet.
- Authenticate your Google Sheets account.
- Select the spreadsheet and connect the Webflow webhook fields to the appropriate columns.
5. Activate the Scenario
- Turn on the scenario in Make.
- Submit a new form in Webflow to confirm the data is added to Google Sheets.
Summary
You can securely send Webflow form submissions to Google Sheets for free using Make (formerly Integromat). Set up a webhook, connect Webflow to Make, and link it with Google Sheets to automatically add new rows when forms are submitted.