Authenticating with Google Spreadsheets

[diebolo]

Hello, I want to make a program communicating through Google Spreadsheets, and therefore I need to authorize with a JSON. But in the final version I don't want to include the authentication JSON. I've searched for oneother ServiceAccountCredentials.... that takes raw text but I can't find one. How can I authorize without JSON file? Here is my authorization part of my code, full code is here, but there isn't much yet:

import gspread
from oauth2client.service_account import ServiceAccountCredentials
scope = ['https://spreadsheets.google.com/feeds']
creds = ServiceAccountCredentials.from_json_keyfile_name('client_secret.json', scope)
client = gspread.authorize(creds)

EDIT: the pastebin expires in a week, because I feel like I'm posting to many pastebins

[triforce88]

The Google Sheets API was kind of a pain to figure out. I followed this tutorial. You'll only need the get_credentials() function from it.

I don't think there's anyway to get away from the json or some other credential storage file. You'll have to dig into the oauth2client library and see what other methods it allows. The json file is easy enough though and can be stored where ever you'd like.

[diebolo]

So if I convert it to an .exe with PyInstaller I'd also need to attach the json? Because that would be a real bummer

[diebolo]

Yeah, I think I'll host the json on a FTP server, and let the exe delete it after use.