Answers for "how to read data from google sheets in python"

4

google sheet python read

# google sheet package
from gsheets import Sheets

# Authorizing the api
#create oath credentials and generate a json file and paste here
sheets = Sheets.from_files('FD4GS.json', 'FD4GS_cache.json')



vi1 = sheets.get('#Paste your sheet id')

vi1_form1_ws = vi1.sheets[0] #Sheet range

entries1 = vi1_form1_ws.values()[1:] #Here I'm traversing from 2nd columns

entries1 = [(i[2], i[6], i[1]) for i in entries1] # This represent, in my spread sheet I have 6 columns
Posted by: Guest on August-09-2021

Code answers related to "how to read data from google sheets in python"

Python Answers by Framework

Browse Popular Code Answers by Language