PowerBI Google Sheets integration with Python

[Laila92]

I managed to get Python to read from a Google Sheet. However, because I am using the script from within PowerBI to read from a Google Sheet, I can't use the local secret JSON key file on my computer, as PowerBI can't access this file. I currently connect to the sheet as follows:

scope = ['https://spreadsheets.google.com/feeds','https://www.googleapis.com/auth/drive']credentials = ServiceAccountCredentials.from_json(r'C:\Users\Laila\Documents\google_spreadsheet_secret_key.json', scope)gc = gspread.authorize(credentials)
return gc,credentials

I would like to do something like this:

secret_key={xxx:xxx}scope = ['https://spreadsheets.google.com/feeds','https://www.googleapis.com/auth/drive']credentials = ServiceAccountCredentials.from_json(secret_key)gc = gspread.authorize(credentials)
return gc,credentials

Is this possible?

I already tried adding the secret key with JSON dumps and adding it like that.

(ServiceAccountCredentials.from_json documentation,json.loads() documentation)

[Greg_Deckler]

Maybe use a gateway?

[Laila92]

I am using  a gateway (you actually helped me with that), but my computer is not always on.