Hello!
I've read documentation of Google Sheet API for Python and got how to work with get() method and its working well:
spreadsheetId = spreadID
rangeName = 'Sheet1!A2:G'
result = service.spreadsheets().values().get(spreadsheetId=spreadID, range=rangeName).execute()
But how I can make update for this spreadsheet? I can't uderstand how I should use update():
service.spreadsheets().values().update(spreadsheetId=spreadsheetId, range=rangeName,body=request).execute()
Is this one right? What body should represent here? For example, I want to write 'yes' in G2, how I should do this?