capabilities.work

Update and Read Values by Data Filter

A 3-step recipe with Google Sheets. We can help you get access.

Recipe · 3 steps

Update and Read Values by Data Filter

with Google Sheets

Update and read spreadsheet values selected by an A1 data filter.

  1. Confirm the spreadsheet and target range by reading it through a data filter before writing.
  2. Update the values of the filter-selected range using USER_ENTERED interpretation.
  3. Read the filter-selected range back to confirm the update landed.
What you'll need to have ready
  • accessToken: OAuth 2.0 bearer access token with the spreadsheets scope.
  • spreadsheetId: The ID of the spreadsheet to update.
  • a1Range: The A1 notation range used as the data filter (e.g. Sheet1!A1:C5).
  • values: A two-dimensional array of cell values to write to the filtered range.
For your developer

Arazzo workflow google-sheets:update-and-read-by-data-filter, 3 operations: getSpreadsheetByDataFilter → batchUpdateValuesByDataFilter → batchGetValuesByDataFilter. Specs on APIs.io.

More recipes with Google Sheets

Append Rows and Format the HeaderArchive and Clear Multiple RangesBulk Load Multiple RangesCopy a Sheet Between SpreadsheetsCreate and Seed a SpreadsheetCreate With an Extra Sheet and WriteCreate, Write, and VerifyOverwrite or Append RowsRefresh a RangeSeed a Range Only If Empty