pip google sheet

1>>> sheet = spreadsheet.get_worksheet('tkZQWzwHEjKTWFFCAgw', 'od7')
2>>> rows = sheet.get_rows()
3>>> len(rows)
418
5>>> row_to_update = rows[0]
6>>> row_to_update['name'] = 'New Name'
7>>> sheet.update_row(row_to_update)
8{'name': 'New Name'...}
9>>> row_to_insert = rows[0]
10>>> row_to_insert['name'] = 'Another Name'
11>>> row = sheet.insert_row(row_to_insert)
12{'name': 'Another Name'...}
13>>> sheet.delete_row(row)
14>>> sheet.delete_all_rows()
15