Google Sheets

 
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.
notion image
 
 


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
notion image
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.
notion image
You can move your sheet to another folder and move or delete columns in the sheet without affecting the integration.
notion image
If your Tally form already has results, the existing responses will be sent to the spreadsheet, and new ones will be updated automatically.

View integration logs

If your submissions are not being synced correctly, you can view the sync submission logs and their status by clicking 🕓 next to your integration connection.
notion image
 

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 column
C is the Submitted at column
+6/24 adds 6 hours to the UTC time (eg: -8 hours = -8/24, etc)