Google Spreadsheet API in flask python
h
slip1244 (257)

How can I import all the necessary packages in? I tried using "import oauth2client" but it shows this error message.
https://storage.googleapis.com/replit/images/1538666682543_a05ba6e4d9c68a03d580ee2a55f4f1be.pn

You are viewing a single comment. View All
Answered by timmy_i_chen (1188) [earned 5 cycles]
View Answer
slip1244 (257)

@JohnKershaw

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[0]

  #update the first sheet with df, starting at cell B2. 
  wks.set_dataframe(df,(1,1))