javascript - Sheets API formatting header - Stack Overflow

This operation does however have to be done after the first row has been appended, as otherwise the row will continue to copy the bolded formatting from the first line.

The order of requests should be as follows:

spreadsheets.batchUpdate request to make the first row bold
spreadsheets.values.append request to add the headers
spreadsheets.values.append request to add the first set of data
spreadsheets.batchUpdate request to update rows 2 and down so to not copy over the bold text formatting.