> ## Documentation Index
> Fetch the complete documentation index at: https://docs.formbox.app/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Sheets

> With the Google Sheets integration, you can send your Formbox form submissions straight to a Google Sheet. <br/><br/>This is a great way to manage and share your form results with your team and create visual reports of your data.

## How it works

Once the integration is set up, a new row is automatically added to your Google Sheet every time someone submits your form.

## Setting up the integration

Go to the **Integrations** tab of your Formbox form and click **Connect** on the Google Sheets integration.

<Frame>
  <img src="https://mintcdn.com/formbox/05sa9iZ1Da5XhrTY/images/google-sheets-integration.png?fit=max&auto=format&n=05sa9iZ1Da5XhrTY&q=85&s=1b095447238b3ce9ca6af3cd32dbb490" style={{ borderRadius: "0.5rem" }} width="2606" height="1700" data-path="images/google-sheets-integration.png" />
</Frame>

A window will pop up, prompting you to connect your Google account. Select the Google account you want to use and allow Formbox to access your Google Sheets.

Once the integration is connected, Formbox will automatically create a new Google Sheet with the same name as your form. You can access the google sheet by clicking on the **Open Google Sheet** button in the dropdown menu.

<Frame>
  <img src="https://mintcdn.com/formbox/05sa9iZ1Da5XhrTY/images/google-sheets-integration-dropdown.png?fit=max&auto=format&n=05sa9iZ1Da5XhrTY&q=85&s=c70f47f9d8ef8f0453bb01b4d9153e1f" style={{ borderRadius: "0.5rem" }} width="2768" height="1730" data-path="images/google-sheets-integration-dropdown.png" />
</Frame>

You can rename the Google Sheet if you want without affecting the integration.

<Frame>
  <img src="https://mintcdn.com/formbox/05sa9iZ1Da5XhrTY/images/google-sheet.png?fit=max&auto=format&n=05sa9iZ1Da5XhrTY&q=85&s=60627d230e7d3d3ea83ae2c98b394167" style={{ borderRadius: "0.5rem" }} width="2490" height="1158" data-path="images/google-sheet.png" />
</Frame>

## Editing your spreadsheet

You can style your Google Sheet, freeze rows, add filters, add formulas, add custom columns, and edit existing rows.

Formbox uses the column headers created from your form fields to keep new submissions organized. If those headers are renamed, deleted, or moved out of the first row, new submissions may appear in unexpected columns or Formbox may add the missing columns back.

For the most reliable syncing, keep the first row as the header row and avoid changing the Formbox-generated column names.

## Customizing the integration

You can customize the Google Sheets integration by clicking on the **Manage integration** option in the dropdown menu.

<Frame>
  <img src="https://mintcdn.com/formbox/05sa9iZ1Da5XhrTY/images/google-sheets-integration-dropdown-manage.png?fit=max&auto=format&n=05sa9iZ1Da5XhrTY&q=85&s=c29e1b210db5395ee39f48e93e84b0bb" style={{ borderRadius: "0.5rem" }} width="2768" height="1730" data-path="images/google-sheets-integration-dropdown-manage.png" />
</Frame>

Here you can change the Google Sheet where the form submissions are sent to, by updating the **Spreadsheet Id** field.

<Frame>
  <img src="https://mintcdn.com/formbox/05sa9iZ1Da5XhrTY/images/google-sheets-integration-dropdown-manage-dialog.png?fit=max&auto=format&n=05sa9iZ1Da5XhrTY&q=85&s=e84a01a146384ad980a86cc3faae4e61" style={{ borderRadius: "0.5rem" }} width="2768" height="1730" data-path="images/google-sheets-integration-dropdown-manage-dialog.png" />
</Frame>

You can find the **Spreadsheet Id** in the URL of your Google Sheet. It is the long string of letters and numbers between `/d/` and `/edit` of the URL.

<Frame>
  <img src="https://mintcdn.com/formbox/05sa9iZ1Da5XhrTY/images/google-sheets-spread-sheet-id.png?fit=max&auto=format&n=05sa9iZ1Da5XhrTY&q=85&s=2d8c1a400d38718f881c2e055220c95b" style={{ borderRadius: "0.5rem" }} width="3402" height="1734" data-path="images/google-sheets-spread-sheet-id.png" />
</Frame>

## Deleting the integration

If you no longer want your integration to send form submissions to your spreadsheet, click the **Delete** option in the dropdown menu. Removing the integration won’t delete the Google Sheet document itself, but any future form submissions will stop being added to that spreadsheet.

<Frame>
  <img src="https://mintcdn.com/formbox/05sa9iZ1Da5XhrTY/images/google-sheets-integration-dropdown-delete.png?fit=max&auto=format&n=05sa9iZ1Da5XhrTY&q=85&s=dd37fbd1da5913a6c507b154cf08f505" style={{ borderRadius: "0.5rem" }} width="2768" height="1730" data-path="images/google-sheets-integration-dropdown-delete.png" />
</Frame>
