> For the complete documentation index, see [llms.txt](https://docs.powerfulform.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.powerfulform.com/integrations/google/google-sheets.md).

# Google Sheets integration

Send every new submission to a Google Sheet as a new row.

## How to set it up

{% stepper %}
{% step %}

### Connect the app with Google

Please follow this [guide](/integrations/google.md#connect-your-google-account) to complete this step.
{% endstep %}

{% step %}

### Connect form data to Google Sheets

1\. Open the app > click **Forms** > open the form you want to edit

2\. Click **Integration** icon on the left side bar > enable **Google Sheet** > click on Google Sheets option

<figure><img src="https://2907469752-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FehM2rz7MmKkWcJmgvJOe%2Fuploads%2Fgit-blob-11e76fb38d6ef3d62c0b27c134dbeb7ef59be630%2Fscreenshot-integration-google-sheets-integration-1.png?alt=media" alt=""><figcaption></figcaption></figure>

3. Create a new sheet file

Type `Contact Form` to create a new spreadsheet with this name. A new file will be generated automatically inside your Google Sheets.

<figure><img src="https://2907469752-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FehM2rz7MmKkWcJmgvJOe%2Fuploads%2Fgit-blob-f5cf71d1404b54969493a1e6aff3cdc8bd137caf%2Fscreenshot-integration-google-sheets-integration-2.png?alt=media" alt=""><figcaption></figcaption></figure>

4. Select your worksheet > select fields of form that you want to show on Google sheets

<figure><img src="https://2907469752-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FehM2rz7MmKkWcJmgvJOe%2Fuploads%2Fgit-blob-d0a4eabbdf757c36e4b4f8927daefcc13fec46d6%2Fscreenshot-integration-google-sheets-integration-3.png?alt=media" alt=""><figcaption></figcaption></figure>

5. Click **Save.**
   {% endstep %}
   {% endstepper %}

## How it works

When someone submits your form:

* A new row is added to your selected Google Sheet.
* Each checked field will appear as a column.
* Data is synced instantly.

<figure><img src="https://2907469752-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FehM2rz7MmKkWcJmgvJOe%2Fuploads%2Fgit-blob-713b7d442ff86f7142fe0967ef577c71c20e3a7b%2Fscreenshot-integration-google-sheets-integration-4.png?alt=media" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2907469752-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FehM2rz7MmKkWcJmgvJOe%2Fuploads%2Fgit-blob-73e62915e156a79139cb640941bb552469fcf6a5%2Fscreenshot-integration-google-sheets-integration-5.png?alt=media" alt=""><figcaption></figcaption></figure>

**Important Notes**

* Do not modify the structure of the selected worksheet (e.g., changing column headers, colors, or formatting), as this may disrupt the data synchronization process.
* Only use the worksheet to receive data; avoid manual edits to prevent potential issues.

## Troubleshooting

<details>

<summary>“My Google account isn’t showing any sheets.”</summary>

Try these:

* Make sure you connected the correct Google account.
* Refresh the page after connecting.
* Ensure your sheet is not in Trash or Restricted folders.
* Ensure you have at least *View* or *Edit* permissions.

</details>

<details>

<summary>“New submissions are not appearing in the sheet.”</summary>

Try:

* Confirm the worksheet tab still exists (Sheet1, Sheet2, etc.)
* Check that you selected the correct fields to sync.
* Disconnect → reconnect Google, then save again.
* The sheet is manually edited ⇒ the structure is changed.

</details>

## ❓ FAQs

<details>

<summary>Can I sync multiple forms to the same Google Sheet?</summary>

Yes! Each form can sync to the same spreadsheet by selecting different worksheets.

</details>

<details>

<summary>Can I change the spreadsheet later?</summary>

Yes! Just reopen Google settings and select another sheet.

</details>

<details>

<summary>Will old submissions sync after setup?</summary>

No. Only **new submissions** are sent to Google Sheets.

</details>

<details>

<summary>Can I disconnect Google at any time?</summary>

Yes. It will simply stop sending new submissions.

</details>

## Next steps

* [Connect your Google account](/integrations/google.md#connect-your-google-account) — the sign-in this integration needs.
* [Google Drive integration](/integrations/google/google-drive.md) — send uploaded files to Drive as well.
* [Export submissions](/submissions/export-submissions.md) — a one-off spreadsheet instead of a live one.
* [Contact support](/help/contact-support.md) — if rows stop appearing.