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
- Use Google Apps Script to handle form submissions by pasting code into the script editor in Google Sheets.
- Deploy the script as a Web App and set access permissions.
- Obtain the Web App URL for Webflow to send form data.
- Update Webflow form settings with the Web App URL and test the submission process.
- Implement security checks in the script and monitor access settings regularly.
You want to send form data from Webflow to a Google Sheets spreadsheet to manage submissions efficiently. Here’s how to accomplish that securely and for free.
1. Use Google Apps Script
- Go to Google Sheets and open or create the spreadsheet you want to use.
- Click on Extensions, then Apps Script.
- In the new script editor window, delete any existing code and paste the Apps Script code that will receive form submissions.
- Use a function such as
doPostto capture the submission data and write it to the spreadsheet.
2. Deploy the Script as a Web App
- Click on Deploy in the upper right corner.
- Select New deployment and choose Web app for the type.
- Set “Execute as” to “Me” and “Who has access” to “Anyone” (or "Anyone with the link" if you prefer some restrictions).
- Click on Deploy and follow the on-screen instructions to authorize.
3. Get the Web App URL
- Once deployed, you will receive a URL for the web app. This is the endpoint where Webflow will send form data.
4. Set Up Webflow Form Action URL
- Go to your Webflow project and open the page with the form.
- Select the form, then open the Form Settings.
- Set the Action field to the web app URL you obtained in step 3.
- Ensure the Method is set to POST.
5. Test the Setup
- Publish your changes in Webflow.
- Submit a test form through the published site.
- Check your Google Sheets to ensure the submission data appears correctly.
6. Secure the Script
- Consider adding simple security checks in your Apps Script like checking a secret token to ensure that the data only comes from a trusted source.
- Regularly monitor the web app access settings and update as needed.
Summary
To send form data from Webflow to Google Sheets securely and for free, use Google Apps Script to create a Web App that collects data via POST requests. Deploy the script, update your form's action URL in Webflow, and test thoroughly. Keep security in mind by restricting access and monitoring submissions regularly.
