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:

1. Enter desired Project Name, ID, and Location to get access to the new project and Click on Create

1. Click on ENABLE APIS AND SERVICES

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

1. Click on Enable

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

1. Enable Google Sheets API

1. Click on Enable

1. Again Click on APIs & Services and select OAuth Consent Screen

1. On the OAuth Consent Screen select the user type (External) and click on the "Create" button.

1. Add sensitive scopes for Drive files and Spreadsheets as we have to deal with sheets and save data to them. Here are the required Scopes to enable

   1. Google Drive API ../auth/drive

   2. Google Drive API ../auth/drive.metadata.readonly

   3. Google Sheets API ../auth/spreadsheets

1. Check the summary and further move to create Auth Credentials.

Note: Make sure to publish the app. If your app is in testing mode then user tokens will expire in 7 days. Please find this explanations here: https://support.google.com/cloud/answer/10311615#zippy=%2Ctesting

Visit the OAuth consent screen and click on the publish button to change from the testing status to the published status Google wants verification to publish the app. You don't need to verify to publish the app. Users will be warned about an untrusted application if you haven't verified it.

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

1. Select Web application in Application Type and click on create.

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

1. Your Credentials have been generated.

1. Now copy this credentials and enter the credentials in Manual Authentication Method, then click the Save button