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’ll need a free Google account.
The Google Sheets integration is available for free to all Tally users. To use the integration and create a spreadsheet, you’ll need a free Google account.
notion image
 


How it works

Once the integration is live, a new row is automatically created in your Google Sheet every time someone submits your form. The submitted form responses automatically appear in the spreadsheet.
You can modify the columns in the spreadsheet as needed by moving or deleting them. The form responses will continue to populate according to the updated column structure.
If you set up the integration for an existing Tally form, all previous responses will instantly populate the spreadsheet as individual rows. Going forward, a new row will be added after each new form submission.
 
You can connect your Tally form to different Google Sheets spreadsheets by setting up the integration multiple times.
You can connect your Tally form to different Google Sheets spreadsheets by setting up the integration multiple times.

How to set it up

Go to the Integrations tab of your published form and click Connect to Google Sheets.
 
notion image
 
A window will pop up, prompting you to connect your Google account. Click on Log in to Google and either choose an account that appears or click on Use another account to sign in with a different Google account you're not currently signed into.
 
Give your spreadsheet a title or description in the Connection name field. If you want to export all existing form submissions to your new spreadsheet, make sure Export existing submissions is toggled on. Then, click Save changes.
 
notion image
 
Once connected, a new spreadsheet will be created in the default Drive of your chosen Google account, and a link to this spreadsheet will be visible in your Tally dashboard. Find it in the Integrations tab of your published form.
 
notion image
 
You can move your sheet to another Google Drive folder and move or delete columns in the sheet without affecting the integration.
 
notion image
 

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
 

Delete the Google Sheets integration

If you no longer want your integration to send form responses to your Google Sheets, click 🗑 next to the integration to delete it. Removing the integration won’t delete the Google Sheets document itself, but any future form submissions will stop syncing to that spreadsheet.
 
notion image
 

Show local timezone in Google Sheets

Submission times are displayed in Coordinated Universal Time (UTC) when exported to integrations like Google Sheets. You can add another column in your spreadsheet to display submissions in your local timezone using a formula.
To add the formula, follow the steps below:
  • Create a new column and title it Local submitted at.
  • Copy the formula below and paste it into the formula field for the first cell under the new header you created:
    • =ARRAYFORMULA(IF(ROW(C2)=1, "Local submitted at", IF(ISBLANK(C2), "", C2+6/24)))
  • Adjust +6/24 in the formula to fit your time zone in relation to the UTC time. For example, if it’s -8 hours, change it to -8/24.
  • The formula will calculate and show the new time zone in the cell. Make sure the format is set to display the results as a time and date. Go into Format in the navigation, click on Number, and select Date time.
  • To apply the formula to the rest of the form entries, as well as forms submitted in the future, you can click and drag the first cell down manually.
  • Alternatively, click on the new calculated cell and copy it using cmd/ctrl+ C shortcut.
  • Then, press cmd/ctrl + shift + to automatically select all cells in the column and press cmd/ctrl+ V to paste the formula. This will ensure that whenever a new form is filled, the formula will apply to the newly created cells showing the adjusted time zone.