capabilities.work

Create, Write, and Verify

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

Recipe · 3 steps

Create, Write, and Verify

with Google Sheets

Create a spreadsheet, write values, and read them back to verify.

  1. Create the spreadsheet and capture its generated spreadsheet ID.
  2. Set the supplied values into the target range using USER_ENTERED interpretation.
  3. Read the written range back from the spreadsheet to confirm the values.
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.
  • range: The A1 notation range to write values to (e.g. Sheet1!A1:C3).
  • values: A two-dimensional array of cell values to write.
For your developer

Arazzo workflow google-sheets:create-write-and-verify, 3 operations: createSpreadsheet → updateValues → getValues. 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 WriteOverwrite or Append RowsRefresh a RangeSeed a Range Only If EmptyTag and Find a Spreadsheet With Developer Metadata