1. Help
  2. Advanced
  3. Integrations
  4. Google Sheets for Typeform

Google Sheets for Typeform

Want another way to get your typeform’s results? Get them sent automatically to a Google Sheet with this native integration. It’s super simple to set up!

To get started, all you need is a Free Typeform account and a Google account, which is free to create.

1. To connect your typeform to a Google Sheet, open it from your Workspace, then click on Connect. Now you can see our integrations, so click on Connect in the Send responses to Google Sheets box.

sheets1.png

2. A message will pop up asking you to connect your Google account, or choose one you previously connected to Typeform. Choose an account, or follow the prompts to sign in to Google.

sheets2.png

 

HC_Note_new.png
Note! You can associate multiple Google accounts with your Typeform account. Any account you have previously connected will be listed here. Each unique typeform can be integrated with one Google account: in other words you can’t integrate the same typeform with multiple Google accounts.

3. Click the Log in to Google button, which will open a new browser tab from Google. This is an example – I have three different Google accounts to choose from – what you see depends on your Google history.

HC_Warning_ilu_cropped.png
Warning! Currently, if you are using Google's Advanced Protection security feature, it is not possible to use this integration.

4. Choose the account you want to connect to your typeform, and you’ll see the following screen:

sheets3.png

Click Allow to connect your account, and return to your typeform!

5. Now we’re back, you can decide whether to connect your typeform to a brand new Google Sheet, or one you already have:

sheets4.png

6. If you want to connect an existing sheet, click Use existing. Paste in the URL of your sheet and hit Connect to spreadsheet.

sheets5.png

HC_Note_new.png
Note! Make sure you have already shared your Google Sheet when pasting in your URL. If you have not, the integration may not work. Click the Share button when in Google Docs, and then the Get shareable link button. This is the URL you should add to your integration.

7. Alternatively, click Create new. Now just give your new sheet a name, and click Create Sheet to get going.

sheets6.png

HC_BobRoss_ilu_cropped.png
Tips! Your sheet will be created in the default Drive of your Google account. You can move it to whichever folder you like in that account without affecting the integration.

8. You’ll now see the message below. Just click Activate integration to complete your integration!

sheets7.png

9. If your typeform already has some results, you can choose to also send them to your Google Sheet. This currently works for typeforms with up to 3000 results:  

sheets8.png

HC_Warning_ilu_cropped.png
Warning! Google's Sheets API limits you to 500 requests per 100 seconds per project, and 100 requests per 100 seconds per user. Integrations that exceed this will be deactivated. This limit also affects the maximum number of questions the typeform you're trying to integrate can have. This is unlikely to affect most users, but if you are expecting thousands of typeform responses at the same time, you will need to change your Google API settings: https://developers.google.com/sheets/api/limits

10. The Connect panel will now look a little different:

sheets9.png

Click View your spreadsheet to open it in a new tab. Every time someone completes your typeform, the results will automatically be sent here.

If you want to stop results being sent there, you can toggle the blue switch. You can turn it back on whenever you want.

Your Google Sheet will have a column for each question of your typeform, plus one for the time of submission, Submitted At, and another called Token. This is a unique identifier for every submission to your typeform. 

HC_Note_new.png
Note! Submission times will be shown in UTC.

Yes/no questions will be recorded as 1 for Yes and 0 for No in your Google Sheet. Statement questions and Question groups will not have columns, as they do not collect results.

You can add questions to your typeform after setting up this integration. A new column in your Google Sheet will be added when someone answers that question for the first time. You can also delete questions without losing any results - the corresponding column in Google Sheets will not be deleted when you delete a question.

11. If you want to remove this integration completely, click the three dots, where you can delete the integration. This will allow you to integrate with a different Google account or spreadsheet:

sheets10.png

HC_Warning_ilu_cropped.png
Warning! Google’s API has a limit of 2 million cells per Sheet. If you exceed this, the integration will be deactivated. This limit includes cells from other tabs, and any existing cells when you start the integration.

Connect multiple typeforms to a single Google Sheet

You can connect as many typeforms as you want to a Google Sheet. Each new integrated typeform will send its results to a new tab in the Google Sheet. The new tab will have the same name as your typeform, so you can easily see which results are which.

Follow the instructions above, and when we ask Where do you want to send your responses? , choose Use existing:

sheets11.png

Then paste in the URL of Google Sheet you want to connect. Now finish the integration set up as above.

You’ll now see a new tab appear in your Google Sheet, one for each form you have connected:

HC_Note_new.png
Note! When integrating to an already existing spreadsheet, the name of your typeform cannot be the same as the name of a tab in that sheet. Make sure to choose a different name for your typeform, and each of your tabs in Google Sheets.

 

Tap into our community knowledge

Find Answers
Contact Support