Set Cell Style Activity
The Set Cell Style activity formats the style of a table cell within a Google Sheet. It modifies the cell's appearance to enhance text readability and visual presentation.
| Field | Description | Requirement |
|---|---|---|
| Google sheet name | The reference name of the Google Sheet that has already been opened or created, selected from a dropdown. | Required |
| Sheet name | The name of the page or tab within the spreadsheet. If not provided, the activity defaults to the first page. | Optional |
| Range | The specific range of cells whose style will be modified. | Optional |
| Fill color | The background color of the cell, specified as RGB values (e.g., "255,0,0") or a standard color name (e.g., "Red"). | Optional |
| Font color | The text color, specified as RGB values (e.g., "255,0,0") or a standard color name (e.g., "Red"). | Optional |
| Bold | A checkbox to apply or remove bold formatting to the font. | Optional |
| Italic | A checkbox to apply or remove italic formatting to the font. | Optional |
| Underline | A checkbox to apply or remove underline formatting to the font. | Optional |
| Font size | The desired font size, specified as a numerical value. | Optional |
| Font name | The desired font type, specified by its name (e.g., "Arial"). | Optional |
| Wrap text? | A boolean value to enable or disable text wrapping within the cell. Defaults to false. | Optional |
| Vertical alignment | The vertical alignment of content within the cells. | Optional |
| Horizontal alignment | The horizontal alignment of content within the cells. | Optional |
Action Types & Examples
Google Sheet Name
- Format:
string(variable reference) - Example Result:
newWord
Sheet Name
- Format:
string - Example Result:
Sheet1
Range
- Format:
string(cell reference) - Example Result:
A1:B5
Fill Color / Font Color
- Format:
string(RGB or named color) - Example Result:
255,0,0
Bold / Italic / Underline / Wrap Text?
- Format:
boolean - Example Result:
true
Font Size
- Format:
digit(integer) - Example Result:
9
Font Name
- Format:
string - Example Result:
Arial
Vertical Alignment
- Format:
string(enumeration) - Example Result:
CENTER
Horizontal Alignment
- Format:
string(enumeration) - Example Result:
LEFT
Implementation Examples
Field Setup - Google sheet name: ${newWord} - Sheet name: Sheet1 - Range: A1:B5
Execution Parameters - Fill color: 255,255,0 - Font color: 255,0,0 - Bold: true - Italic: false - Underline: true - Font size: 9 - Font name: Arial - Wrap text?: false - Vertical alignment: CENTER - Horizontal alignment: LEFT
Technical Notes
Color values can be specified as RGB triplets (e.g., "255,0,0") or standard color names (e.g., "Red"). Alignment options (Vertical and Horizontal) are case-sensitive and must match the predefined enumeration values. The
Rangeparameter accepts single cell references (e.g., "A1") or cell ranges (e.g., "A1:B5"). Boolean parameters (Bold,Italic,Underline,Wrap text?) accepttrueorfalse.