Skip to content

Latest commit

 

History

History
36 lines (28 loc) · 1.25 KB

README.md

File metadata and controls

36 lines (28 loc) · 1.25 KB
Raw

Github contributors

License: MIT

Description

Google sheets API, easy to use

Example of usage

from easy_googlesheets import GSheets

myGSheets = GSheets(secret_filename='credentials.json', 
                    spreadsheet_id='',
                    data_tab_name='Page 1',
                    control_id='user1')

# Example of filter output
filter_list=["lat>0", "lng<0"]
print(myGSheets.filter_by(filter_list))

# Example of insert row
myGSheets.insert({'name': '100 Montaditos ', 
                  'lat': float(37.3812499), 
                  'lng': float(-6.0085387), 
                  'url': 'https://spain.100montaditos.com/es/la-carta/', 
                  'vicinity': 'Calle San Jacinto, 89, 41010 Sevilla', 
                  'ref': 2999389465, 
                  'uploader': 'user1'})

#print(myGSheets.remove("ROWS",6,9))

# Always close at the end
myGSheets.close()

example01