Google Sheets

Follow the below steps to connect to the Google Sheets API.

Step 1. Create the Integration

1. Navigate to Formie → Settings → Miscellaneous.
2. Click the New Integration button.
3. Select Google Sheets as the Integration Provider.

Step 2. Connect to the Google Sheets API

1. Go to the Google API Console.
2. Select an existing project or create a new one.
3. Go to the APIs & Services → Library and enable the Google Drive API and Google Sheets API for the project.
4. Next, go to the APIs & Services → Credentials section.
5. Click Create Credentials → OAuth client ID.
   1. On the following page, select the Application Type as Web application.
   2. Provide a suitable Name so you can identify it in your Google account. This is not required by Formie.
   3. Under the Authorized JavaScript origins, click Add URI and enter your project's Site URL.
   4. Under the Authorized redirect URIs, click Add URI and enter the value from the Redirect URI field in Formie.
   5. Then click the Create button.
6. Once created, a popup will appear with your OAuth credentials. Copy the Client ID and Client Secret values and paste into the fields in Formie.

Step 3. Test Connection

1. Save this integration.
2. Click on the Connect button in the right-hand sidebar.
3. You‘ll be redirected to Google, where you must approve Formie to access your Google account.

Step 4. Form Setting

1. Go to the form you want to enable this integration on.
2. Click the Integrations tab.
3. In the left-hand sidebar, select the name you gave the integration.
4. Enable the integration and fill out all required fields.
5. Click Save to save the form.