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

Input

spreadsheetId*

Spreadsheet ID

Spreadsheet ID (e.g., 1BxiMVs0X...)

valueInputOption

Value Input Option

RAW|USER_ENTERED

sheetId*

Sheet ID

Sheet ID (from gridRange.sheetId)

startRowIndex*

Start Row Index

0-based start row

endRowIndex*

End Row Index

0-based end row (exclusive)

startColumnIndex*

Start Column Index

0-based start column

endColumnIndex*

End Column Index

0-based end column (exclusive)

majorDimension

Major Dimension

ROWS|COLUMNS

includeValuesInResponse

Include Values In Response

true|false

responseValueRenderOption

Response Value Render Option

FORMATTED_VALUE|UNFORMATTED_VALUE|FORMULA

responseDateTimeRenderOption

Response DateTime Render Option

SERIAL_NUMBER|FORMATTED_STRING

value_row1_col1

Row 1 Column 1 Value

first cell value

Calls Google Sheets as you (your API key is your account); keychains.dev holds the credentials.