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

[Ghost]

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,

[iaditya_nanda]

@Ghost but where do you need them?

[Ghost]

sorry, I don’t understand what you mean

[Ghost]

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

[iaditya_nanda]

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.