Google Sheets Integration: The Best Tool for Managing, Syncing, and Analyzing Your Data Efficiently

Google Sheets Integration: Use Google Sheets to create and edit online spreadsheets. Get insights together with secure sharing in real-time and from any device.

Bit Integrations is a WordPress plugin that allows you to automate and integrate your WordPress form builders and other plugins with Google Sheets. This can save you time and effort, and improve your lead generation and customer management processes. Bit Integrations supports a wide range of WordPress plugins, such as Bit Form, Contact Form 7, Gravity Forms, WPForms, WS Forms, Ninja Forms, Fluent Forms, Formidable Forms, Everest Forms, Elementor Form, Beaver Builder, Divi, Brizy, BuddyBoss, WooCommerce, WordPress User Registration, LearnDash LMS, LifterLMS, Memberpress, GiveWP, Easy Digital Downloads, AffiliateWP and many more so you can use it to automate and integrate your WordPress plugins with Google Sheets.

Google Sheets Integration Tutorials

Authorization of Google Sheets Integration

First, you have to select the Google Sheets from the actions page. To do this open your Bit Integrations dashboard then click on the Create Integration button now the Trigger page will open select any trigger from the list such as Bit Form, Contact Form 7, Gravity Forms, WPForms, WS Forms, Ninja Forms, Fluent Forms, Formidable Forms, Everest Forms, Elementor Form. Then proceed to next and the action page will open. Now Search and select Google Sheets from the action page.

Integration Name/Title: Here give the meaningful integration title as per your requirement.

To set up Google Sheets integration with Bit Integrations, you’ll need Google Sheets Client ID and Client Secret. Follow these steps to get them.

1. Create a Project:

• Visit the Google API Console and initiate a new project.
• Assign a suitable name to your project and click “Create.”

2. Enable APIs:

• Now, go to “APIs & Services.”
• Search and enable both the Google Drive API and the Google Sheets API.

3. Configure OAuth Consent Screen:

• After enabling the API, go to the “OAuth Consent Screen.”
• Choose “External” as the user type and click “Create.”
• Provide details for your app, including a name, support email, and developer contact information then click on “Save and Continue“.
• In the scope section, click on “Add or Remove Scopes.” Search for “Google Drive API” and select both “/auth/docs” and “/auth/drive.” Then, search for “Google Sheets API” and select both “/auth/spreadsheets” and “/auth/spreadsheets.readonly.” Finally, click on “Update.”
• Progress through the consent screen setup by clicking “Save and Continue” until you reach the dashboard.
• Publish your app and confirm the action.

4. Generate Client ID and Client Secret:

• Now, go to the “Credentials” section and click “Create credentials” followed by “OAuth Client ID.”
• Select “Web Application” as the Application type and assign a name.
• Under “Authorized JavaScript origins,” add your “Homepage URL“.
• Under “Authorized redirect URIs,” add the authorized redirect URIs from the integration page.
• Click “Create.”

5. Obtain and Utilize Credentials:

• Your Client ID and Client Secret will now be displayed.
• Copy these credentials and paste them into the appropriate fields on the integration page.

Once you have successfully entered your Google Sheets Client ID and Client Secret, click “Authorize” to proceed. Then click Next.

Spreadsheets: Select a Spreadsheet from the drop-down option.

Worksheet: Select a Worksheet from the drop-down option.

Header Row: Specify your header row, for instance, A1.

In the Google Sheets integration settings, you will see a “Map Fields” option. This is where you will need to map the fields from your form to the corresponding fields in Google Sheets. You have the option to map additional fields by clicking on the Plus (+) icon.

Conditional Logics

With this feature, you can incorporate conditions into the integration process. When the specified conditions align, the data will be transmitted to your Google Sheets. For additional details, we recommend consulting our documentation regarding conditional logic. After you have configured your conditional logic, click Next to continue.

Google Sheets Integration Save

Once you have configured the desired settings for the integration, click the Save & Finish button to save the integration.

Google Sheets Integration Log

Every integration has a timeline that you can use to check the success or error status of the integration.

Troubleshooting Request had invalid authentication credentials Error

“error”:{“code”:401,”message”:”Request had invalid authentication credentials. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.”,”status”:”UNAUTHENTICATED”}}

If you are facing the above Google token expiration issues, our developers contacted Google support and received the following guidance:

Welcome to the Google Cloud Community!

You are correct that once the Publishing status is set to “In Production,” tokens shouldn’t expire after 7 days. Please try the following steps from this Stack Overflow thread[1]:

1. Go to https://console.cloud.google.com/apis/credentials/consent and change the status from “Testing” to “Published.”
2. Delete the current token file.
3. Authorize the API again by signing into your Gmail account. You will encounter a warning screen; choose to proceed.
4. Once done, you will receive a new token file.

If these steps do not resolve the issue, you can contact Google Cloud Support for further assistance. Thank you!

Use Case

Bit Form with Google Sheets

Bit Form Integration with Google Sheets using Bit Integrations. When the Bit Form is submitted, the data provided is stored in Google Sheets.

Elementor Form with Google Sheets

Elementor Form Integration with Google Sheets using Bit Integrations. When an Elementor Form is submitted, the data provided is stored in Google Sheets.

Gravity Forms with Google Sheets

Gravity Forms Integration with Google Sheets using Bit Integrations. When Gravity Forms is submitted, the data provided is stored in Google Sheets.

WPForms with Google Sheets

WPForms Integration with Google Sheets using Bit Integrations. When a WPForms is submitted, the data provided is stored in Google Sheets.

Contact Form 7 with Google Sheets

Contact Form 7 Integration with Google Sheets using Bit Integrations. When the Contact Form 7 Form is submitted, the data provided is stored in Google Sheets.

Ninja Forms with Google Sheets

Ninja Forms Integration with Google Sheets using Bit Integrations. When the Ninja Forms Form is submitted, the data provided is stored in Google Sheets.

Forminator Forms with Google Sheets

Forminator Forms Integration with Google Sheets using Bit Integrations. When the Forminator Forms Form is submitted, the data provided is stored in Google Sheets.

Formidable Forms with Google Sheets

Formidable Forms Integration with Google Sheets using Bit Integrations. When the Formidable Forms Form is submitted, the data provided is stored in Google Sheets.

Fluent Forms with Google Sheets

Fluent Forms Integration with Google Sheets using Bit Integrations. When the Fluent Forms Form is submitted, the data provided is stored in Google Sheets.