Early Bird Lifetime Deal
Bit Flows Automation Tool Like Zapier in WordPress
Deal Will Be Ends: 28 February
00

days day

00

hours hour

00

Mins Mins

00

Secs Secs

Bit Integrtaions new logo
Fluent Forms alternatives
Estimated reading: 7 minutes 579 views

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.

Google Sheets Integration with Bit Integrations - Search and Select Google Sheets

👉 There are two options for connecting with Google Sheets:

One Click Authorization

You can easily connect your Google Sheets account to Bit Integrations using this method. This integration allows you to send data directly to your Google Sheets from your selected trigger within Bit Integrations.

  • Select Google Sheets as the action.
  • Click on One Click Authorization.
  • Choose your Google account.
  • Click on Advanced.
  • Click on Go to.
  • Click on Continue.
  • Your Google account will appear. Click on Next.
  • Select the Spreadsheet, Worksheet, and Header Row.
  • Complete the field mapping.
  • Click on Next.
  • Click on Finish and then Save.

Custom Authorization

In the Custom App Method, visit the Google API Console to create a new project and then set up an app. After creating your app, you’ll need to configure its settings to integrate with Bit Integrations. This method provides more control and customization over the connection between your Google account and Bit Integrations.

First, click on Custom Authorization for the Choose Channel.

Google Sheets Integration with Bit Integrations - Click Custom Authorization

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

Google Sheets Integration with Bit Integrations - Set Integtation Name

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.”
Google Sheets Integration with Bit Integrations - Create Project
Google Sheets Integration with Bit Integrations - Set project Name and click on create

2. Enable APIs:

  • Now, go to “APIs & Services.”
  • Search and enable both the Google Drive API and the Google Sheets API.
Google Sheets Integration with Bit Integrations - APIs and Services
Google Sheets Integration with Bit Integrations - search
Google Sheets Integration with Bit Integrations - Search and click on Google Drive API
Google Sheets Integration with Bit Integrations - Enable Google Drive API
Google Sheets Integrations - Search and Click on Google Sheets API
Google Sheets Integration with Bit Integrations - Enable 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.” Add these scopes. Then, click on “Update.”
    1. https://www.googleapis.com/auth/drive
    2. https://www.googleapis.com/auth/drive.file
    3. https://www.googleapis.com/auth/drive.metadata
    4. https://www.googleapis.com/auth/spreadsheets
    5. https://www.googleapis.com/auth/userinfo.profile
    6. https://www.googleapis.com/auth/userinfo.email
  • 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.
Google Sheets Integrations Copy Client ID and Client Secret
Google Sheets Integration with Bit Integrations - Paste Client ID and Client Secret

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.

Google Sheets Integration with Bit Integrations - Spreadsheet

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

Google Sheets Integration with Bit Integrations - Worksheet

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

Google Sheets Integration with Bit Integrations - Header Row 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.

Google Sheets Integration with Bit Integrations - Field Mapping

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.

Bit-Integrations-Conditional-Logics

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 with Bit Integrations - Finish and Save

Google Sheets Integration Log

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

Google Sheets Integration with Bit Integrations - Timeline
Google Sheets Integration with Bit Integrations - Integration Log

Troubleshooting Request had invalid authentication credentials Error

Error Description

“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.

Share this Doc

Google Sheets Integrations

Or copy link

CONTENTS