Ask coding questions

← Back to all posts
Google Spreadsheet API in flask python
slip1244 (257)

How can I import all the necessary packages in? I tried using "import oauth2client" but it shows this error message.

Answered by timmy_i_chen (1180) [earned 5 cycles]
View Answer
timmy_i_chen (1180)

Have you tried installing it using the package manager in the sidebar? :)

JohnKershaw (3)

@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?

slip1244 (257)

@JohnKershaw yup, import pygsheets, so nice

slip1244 (257)


import pygsheets
import pandas as pd

def write(topp1, topp2, topp3):
  name=input("What is the name of the google doc?")
  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)

  #select the first sheet 
  wks = sh[0]

  #update the first sheet with df, starting at cell B2. 
timmy_i_chen (1180)

@nithilan4 btw you can use markdown here - something like

  # your code here

(except have the backticks line up :) )

JohnKershaw (3)

@nithilan4 Thanks - I'll give it a try!