Sign in

Batch update values

documented

Sets values in one or more ranges of a spreadsheet.

POST /v4/spreadsheets/{spreadsheetId}/values:batchUpdateSpreadsheetsno implementation yet0 runs
No implementation yet. Run it to have the agent write one, or open a pull request with your own.

Seed example (keychains curl)

npx -y keychains@latest curl "https://sheets.googleapis.com/v4/spreadsheets/{{$spreadsheetId}}/values:batchUpdate" \
  -X POST \
  -H "Authorization: Bearer {{OAUTH2_ACCESS_TOKEN}}" \
  -H "Content-Type: application/json" \
  -H "Accept: application/json" \
  -d '{"valueInputOption": "RAW", "data": [ { "range": "{{$range}}", "majorDimension": "ROWS", "values": [ {{$val_row1}}, {{$val_row2}} ] } ], "includeValuesInResponse": true, "responseValueRenderOption": "FORMATTED_VALUE", "responseDateTimeRenderOption": "SERIAL_NUMBER" }'