How to Integrate Forms With Google Sheets

Integrating your form with Google Sheets lets you automatically send submissions into a spreadsheet as they come in. This helps you keep everything organized in one place—ideal for tracking responses, team collaboration, or maintaining a live backup. It’s especially useful for operations teams, project managers, or anyone who wants form data to be effortlessly captured and ready to use for reporting, sorting, or sharing.

Notes:

• Changes made directly in Google Sheets don’t change any form entries.
• Renaming column headers in Google Sheets may break the connection. If this happens, the integration can be reconnected to restore syncing.
• Filters in Google Sheets can stop new submissions from showing right away. If data isn’t appearing, remove and reapply the filters to refresh the sheet.
• Inline edits in Tables don’t sync to Google Sheets, but editing an entry itself will update the linked spreadsheet.

Adding and Setting Up Actions

Setting up actions that send form data to Google Sheets only takes a moment—here’s how:

1. In Form Builder, in the orange navigation bar at the top of the page, click on Settings.
2. Then, in the menu on the left side of the page, click on Integrations.
3. Now, in the Integrations section on the right, click on Google Sheets.

4. In the Google Sheets section, select one of the following actions:
   • Create New Spreadsheet — Sends form submissions to a new spreadsheet and adds each entry as a new row.
   • Use Existing Spreadsheet — Sends form submissions to an existing spreadsheet by creating a new worksheet and adding entries there.
5. Then, click on Next.

6. Now, click on Authenticate. And then, in the pop-up window, log in and authorize access for the integration to your Google account.

If there is a saved Google account you’ve integrated any of your forms with before, you can choose its email address from the dropdown and click on the Authenticate button on the right to use it. Or, you can also click on Use Another Account below the dropdown to log in and authorize access for the integration to a different Google account.

7. Then, in Integration Settings, you’ll see this list of settings you can configure:
   • Enter Spreadsheet Name — This only shows when the Create New Spreadsheet action is selected. Enter a name for the spreadsheet that will be created in your Google account, where form submissions will be stored.
   • Select a Spreadsheet — This only shows when the Use Existing Spreadsheet action is selected. Click on the Select button on the right side of it and then, in the Integration Picker window, choose the spreadsheet you want to send form data to.
   • Enter Worksheet Name — Enter a name for the worksheet that will be created in the new spreadsheet or the spreadsheet you selected, where submitted data will be added.
   • Select Form Fields to Send to Google Sheets — Put checks in the boxes next to the form fields you want to send to your spreadsheet, so each submission fills the correct column. If your form has many fields, you may need to scroll down to see additional submission details that can be sent to your spreadsheet, such as Submission ID, Submission URL, Submission Edit URL, Submission Date, Submission Edit Date, and Submission IP. The Submission ID is required and can’t be unchecked.
   • Send Existing Submissions to the Sheet — Uncheck the box next to this option if you only want to send new submissions to your spreadsheet and skip entries that were submitted before the integration was set up.

8. Once everything is set, click on Save.

That’s it. You’ve successfully set up an action for your Google Sheets integration.

Managing Actions

Once you’ve added your actions, you can manage them anytime to keep things organized and running the way you want. You can edit an action, check its logs, rename it, turn it on or off, or delete it if you don’t need it anymore.

Hover your mouse over an action and, on the right side of it, click on the Edit icon to open and update it in the Integration Settings.

Note: Always click the Save button after making changes to make sure they’re applied.

Click on the Three Dots icon next to the Edit icon and, in the menu that comes up, select one of the following options:

• See Action Logs
• Rename Action
• Disable Action
• Delete Action

Viewing Action Logs

This opens the Action Logs window, where you’ll see successful and failed run logs of a Google Sheets integration action from the last seven days.

Notes:

• Use the dropdown menu on the right side of the Action Logs window to filter logs by All, Successful, or Failed.
• In the Status column, click on the Downward Arrow icon next to Failed to view the error details of a log.
• In the Submission ID column, click on an ID to open and review the details of the submission in another browser tab.

Renaming Actions

This gives a Google integration action a new name. It helps you label actions more clearly to match recent changes in your workflow.

Disabling Actions

This temporarily stops a Google Sheets integration action from running. It’s useful when you need to pause it without deleting it. When an action is disabled, the indicator next to its name changes from Enabled to Disabled. Click on the Three Dots icon and then select Enable Action to turn it back on.

Deleting Actions

This permanently deletes a Google Sheets integration action and is helpful when it’s no longer needed. After you click on Yes, Delete in the confirmation window, the action is removed forever. If you only need to pause it, consider disabling it instead.