> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.opnform.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How do I integrate Google Sheets for my database?

### Integrating Google Sheets with Your Form: A Step-by-Step Guide

Integrating Google Sheets with your form can streamline data collection and analysis. Follow these simple steps:
**1. Access Your Account**
Log in to your OpnForm account at [opnform.com](https://opnform.com).
**2. Select Your Form**
From your dashboard, choose the specific form you want to connect to Google Sheets.
**3. Explore Integration Options**
In the form editor, click on the **‘Integrations’** tab.
**4. Choose Google Sheets**
From the list of available integrations, select **‘Google Sheets’**.

![](https://storage.crisp.chat/users/helpdesk/website/-/1/b/5/b/1b5b982fc3df6500/chromevxdapyfirw_88toud.png)


**5. Enable the Integration**
Toggle the switch to enable Google Sheets integration for your form.
**6. Connect Your Google Account**
Click **‘Connect Google Account’** to begin the integration process.

![](https://storage.crisp.chat/users/helpdesk/website/-/1/b/5/b/1b5b982fc3df6500/chromechhklarf5d_l68kbj.png)


**7. Authorize Access**
Log in with your Google credentials or select an existing account.
Follow the on-screen prompts to grant OpnForm access to your Google Sheets.
**8. Finalize the Integration**
Once authorized, your form data will automatically sync to a new or existing Google Sheet.







By following these steps, you can seamlessly integrate Google Sheets with your form, making data management more efficient and accessible. If you encounter any issues during the process, ensure that you have the necessary permissions and that your Google account is up-to-date. Enjoy the enhanced functionality of your integrated form and Google Sheet!


If desired, specify a condition for when the system should send email confirmation messages


![](https://storage.crisp.chat/users/helpdesk/website/-/1/b/5/b/1b5b982fc3df6500/chromev1bpiwmgha_109m6ur.png)



![](https://storage.crisp.chat/users/helpdesk/website/-/1/b/5/b/1b5b982fc3df6500/chromewrzgzst63d_145ltc4.png)