Google sheets API, easy to use
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()