Updated: Connect Typeform to Google Sheets and Automatically Upload New Responses
Use the Typeform to Google Sheets Zap from the video: http://zpr.io/tpf28 *** - Give Zapier a try for free: http://zpr
Use the Typeform to Google Sheets Zap from the video: http://zpr.io/tpf28
- Give Zapier a try for free: http://zpr.io/tpf29
If you use Typeform to collect feedback or responses or anything, really, you know that the easiest way to read through those responses is in a spreadsheet. But how do I get the responses to a spreadsheet without downloading and uploading a CSV?
With Zapier. If you haven’t heard of Zapier yet, it’s a tool that automates your tedious, manual work, so you can handle the tasks that really require brainpower.
And with Zapier, I can connect Typeform and Google Sheets so that all my new responses are automatically added to a row in Google Sheets. So let’s build this Zap!
I’ll connect my Typeform account now. At Zapier, we take data security seriously and use bank-level encryption to protect your account details.
Typeform’s connected and now I have to select a form Zapier will monitor for new responses. This down caret button means we need to pick from a list. And here’s my test form.
Now let’s pick a sample response to use in Google Sheets.
We’ll be creating a new row in Google Sheets for each response so let’s get Google Sheets connected. This gives Zapier permission to create a new row in my Google Sheets.
We have another down caret to select the specific spreadsheet and table. It’s a long list, so let’s search for the spreadsheet by title.
Now I need to match up the responses from Typeform to the right columns in Google Sheets. By clicking this button, we can grab information from the first step, from Typeform.
OK, we have all the responses populating to the right columns so let’s continue.
Now, when I click test, we’re actually going to do the action, so keep that in mind when you test your Zaps, too; Zapier is actually making the action happen.
Looks like a success, so lets check Google Sheets…and there’s my response! We just connected Typeform to Google Sheets in a snap.
Now, every time I get a response to my Typeform, Zapier’s going to take the response and create a new row in Google Sheets.
I used a Zap template to build this Zap. They have the apps and actions pre-selected to make set-up even faster. If you want to try this one, just the click the link in the description. What do you want to automate today?