Google Sheets Integration | Free Form Builder

The Tally Google Sheets integration allows you to automatically send form submissions directly to Google Sheets in real-time. Whether you're collecting survey responses, managing event registrations, or tracking customer feedback, this free integration eliminates manual data entry and keeps your spreadsheets updated automatically.

Connect your Tally forms to Google Sheets in minutes—no coding required.

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.

How the Google Sheets integration works How do I integrate Tally with Google Sheets?How do I view integration logs How do I delete the Google Sheets integration Show local timezone in Google Sheets FAQ Popular use cases for the Google Sheets Integration

How the Google Sheets integration 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.

How do I integrate Tally with Google Sheets?

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 connection a title in the Connection name field. Select the Google account you want to use and select the spreadsheet you want to send your responses to. You can create a new one or connect to an existing spreadsheet and sheet on your Google Drive.

If you want to export all existing form submissions to your spreadsheet, make sure Export existing submissions is toggled on. Then, click Save changes.

Once connected, a link to your (new or existing) spreadsheet will be visible in your Tally dashboard. Find it in the Integrations tab of your published form.

You can move your sheet to another Google Drive folder and move or delete columns in the sheet without affecting the integration.

How do I 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.

How do I 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.

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.

FAQ

How do I integrate Tally with Google Sheets? To integrate Tally with Google Sheets, go to your form's Integrations tab, click Connect to Google Sheets, sign in to your Google account, and configure the connection. All form submissions will automatically sync to a new spreadsheet.

Is it free to send form submissions to Google Sheets? Yes! The Google Sheets integration is completely free for all Tally users. You only need a free Google account to create spreadsheets.

Can I export existing form submissions to Google Sheets? Yes, when setting up the integration, toggle on "Export existing submissions" to automatically populate your spreadsheet with all previous responses.

Can I connect one form to multiple Google Sheets? Yes, you can set up the Google Sheets integration multiple times to send data from one Tally form to different spreadsheets.

Popular use cases for the Google Sheets Integration

📊 Survey & Feedback Collection Automatically compile survey responses and customer feedback in Google Sheets for easy analysis and sharing with your team. Perfect for customer satisfaction surveys and NPS forms. 📅 Event Registration Management Track event registrations, attendee information, and RSVP responses in real-time spreadsheets. Ideal for event registration forms and booking forms. 🏢 Lead Generation & Sales Capture leads from contact forms and automatically organize them in Google Sheets for your sales team. Works with contact forms and lead generation forms. 📝 Application & Intake Forms Process job applications, client intake forms, and scholarship applications efficiently by syncing all submissions to spreadsheets. Use with job application forms and intake questionnaires. 📈 Data Analysis & Reporting Create visual reports and analyze form data using Google Sheets' built-in charts, pivot tables, and formulas. Share insights with stakeholders instantly.