How to Bold the Header Row of a Google Sheet?

Question

Hi! I’m using Zapier to (1) create a spreadsheet from a template then (2) append rows into that spreadsheet from Airtable.

I’m trying to have just the header row be bold, but am having trouble. This is what I’ve tried:

(a) I made the header row bold in my template, so when it gets copied it is bold. However, when I’m appending new rows, those all end up being bolded as well.

(b) I then tried “Format Spreadsheet Row” after the rows are added, but I’m unable to format multiple rows at a time. I wanted to use the looping feature to feed in all of the row numbers, but I’m unable to use that because because I’m already using the looping feature to feed in the data from Airtable into sheets. The system won’t let me have 2 loops.

Would love your help on this!

Hello123 · Accepted Answer

Thanks!! I finally managed to do it with some help from ChatGPT. If it’s helpful to anyone, here are the steps:

Added a Google Sheets step
Chose the “API Requests” option
Set HTTP Method: Post
Set URL to this (update with your own ID) https://sheets.googleapis.com/v4/spreadsheets/$SPREADSHEET_ID$:batchUpdate
And set this as the body of the request

{
  "requests": [
    {
      "repeatCell": {
        "range": {
          "startRowIndex": 0,
          "endRowIndex": 1,
          "startColumnIndex": 0,
          "sheetId": 0 
        },
        "cell": {
          "userEnteredFormat": {
            "textFormat": {
              "bold": true
            }
          }
        },
        "fields": "userEnteredFormat.textFormat.bold"
      }
    }
  ]
}

Then it worked like a charm! Woot

SamB · Answer

That’s fantastic,@Hello123! Great work on utilising ChatGPT to help get that API Request action working! 🙌And thank you so muchfor sharing the solutionwith the Community here, it’s much appreciated!🤗

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded