capabilities.work

Refresh a Range

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

Recipe · 3 steps

Refresh a Range

with Google Sheets

Snapshot, clear, and rewrite the values of a single range.

  1. Read the current values of the range so the caller has a before snapshot.
  2. Clear the range so the subsequent write starts from a clean range.
  3. Write the fresh block of values into the now-cleared range.
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 refresh.
  • range: The A1 notation range to snapshot, clear, and rewrite.
  • values: A two-dimensional array of fresh cell values to write.
For your developer

Arazzo workflow google-sheets:refresh-range, 3 operations: getValues → clearValues → updateValues. 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 RowsSeed a Range Only If EmptyTag and Find a Spreadsheet With Developer Metadata