Batch update values by data filter
documentedSets values in one or more ranges of a spreadsheet using a data filter.
POST /v4/spreadsheets/{spreadsheetId}/values:batchUpdateByDataFilterSpreadsheetsno 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: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}}" \
}'"}