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.