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!
Each time a respondent completes or submits a Partial response to your form, their response will create a new row in your sheet.
To get started, all you need is a Free Typeform account and a Google account, which is free to create.
But first, some basic Google Sheets terminology:
- A spreadsheet is an entire file in Google Sheets. You can connect one Typeform account with as many typeforms as you want to this file.
- A sheet is an individual tab within a spreadsheet file in Google Sheets. You can only collect data from one typeform on each of these sheet tabs.
Send Partial responses to the integration
If you've added a Partial Submit Point(s) to your form, a new row will be created each time a respondent passes a Partial Submit Point and a new row will be created when they complete your form. For example, if a respondent passes a Partial Submit Point, their responses will create a new row. If the same respondent continues with the form and completes it, this will create a second row in your sheet.
You can enable Partial responses for Google Sheets in your form's settings:
1. Click the settings icon in the tool bar of the Content panel.
2. Under Preferences, toggle on Send partial responses to integrations and click Save.
Then follow the instructions below to set up the Google Sheets integration.
How to set up the integration
1. Open your typeform from your Workspace, then click the Connect panel. Find the Google Sheets integration and click Connect.
2. If you’ve already connected a Google Sheets account to your Typeform account, click the dropdown under Choose an account to select which account you want to use for this automation.
If you haven’t connected a Google Sheets account yet, click Add a new account and follow the prompts to log into your Google account.
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.
If you’ve already connected a Google account, you may be prompted to re-authenticate if it has been more than 1 hour since you last signed in.
Warning! Currently, if you are using Google's Advanced Protection security feature, it is not possible to use this integration.
3. Select if you’d like to create a new sheet or use an existing sheet to send your contact data or form responses to.
4. If you want to create a new sheet, enter the name you want to use for your new spreadsheet in the field.
5. If you want to use an existing spreadsheet, paste your Google Sheets URL in the field.
To retrieve your Google Sheets URL, open your Google Sheet and click the Share button. Then click Copy link and paste it in the Google Sheets URL field back in Typeform.
Google Sheets doesn’t allow multiple tabs with the same name. If your existing spreadsheet contains duplicate tab names, this may cause an error. Make sure all tab names in your spreadsheet are unique.
6. Click Finish when you’re done.
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.
7. If your typeform already has some responses, you can choose to also send them to your Google Sheet. This currently works for forms with up to 1,000 results. Partial responses that have already been collected won't be sent to your Google Sheet.
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
8. In the Connect panel, the integration will show a toggle that has been turned on.
Now, 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.
Note! Submission times will be shown in UTC.
Yes/no and Legal questions will be recorded as TRUE for Yes and FALSE 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.
9. 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.
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 spreadsheet file
You can connect as many typeforms as you want to the same Google spreadsheet. Each connected typeform sends its responses to a separate sheet tab, and each tab is named after the typeform so it’s easy to tell which responses belong to which form.
Follow the steps above. When you’re asked, “Where do you want to send your responses?”, select Use existing.
Then paste the URL of the Google spreadsheet you want to connect and finish setting up the integration.
Once it’s connected, a new sheet tab will appear in your spreadsheet for each typeform you connect.
Note! When integrating to an already existing spreadsheet, the name of your typeform cannot be the same as the name of a sheet tab in that spreadsheet. Make sure to choose a different name for your typeform, and each of your sheet tabs in Google Sheets.
Once you've set up the integration, you can also check out this guide for troubleshooting tips and other FAQs.