Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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!

Hi @Hello123 

You would have to use the GSheets API via one of these GSheets Zap actions:

  • Custom Action
  • API Request

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

{
  "requests": e
    {
      "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

That’s fantastic, @Hello123! Great work on utilising ChatGPT to help get that API Request action working! 🙌

And thank you so much for sharing the solution with the Community here, it’s much appreciated! 🤗 

Terms & Conditions