capabilities.work

Create With an Extra Sheet and Write

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

Recipe · 3 steps

Create With an Extra Sheet and Write

with Google Sheets

Create a spreadsheet, add a second sheet, and write values into it.

  1. Create the spreadsheet and capture its generated spreadsheet ID.
  2. Apply a batchUpdate with a single addSheet request that creates a second tab using the supplied title.
  3. Set the supplied values into the target range on the newly added sheet using USER_ENTERED interpretation.
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.
  • newSheetTitle: The title of the second sheet to add to the spreadsheet.
  • range: The A1 notation range to write values to (should reference the new sheet, e.g. NewTab!A1).
  • values: A two-dimensional array of cell values to write.
For your developer

Arazzo workflow google-sheets:create-with-extra-sheet-and-write, 3 operations: createSpreadsheet → batchUpdateSpreadsheet → 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, Write, and VerifyOverwrite or Append RowsRefresh a RangeSeed a Range Only If EmptyTag and Find a Spreadsheet With Developer Metadata