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
