# Google Sheets integration

### 📝 Steps 1: Connect the app with Google 

Please follow this [guide](https://docs.powerfulform.com/app-integration/google-integration) to complete this step.

***

### 📝 Steps 2: 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://3488889492-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEGgRVSDpMlcGFz1igK0s%2Fuploads%2FaXhQD1Iua7i7YJo4kXdb%2F2026-01-30_15-38-44.png?alt=media&#x26;token=a797715e-37df-457d-8d7e-e083957e76fe" 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://3488889492-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEGgRVSDpMlcGFz1igK0s%2Fuploads%2FSwKpzBJzo6zTe93EEEAZ%2F2026-01-30_15-39-27.png?alt=media&#x26;token=bc0c8649-4d97-4ad5-bff3-2d2266148135" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://3488889492-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEGgRVSDpMlcGFz1igK0s%2Fuploads%2FiMpn5lsSp2tCYiGbnxTL%2F2025-12-01_17-13-59.png?alt=media&#x26;token=0bad12eb-9e39-49d2-b0b3-0ec3921a507d" alt=""><figcaption></figcaption></figure>

5. Click **Save.**

***

### ✅ How It Works <a href="#how-it-works" id="how-it-works"></a>

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://3488889492-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEGgRVSDpMlcGFz1igK0s%2Fuploads%2FNevEorNlUgiGCafRhrnW%2Fimage.png?alt=media&#x26;token=a257d6d1-191f-40a2-91f0-707cdf12d645" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3488889492-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEGgRVSDpMlcGFz1igK0s%2Fuploads%2FRXkPBZUfkO1weHJnlp0B%2Fimage.png?alt=media&#x26;token=51259fb4-59a8-4e94-bafa-4b17056b017b" 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

#### ❗ “My Google account isn’t showing any sheets.”

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.

#### ❗ “New submissions are not appearing in the sheet.”

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.&#x20;

***

### ❓ FAQs

#### **Can I sync multiple forms to the same Google Sheet?**

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

#### **Can I change the spreadsheet later?**

Yes! Just reopen Google settings and select another sheet.

#### **Will old submissions sync after setup?**

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

#### **Can I disconnect Google at any time?**

Yes. It will simply stop sending new submissions.

***

#### Need More Help?

If you still need assistance, please contact us at [**support@powerfulform.com**](mailto:support@powerfulform.com). Our team will be happy to help you resolve any issues or guide you further.