> 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/~/revisions/KRfi0fHdeAFeAhiPrH7G/app-integration/google-sheets-integration.md).

# Google Sheets integration

After the form is submitted, the submitted data will be automatically add to a selected worksheet in your Google Sheets.

### 🛠️ Steps 1 - Connect the app with Google 

Please follow this [guide](/~/revisions/KRfi0fHdeAFeAhiPrH7G/app-integration/google-integration.md) 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 its name

<figure><img src="https://3488889492-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEGgRVSDpMlcGFz1igK0s%2Fuploads%2FFDjDx730nwDOmeuPIjxn%2Fimage.png?alt=media&amp;token=04a0afed-5aef-494c-9c43-057d1912a52d" 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%2FAUGNWD2iNXRlBbNwJhaz%2F2025-12-01_17-13-15.png?alt=media&amp;token=f1ee82a1-8158-4f48-b2e2-0697f19d5128" 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&amp;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&amp;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&amp;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.