How do I format text in Google Sheets using Workflow?

Workflows
,
1

Hello,

I'm trying to modify text in order to create a report in Google Sheets. So far, I've been able to populate data. Now, I need to format it to our company's reporting standards such as font, font size, and so on. How would I do this?

2

Hey @Derek_Park,

Here's what chatGPT replied to me:

POST /v4/spreadsheets/{spreadsheetId}:batchUpdate HTTP/1.1
Host: sheets.googleapis.com
Content-Type: application/json
Authorization: Bearer [YOUR_ACCESS_TOKEN]

{
  "requests": [
    {
      "repeatCell": {
        "range": {
          "sheetId": 0,
          "startRowIndex": 0,
          "endRowIndex": 1,
          "startColumnIndex": 0,
          "endColumnIndex": 1
        },
        "cell": {
          "userEnteredFormat": {
            "textFormat": {
              "foregroundColor": {
                "red": 1.0,
                "green": 0.0,
                "blue": 0.0
              },
              "fontSize": 12,
              "bold": true
            }
          }
        },
        "fields": "userEnteredFormat.textFormat"
      }
    }
  ]
}

This is a simple update of the A1:B2 cells to bold texts, font size of 12, and a red coloured font. You can read more on the docus here. Wishing you luck on this endeavour! :four_leaf_clover: