With Tally's Google Sheets integration, you can send your Tally form responses straight to Google Sheets. This is a great way to manage and share your form results with your team and create visual reports of your data.
Every time someone submits your form, a new row is created and the results automatically appear in a spreadsheet. You can move or delete columns as you like, and your form results will appear accordingly. When you export responses from an existing form, all existing responses will be added to your spreadsheet at once, and new rows will appear whenever someone submits your form.
The direct Google Sheets integration is available for free. To use the integration and create a spreadsheet you also need a free Google account.
⚠️ Our direct Google integration has recently been improved. If you'd like to use the newest version of the integration, you need to remove the existing connection in the Integrations tab. Then connect your form again, and a new spreadsheet will be created with all existing form responses.
How to set it up
- Go to the Integrations tab of your published form and connect to Google Sheets
A window will pop up asking you to connect your Google account. Choose an account, or follow the wizard to sign in to Google.
Once you're connected a new spreadsheet will be created in the default Drive of your Google account and a link to this spreadsheet will be visible in your Tally dashboard.
- You can move your sheet to another folder and move or delete columns in the sheet without affecting the integration.
5. If your Tally form already has results, the existing responses will be sent to the spreadsheet, and new ones will be updated automatically.