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.

<aside> <img src="/icons/gift_green.svg" alt="/icons/gift_green.svg" width="40px" /> 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.

</aside>

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.

<aside> <img src="/icons/info-alternate_blue.svg" alt="/icons/info-alternate_blue.svg" width="40px" /> You can connect your Tally form to different Google Sheets spreadsheets by setting up the integration multiple times.

</aside>

How to set it up

Go to the Integrations tab of your published form and click Connect to Google Sheets.

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.