Python get/update rows

55 views
Skip to first unread message

Dima Ordenov

unread,
Jul 12, 2016, 10:59:01 AM7/12/16
to Google API Python Client
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?

Reply all
Reply to author
Forward
0 new messages