How to enable Google Sheet API and get Google Client id and Secret Id

Step 1: Enable Google Sheets API

  1. Visit the Google Cloud Console.
  2. Create a new project or select an existing one.

1-create-project

  1. Click on Go to APIs overview.

2-go-to-apis

  1. Select Enable APIs and Services.

3-enable-apis-and-services

  1. Search for and select Google Sheets API, then click Enable.

4-search-for_google-sheets-api 5-enable-google-sheets_api

Step 2: Obtain Credentials

  1. On the top Google Sheets API screen, click on Create Credentials.

6-create-credentials

  1. Choose Google Sheets API, User data, then click Next.

7-credential-type

  1. Add the information for OAuth Consent Screen, then click Save And Continue
  2. In the Scopes section, click on Add or remove scopes.

8-add-scopes

  1. Find and select the Google Sheets API (description: “See all your Google Sheets Spreadsheets”), click Update then Save and Continue.

9-add-google-sheets-api-scope

  1. In the OAuth Client ID section, select Application Type as Desktop App, enter any name, then click Create.

10-create-desktop-app

  1. Click Done.

Step 3: Accessing Your Client ID and Client Secret

  1. On the Google Sheets API screen, go to the Credentials tab, you will find the new Client ID.

11-find-credentials

  1. Click on the Edit button to find the Client ID and Client Secret.
  2. Copy the Client ID and Client Secret, and paste them into the corresponding settings in the Sheets Exporter Settings Window

12-copy-client-ids-and-secret-id