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:
Click on the Use this Zap button to get started.
Connect your Typeform account and select the form you'd like to use.
Connect your Google Sheets account and select the spreadsheet you'd like to use.
Select the spreadsheet columns you want to add information to.
Map where you want your Typeform information to go in your spreadsheet.
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.