capabilities.work

Bulk Load Multiple Ranges

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

Recipe · 3 steps

Bulk Load Multiple Ranges

with Google Sheets

Create a spreadsheet and bulk write and read multiple ranges.

  1. Create the spreadsheet and capture its generated spreadsheet ID.
  2. Write every supplied value range into the spreadsheet in a single batchUpdate using USER_ENTERED interpretation.
  3. Read all of the supplied ranges back from the spreadsheet in one batchGet.
What you'll need to have ready
  • accessToken: OAuth 2.0 bearer access token with the spreadsheets scope.
  • title: The title to give the newly created spreadsheet.
  • data: An array of ValueRange objects (each with range, majorDimension, and values) to write.
  • ranges: The A1 notation ranges to read back after writing.
For your developer

Arazzo workflow google-sheets:bulk-load-multiple-ranges, 3 operations: createSpreadsheet → batchUpdateValues → batchGetValues. Specs on APIs.io.

More recipes with Google Sheets

Append Rows and Format the HeaderArchive and Clear 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