Sign in

Batch update values by data filter

documented

Sets values in one or more ranges of a spreadsheet using a data filter.

POST /v4/spreadsheets/{spreadsheetId}/values:batchUpdateByDataFilterSpreadsheetsno 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:batchUpdateByDataFilter" \
  -X POST \
  -H "Authorization: Bearer {{OAUTH2_ACCESS_TOKEN}}" \
  -H "Content-Type: application/json" \
  -H "Accept: application/json" \
  -d '{ \
  "valueInputOption": "{{$valueInputOption}}", \
  "data": [ \
    { \
      "dataFilter": { \
        "gridRange": { \
          "sheetId": {{$sheetId}}, \
          "startRowIndex": {{$startRowIndex}}, \
          "endRowIndex": {{$endRowIndex}}, \
          "startColumnIndex": {{$startColumnIndex}}, \
          "endColumnIndex": {{$endColumnIndex}} \
        } \
      }, \
      "majorDimension": "{{$majorDimension}}", \
      "values": [ ["{{$value_row1_col1}}", "{{$value_row1_col2}}", "{{$value_row1_col3}}"] ] \
    } \
  ], \
  "includeValuesInResponse": {{$includeValuesInResponse}}, \
  "responseValueRenderOption": "{{$responseValueRenderOption}}", \
  "responseDateTimeRenderOption": "{{$responseDateTimeRenderOption}}" \
}'"}
Batch update values by data filter · Google Sheets · OpenIntegrations