Google Sheet API Setting

View Categories

Google Sheet API Setting

4 min read

How to Create New Client ID and Client Secret Keys? #

1. Login to your Google Account and Start here.
https://console.developers.google.com/apis/

2. Create New Project as shown below :

3. Click on Hem burger icon

4. Click on ENABLE APIS AND SERVICES.

5. Search for APIs and Services to Enable Google Drive API.

API Enable Google Drive

6. Click on Enable.

API Click Enable Google Drive

7. Click on APIs and Services and go to Library page.

Open Library Page

8. Enable Google Sheets API.

API Enable Google Sheet

 

9. Click on Enable.

API Click Enable Google Sheet

10. Click on the Overview and Get Started buttons to proceed.

Open OAuth Consent Screen

 

11. After getting started select the user type and click on the “Create” button.

With GSheetConnector as it requires authentication if you are selecting an Internal user type then you will require the same organizational domain email Id.

Example: If you create an API within an organization i.e gsheetconnector.com then while authentication the user email id must be of the same organization i.e [email protected]

And if you are using an External user type, you would need to verify our app by creating and providing a link to a YouTube video that shows how you will use the data you access using OAuth scopes. This will be a process of 5-6 days if you provide a quick response.

It will require the following points to be considered in the video and must be in English.

  1. How to log into your project (ensuring that the URL bar with the client ID is clearly visible)

  2. How to request an OAuth token (OAuth Consent Screen/Permissions Page)

  3. How your project’s functionality utilizes the requested scopes:

Refer video example to create an app verification video to be submitted to Google. #

Overview #

API Select User Type How to Create New Client ID and Client Secret Keys?

Project Configuration #

Create OAuth Credentails

Branding #

Add App Details

Create OAuth Client #

Add App Details

Add App Details

redirect URL #

The plugin’s redirect URL is given below. Please use the provided redirect URL based on the plugin you are using.

  • CF7 GSheetConnector : (your-domain.com)/wp-admin/admin.php?page=wpcf7-google-sheet-config
  • Ninja Forms  GSheetConnector : (your-domain.com)/wp-admin/admin.php?page=njform-google-sheet-config
  • Gravity Forms  GSheetConnector :  (your-domain.com)/wp-admin/admin.php?page=gf_googlesheet
  • WP Forms  GSheetConnector : (your-domain.com)/wp-admin/admin.php?page=wpform-google-sheet-config
  • Formidable Forms  GSheetConnector :  (your-domain.com)/wp-admin/admin.php?page=formidable-form-google-sheet-config
  • Forminator Forms  GSheetConnector :  (your-domain.com)/wp-admin/admin.php?page=formntr-gsheet-config
  • WooCommerce GSheetConnector : (your-domain.com)/wp-admin/admin.php?page=wc-gsheetconnector-config
  • Easy Digital Download  GSheetConnector :   (your-domain.com)/wp-admin/admin.php?page=edd-gsheet-config
  • DIVI Forms GSheetConnector :  (your-domain.com)/wp-admin/admin.php?page=divi-db-google-sheet-config
  • Elementor Forms  GSheetConnector :   (your-domain.com)/wp-admin/admin.php?page=gsheetconnector-elementor-config
  • Avada Forms  GSheetConnector :   (your-domain.com)/wp-admin/admin.php?page=avada-gsheetconnector-config

Client ID for Web Application – OAuth Client Created #

Add App Details

Data Access (Scopes) #

Add sensitive scopes for Drive files and Spreadsheets as we have to deal with sheets and save data to them.
Note: Our API just fetches Drive Spreadsheets and no other data.

Here are the required Scopes to enable :

Google Drive API    ../auth/drive
Google Drive API    ../auth/drive.metadata.readonly
Google Drive API …/auth/drive.file

Google Sheets API  ../auth/spreadsheets
Google Sheets API …/auth/userinfo.email

Add Scopes
Add Scopes

Audience (Publish APP) #

Add Scopes

Verification #

Guide for Verifying Your Domain on Google

Add Scopes

Add Scopes

Add Scopes

 

Add Scopes

Add Scopes

Check the summary and further move to create Auth Credentials. Here further, if you want to create your APP as external you can do it by submitting the app verification video as per step 11.

App Summary

Click on Create Credentials and select OAuth client Id to obtain new credentials.

Create OAuth Credentails

Select Web application in Application Type and click on create.

Select APP Type

 

You must have add authorized redirect URI. It must be the integration page of the GSheetConnector plugin. Example as per Image.

Add Redirect URI

Your Credentials have been generated.

OAuth Credentials

Now copy this credentials and and enter the credentials in Manual Authentication Method,
Refer the following links as per the addon plugin you are using

Manual Authentication Setup for Google Drive Integration

Select Storage Location for File Uploads in Google Drive

Manual Authentication Method for WooCommerce Google Sheet Connector

Manual Authentication Method for CF7 Google Sheet Connector

Manual Authentication Method for WPForms Google Sheet Connector

Manual Authentication Method for Gravity Forms Google Sheet Connector

Manual Authentication Method for Ninja Forms Google Sheet Connector

Manual Authentication Method for Elementor Forms Google Sheet Connector

Manual Authentication Method for Divi Forms Google Sheet Connector

Manual Authentication Method for Avada Forms Google Sheet Connector

 

Refer to the Video of Setup Google Sheet API Settings – GSheetConnector #

Go to Top