Log in
Sign up
  • Home

  • Automation with Zapier

  • Zapier tutorials

Zapier tutorials

1 min read

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

By Krystina Martinez · August 11, 2021
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'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. 

You'll need a Zapier account to use the workflows in this piece. If you don't have an account yet, it's free to get started.

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. 

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

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. 

New to Zapier? It's a tool that helps anyone connect apps and automate workflows—without any complicated code. Sign up for free.

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

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'