• Home

  • Automation with Zapier

  • Zapier tutorials

Zapier tutorials

3 min read

How to easily send Webflow form responses to Google Sheets

By Khamosh Pathak · December 14, 2023
A hero image of the Webflow app logo connected to the Google Sheets app logo on a light blue background.

Capturing customer or lead data in a form on your Webflow page is a great first step in your marketing journey. But what you do with that data is most important. 

Webflow makes it easy to capture customer info with an easy-to-build, no-code website. But if your data is siloed, it's basically useless. Use a Zap—Zapier's word for our automated workflows—to easily collect your Webflow form responses in a Google Sheet. That way, you can seamlessly share important customer info and slice-and-dice your data for better analysis. Here's how.

New to Zapier? It's workflow automation software that lets you focus on what matters. Combine user interfaces, data tables, and logic with 6,000+ apps to build and automate anything you can imagine. Sign up for free.

Before you begin

You'll need to have a Webflow form already set up. Make sure it has at least one form response, which will be used to set up your Zap. If you don't have any responses yet, just add a fake one that you can delete later.

Then, create a new spreadsheet in Google Sheets. For the Zap to work correctly, you'll need to make sure to add headers in your first row. 

What headers you use will depend on the details you want to capture in your form. In this example, we're creating a simple newsletter signup form, so we'll add two column headings: Name and Email.

A Google Sheet titled "Webflow Form Data" with two columns for Name and Email.

Send Webflow form data to Google Sheets

Zapier lets you create automated workflows called Zaps, which send your information from one app to another. You can create your own Zap from scratch without any coding knowledge, but we also offer quick templates to get you started. 

If you'd like to start with a template, click on it below, and you'll be taken to the Zap editor. You'll need to create a Zapier account if you don't already have one. Then, follow the directions below to set up your Zap.

Send Webflow form data to Google Sheets

Send Webflow form data to Google Sheets
  • Webflow logo
  • Google Sheets logo
Webflow + Google Sheets

Set up your Webflow trigger

Let's start with the trigger—the event that starts your Zap. If you're using the Zap template, this will be selected for you. Otherwise, search for and select Webflow as the trigger app and Form Submission as the trigger event, then click Continue.

A trigger step in the Zap editor with Webflow selected for the trigger app and Form Submission selected for the trigger event.

Next, connect your Webflow account, if you haven't already, then click Continue.

Next, select the Site Name and Form Name you want to use in your Zap. Then click Continue

Webflow form fields in a trigger step in the Zap editor.

Now, it's time to test your trigger step. This will gather information from Webflow that will be used to set up the rest of your Zap. Before clicking Test trigger, make sure there's at least one submission in the form (you can add fake testing data if you don't have any submissions). 

Select the record you want to use in your test, then click Continue with selected record to move on to setting up your action step.

A set of test data that shows responses to a Webflow form.

Set up your Google Sheets action

Now it's time to set up the action—the event your Zap will perform once it's triggered. If you're using the Zap template, these will already be selected for you. Otherwise, search for and select Google Sheets as your action app and Create Spreadsheet Row as your action event. Click Continue.

An action step in the Zap editor with Google Sheets selected for the action app and Create Spreadsheet Row selected for the action event.

Next, connect your Google Sheets account, if you haven't already. Then click Continue.

Now, it's time to customize your action step. First, choose the correct drive in the Drive field where your Google Sheet is stored. Then select the Spreadsheet you created for the landing page. And finally, choose the appropriate Worksheet (by default, it's "Sheet1").

Google Sheets fields in an action step in the Zap editor.

Once you do that, Zapier will automatically pull in the column headings you added to your sheet. 

Now, let's map the data from our Webflow trigger step to your action step. Depending on what info you're collecting in your form and what columns you added to your Google Sheet, you'll map different info. In our example, we're going to add customer names and emails from the form by clicking in the Name field and selecting Data Name from the Insert Data dropdown and Data Email in the Email field.

Fields for Name and Email in an action step in the Zap editor.

Once that's done, click Continue.

Click Test action, and Zapier will send the test data to Google Sheets. Check the results to make sure the right data is mapped to the appropriate columns.

Here's what the successful test results look like for us.

A Google Sheet with details added in the Name and Email columns.

If everything looks right, you're now ready to use your Zap. Now, every time someone fills out your Webflow form, the information will automatically show up on your Google Sheet.

Related reading:

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

mentioned apps

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'