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 to set up the Google Sheets integration with Tally How do I view integration logs?How do I delete the Google Sheets integration?How do I show local timezone in Google Sheets?Why is Tally the best form builder for Google Sheets?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 to set up the Google Sheets integration with Tally

Open your form’s integration tab: Go to the Integrations tab of your published form and click Connect to Google Sheets.

Authorize your Google account: Click Log in to Google and select the Google account where you want to create the spreadsheet. Grant Tally permission to access Google Sheets.

Configure Your Integration: 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.

Configure Tally integration with Google Sheets

Access Your Spreadsheet: 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.

Your Tally form submissions are automatically visible in a Google Spreadsheet

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

View your form submissions in Google Sheets

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.

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

Why is Tally the best form builder for Google Sheets?

Tally is completely free: unlike other form builders, Tally’s Google Sheets integration is completely free for all users. Tally also offers unlimited forms and submissions for free.

Create professional looking forms: Tally offers form customization that lets you control every design aspect from form layouts, colors, and button styles to input fields—all without requiring any coding knowledge.

A modern and intuitive interface: Tally's editor is simple and intuitive. To insert content blocks, you can type or select from our quick block insert menu.

See how Tally and Google Forms compare

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.

Start syncing form responses to Google Sheets today

Just start typing, you don’t even need an account to create your first Tally form.

Create a free form