Google Sheets

Connect Google Sheets to send submitted information to your connected account. You need access to configure the form in Craft and credentials for the destination account. The steps below establish the connection; finish by sending a test submission to verify the result.

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. Choose the destination supported by this integration.
5. Use the variable picker to map its required fields to the appropriate form answers.
6. Enable the integration.
7. Click Save to save the form.

Verify a Submission

Save the form, open it on your site and submit recognisable test values. Find the resulting item in the destination you selected and compare its values with the test submission.

If nothing arrives, check whether integration conditions matched, whether the submission was complete and non-spam, and whether Craft’s queue has processed the job. A successful connection check verifies credentials; it does not prove that field mapping and delivery work. See Connect and Test an Integration for a complete mapping and verification workflow.