where can I find the google sheets table by json credentials

Question

I have a json with access keys in google sheets:

{
  "type": "service_account",
  "project_id": "ojects-1589375027080",
  "private_key_id": "5edff5401fe4448e93",
  "private_key": "-----BEGIN PRIVATE KEY-----\nMIIEvAIBADANBgkqhkiG9w0BAQEFAASCBKYwggSiAgEAAoIBAQDFMoGTAYFHAX6m\n0TNh9Y4ZP9VS1dIlSc1Cqm7OoU38c9Xiiz+s4n+S9RpaiGLdlM8PRTEKpXHKh+2K\nb+CpGEtNgUa+CY4qE4e4Mw==\n-----END PRIVATE KEY-----\n",
  "client_email": "[email protected]",
  "client_id": "10454546",
  "auth_uri": "https://accounts.google.com/o/oauth2/auth",
  "token_uri": "https://oauth2.googleapis.com/token",
  "auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
  "client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/%40appspot.gserviceaccount.com"
}

(removed most of the data)

I'm sure my api works fine with google sheets. i create tables, write information, retrieve it via python gspread. But the most important question is, how do I view this table? how do I get a link to it? I didn't create the credentials, I just got this json

thank you so much! i couldn't have become a programmer without you!

Answer 1

This JSON file is created in GCP , inside a project following steps documented here.

Due to the sensitivity of it, you can only download it once as per documentation:

Clicking Create downloads a service account key file. After you download the key file, you cannot download it again.

So, basically once that is created you cannot retrieve it again, it is not hosted anywhere so you cannot get a link to see it/get it.

If you are using that JSON contents, you can store it on a .JSON file and upload it to a safe place, ex. your Google Drive and get the link to it so it is shared as needed.

If you loose it, you will need to create a new one.