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

Help me!, I want to create a database with a spreadsheet but in the latest update the Google Spreadsheet extension no longer uses the API but uses Credential Json.
Where do you get the json credentials from?

Please Help Me,

@Ghost but where do you need them?

sorry, I don’t understand what you mean

solution to find Credential Json from spreadsheet :arrow_double_down:
Dari
https://community.niotron.com/t/re-need-tutorial-for-spreadsheet-for-the-new-update/20129/2?u=ghost

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 CredentialsService 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