Gsheet V2.1

client.batch_update([ "range": "A2", "value": "=SUM(B2:B10)", "range": "B2", "value": 42, "range": "C2", "value": "Completed" ], atomic=True)