# Google Sheets integration

### 🛠️ 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="/files/0P9XaoZjLLZINHX9CVt6" 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="/files/5s7JSB93qexzDNBmzIjm" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/TDzcSa0CerhbpPIu4hxH" 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="/files/xywP64bdnPHrSQFTjMcw" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/kRcyeUyPXstotvJSIPqv" 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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.powerfulform.com/~/revisions/KRfi0fHdeAFeAhiPrH7G/app-integration/google-sheets-integration.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.