Batch update values
documentedSets values in one or more ranges of a spreadsheet.
POST /v4/spreadsheets/{spreadsheetId}/values:batchUpdateSpreadsheetsno implementation yet0 runsNo 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" }'