• Home

  • Automation with Zapier

  • Zapier tutorials

Zapier tutorials

3 min read

Connect Typeform to Google Sheets and automatically add responses to a spreadsheet

By Khamosh Pathak · January 15, 2024
add-typeform-responses-to-goog primary img

If you're collecting any information through Typeform, you can count on handy charts and graphs to give you a holistic view of responses. But there are times where it's easier to see responses in a spreadsheet. 

Typeform has a native Google Sheets integration, but if you want more control over what responses get sent to your spreadsheet, Zapier can help. 

We'll show you how to create a Zap—what we call our automated workflows—that will automatically populate a Google Sheet with Typeform responses as they come in.

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

Before you begin

Once you have your Typeform form ready, create a Google Sheet with columns that match your form response fields.

In our example, we're collecting responses for an event registration that include name, email, and any questions event attendees have. Here's our Google Sheet:

A Google Sheet with columns for name, email, and questions.

You can create different headings based on your form fields. Just make sure to have some form of column headings as those will be used to set up your Zap.

Make sure you also have at least one response to your Typeform. You'll need that to set up your Zap.

How to collect new Typeform responses in Google Sheets

Now you're ready to set up your workflow. 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 the Zap template below to go 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.

Collect new Typeform responses as rows on Google Sheets

Collect new Typeform responses as rows on Google Sheets
  • Typeform logo
  • Google Sheets logo
Typeform + Google Sheets

Set up your Typeform 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 Typeform as the trigger app and New Entry as the trigger event, then click Continue.

A trigger step in the Zap editor with Typeform selected for the trigger app and New Entry selected for the trigger event.

Next, sign in to your Typeform account, if you haven't already, and click Continue

Setting up your trigger only takes one step. In the Typeform Form field, select the form you want to use in this workflow, then click Continue

A field to select a Typeform in the Zap editor.

Now, it's time to test your trigger step. If you don't have at least one response to your form, add one now. Once you have at least one submission, click Test trigger.

Zapier will now show you the three most recently form submissions. Choose the result you want to use to set up the rest of your Zap, then click Continue with selected record

Sample Typeform form responses in the Zap editor.

And that's it for your trigger step!

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, sign in with your Google Sheets account, if you haven't already, and click Continue

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

Google Sheet fields in the Zap editor.

When you do this, Zapier will automatically pull up the column headings from your Google Sheet. 

In our example, we created three column headings: Name, Email, and Questions. Now all that's left to do is to map the fields from our Typeform to our Google Sheet columns. To do that, click in the field where you want to add Typeform data, then select the appropriate data from the Insert Data dropdown.

Here's what our fields look like:

Google Sheet fields in the Zap editor with Typeform form response data added to each field.

Do this for all the column headings, and when you're happy with the setup, click Continue.

Now, test your Zap. Click Test step and Zapier will send the test data to your Google Sheets spreadsheet. Open your spreadsheet to make sure that everything is as it should be. 

This is what our sample test looked like:

A Google Sheet with a name, email, and question added to the spreadsheet.

If everything looks right, you're ready to use your Zap. Now, every time you get a new response in Typeform, it will be added to your Google Spreadsheet automatically! 

Collect new Typeform responses as rows on Google Sheets

Collect new Typeform responses as rows on Google Sheets
  • Typeform logo
  • Google Sheets logo
Typeform + Google Sheets

This article was originally published in July 2019, with contributions by Krystina Martinez. It was most recently updated in January 2024.

Related reading:

  • Popular ways to automate Typeform

  • Make your spreadsheets work for you with automation

  • Turn a contact form into a business growth tool

  • How to add subscribers to ConvertKit forms from Typeform

Get productivity tips delivered straight to your inbox

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

tags
mentioned apps

Related articles

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

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