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

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're a tool that lets you send information from one app to another, reducing manual tasks. In this video, 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. 

Before you begin

Create a Google Sheet and make sure your columns have names. This will make it easier to set up your Zap. Also, make sure your Typeform has at least one submission. You can create a fake submission with a superhero name just for testing purposes. 

Get started quickly with a Zap template

We have a template to help you get started quickly. Click the button below and you'll be ready to create your Zap. Some fields will be pre-selected to make things easier. Note: You'll need to create a Zapier account if you don't already have one. It's free to start. 

Here's how it works: 

1. Click on the button to get started. 

2. Connect your Typeform account and select the form you'd like to use.

3. Connect your Google Sheets account and select the spreadsheet you'd like to use. 

4. Select the spreadsheet columns you want to add information to. 

5. Map where you want your Typeform information to go in your spreadsheet. 

6. Test your workflow and turn it on. 

This article was originally published in July 2019 and was updated in August 2021.

Related reading: 

• 6 ways to simplify business processes with Typeform

• Make your spreadsheets work for you with automation

• Turn a contact form into a business growth tool