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.
The Google Sheets integration is available for free to all Tally users. To use the integration and create a spreadsheet you also need a free Google account.
How it works
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.
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.
If your Tally form already has results, the existing responses will be sent to the spreadsheet, and new ones will be updated automatically.
Changing timezones in Google Sheets
Submission times are displayed in UTC when exported to integrations. Add another column to your sheet to display your local time and use this formula as a header cell value:
=ARRAYFORMULA(IF(ROW(C:C)=1, "Local submitted at", IF(ISBLANK(C:C), "", C:C+6/24)))
Where:
Local submitted at is the name of your new columnC is the Submitted at column+6/24 adds 6 hours to the UTC time (eg: -8 hours = -8/24, etc)