capabilities.work

Archive and Clear Multiple Ranges

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

Recipe · 3 steps

Archive and Clear Multiple Ranges

with Google Sheets

Snapshot several ranges, clear them all, and confirm they are empty.

  1. Read all of the supplied ranges together as an archive snapshot.
  2. Clear every supplied range in a single batchClear call.
  3. Re-read the ranges to confirm they no longer hold values.
What you'll need to have ready
  • accessToken: OAuth 2.0 bearer access token with the spreadsheets scope.
  • spreadsheetId: The ID of the spreadsheet whose ranges should be archived and cleared.
  • ranges: The A1 notation ranges to snapshot, clear, and re-check.
For your developer

Arazzo workflow google-sheets:archive-and-clear-multiple-ranges, 3 operations: batchGetValues → batchClearValues → batchGetValues. Specs on APIs.io.

More recipes with Google Sheets

Append Rows and Format the HeaderBulk 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 EmptyTag and Find a Spreadsheet With Developer Metadata