How to set the JSON credentials for the Niotron Google Spreadsheet extension?

Discuss
5

There are two main ways to obtain a credential JSON file for your Google Spreadsheet:

1. Using the Google Cloud Console:

  1. Go to the Google Cloud Console (https://console.cloud.google.com/).
  2. If you don’t have a Google Cloud account, create one.
  3. Once logged in, navigate to the APIs & Services section.
  4. Search for Google Sheets API and enable it.
  5. Create a new Service Account by clicking on Create Credentials → Service Account.
  6. Give your service account a name and choose a role. For most use cases, the Sheets Editor role should be sufficient.
  7. Click Create.
  8. On the next screen, you’ll see a JSON key file download button. Click on it to download the credential JSON file.

2. Using the Google Sheets API Explorer:

  1. Go to the Google Sheets API Explorer (https://developers.google.com/sheets/api/quickstart/python).
  2. Follow the instructions on the page to create a new project and enable the Sheets API.
  3. Click on Authorize and choose a New Client ID.
  4. Select Web Application as the application type and give it a name.
  5. Click Create.
  6. You’ll be redirected to a page with a client ID and client secret.
  7. Download the credential JSON file using the provided link.
1 Like