I’ve recently been tossed into a role where someone else had been working with atom and python to do our reporting, they basically only taught me how to change the google spreadsheets, the dates I’m looking for, and how to run it and that’s it. I’m trying to set atom up on a laptop so I can work remote next week. I have everything in place but I keep getting the same error message.
"Traceback (most recent call last): File "/Users/Loaner/Desktop/Python/FiveStarLCCActivitiesOfficialV3.py", line 16, in <module> refSh = Spread(credentials, 'CodeReference','FiveStarLCC') File "/opt/anaconda3/lib/python3.7/site-packages/gspread_pandas/spread.py", line 131, in __init__ self.client = Client(user, config, scope, creds) File "/opt/anaconda3/lib/python3.7/site-packages/gspread_pandas/client.py", line 91, in __init__ credentials = get_creds(user, config, self.scope) File "/opt/anaconda3/lib/python3.7/site-packages/gspread_pandas/conf.py", line 175, in get_creds reraise(ConfigException, *exc_info[1:]) File "/opt/anaconda3/lib/python3.7/site-packages/future/utils/__init__.py", line 415, in raise_ raise exc.with_traceback(tb) File "/opt/anaconda3/lib/python3.7/site-packages/gspread_pandas/conf.py", line 154, in get_creds config, scope, redirect_uri="urn:ietf:wg:oauth:2.0:oob" File "/opt/anaconda3/lib/python3.7/site-packages/google_auth_oauthlib/flow.py", line 159, in from_client_config 'Client secrets must be for a web or installed app.') gspread_pandas.exceptions.ConfigException: Client secrets must be for a web or installed app. [Finished in 3.917s]"
The person who originally set it up on my computer will not help- is only sending me links to forums, but I literally do not understand every other word. from googling I can tell this may be a problem with my json file but its EXACTLY the same as it is on my desktop and shit is working there just fine.
if there’s anyone out there that can help me, and put it in the dumbest terms possible, idiot-proof if you will, I would be forever grateful.
Nothing like messing with atom all day to make me feel like a total idiot.