capabilities.work

Append Rows and Format the Header

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

Recipe · 3 steps

Append Rows and Format the Header

with Google Sheets

Create a spreadsheet, append rows, and bold the header row.

  1. Create the spreadsheet and capture its generated spreadsheet ID.
  2. Append the header and data rows to the target range.
  3. Apply a repeatCell batchUpdate that sets bold text on the first row of the target sheet.
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 append rows to (e.g. Sheet1!A1).
  • values: A two-dimensional array whose first row is the header.
  • sheetId: The numeric ID of the sheet whose header row should be bolded (0 for the first sheet).
For your developer

Arazzo workflow google-sheets:append-and-format-header, 3 operations: createSpreadsheet → appendValues → batchUpdateSpreadsheet. Specs on APIs.io.

More recipes with Google Sheets

Archive 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 RowsRefresh a RangeSeed a Range Only If EmptyTag and Find a Spreadsheet With Developer Metadata