Sign up
  • Home
  • Automation with Zapier

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

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 Use this Zap button below and you'll be guided through setup. 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 Use this Zap 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/wk, and never share your information.

Krystina Martinez picture

Krystina Martinez

Krystina writes about all things automation for the Zapier blog. Previously she was a public radio journalist, so she has a lot of opinions about microphones. When she's not writing or tinkering with Zapier, Krystina enjoys sewing her own clothes and taking long naps in between her many hobbies.

tags
mentioned apps

Related articles

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

Sign upSee how it works