google sheet python read

1# google sheet package
2from gsheets import Sheets
3
4# Authorizing the api
5#create oath credentials and generate a json file and paste here
6sheets = Sheets.from_files('FD4GS.json', 'FD4GS_cache.json')
7
8
9
10vi1 = sheets.get('#Paste your sheet id')
11
12vi1_form1_ws = vi1.sheets[0] #Sheet range
13
14entries1 = vi1_form1_ws.values()[1:] #Here I'm traversing from 2nd columns
15
16entries1 = [(i[2], i[6], i[1]) for i in entries1] # This represent, in my spread sheet I have 6 columns
17