Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to format cells in a Google Sheet.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Format cells function applies formatting to a specified range of cells. You can set text style (bold, italic, font size, color), cell background color, number format, borders, and alignment.
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Connector | Yes | Select | - | Select the Google Workspace connector to use |
| Spreadsheet ID | Yes | Text | - | Google Sheets spreadsheet ID |
| Sheet ID | Yes | Text | - | Numeric sheet ID |
| Range | Yes | Text | - | A1 notation range to format (e.g. A1:D1) |
| Format | Yes | Text | - | JSON object describing the cell format (bold, italic, fontSize, backgroundColor, numberFormat, etc.) |
Errors
- Invalid format – the format JSON is malformed
- Sheet not found – no sheet exists with the given ID
Tips
- Colors use RGB values between 0 and 1, e.g. {"red":1,"green":0,"blue":0} for red
- Combine with Batch update spreadsheet for complex formatting in a single call
Related functions
- Merge cells – Merge a range of cells
- Batch update spreadsheet – Apply multiple format changes at once