Google Spreadsheet API in flask python
How can I import all the necessary packages in? I tried using "import oauth2client" but it shows this error message.
This file cannot be displayed: https://storage.googleapis.com/replit/images/1538666682543_a05ba6e4d9c68a03d580ee2a55f4f1be.pn
@nithilan4 I'm trying to write a scraper for Google Classroom. The packages hint got me past the oauth2 error, but now instead I get a message saying it wants to authorise me in the browser, and if not, I should add:
I have a credentials.json with valid (I think) credentials. Did you get yours working?
import pygsheets import pandas as pd def write(topp1, topp2, topp3): name=input("What is the name of the google doc?") #authorization gc = pygsheets.authorize(service_file='client_secret.json') #YOUR SECRET CODE THING # Create empty dataframe df = pd.DataFrame() # Create a column df['stuff'] = ["help", "me"] #stuff is title, help, and me, are the rows below #open the google spreadsheet (where 'PY to Gsheet Test' is the name of my sheet) sh = gc.open('NAME OF SPREADSHEET') #select the first sheet wks = sh #update the first sheet with df, starting at cell B2. wks.set_dataframe(df,(1,1))