Format Cells in Google Sheet
Apply formatting to cells (bold, italic, background color).
Plan availability #
| Feature | Free | Starter | Pro | Enterprise |
|---|---|---|---|---|
| Active workflows | 3 | 10 | 45 | Unlimited |
Allowances follow the published Chatigram pricing page. Your organization’s Billing & Plans screen confirms its subscription and current usage. Plans can change. Plan information reviewed 2026-11-10.
When to use this node #
Apply formatting to cells (bold, italic, background color).
Add Format Cells in Google Sheet to a workflow branch using the node picker. Configure its fields in the inspector, then connect the next step.
Before you begin #
Connect Google Workspace in App Connections first. Select the intended account in this node; an account connected to a different service is not interchangeable. Available actions depend on the permissions granted to that connection.
Configure the fields #
| Field | What to enter |
|---|---|
| Google Account | Returned from integration |
| Spreadsheet ID | ID from spreadsheet URL or createSpreadsheet output |
| Sheet ID (Optional) | Sheet ID from getInfo output (default: 0 = first sheet) Example/default shown in the editor: 0. |
| Start Row Index (Optional) | Starting row, 0-based (0=first row, 1=second row) Example/default shown in the editor: 0. |
| End Row Index (Optional) | Ending row, exclusive (1=format first row only, 2=format rows 0-1) Example/default shown in the editor: 1. |
| Start Column Index (Optional) | Starting column, 0-based (0=A, 1=B, 2=C) Example/default shown in the editor: 0. |
| End Column Index (Optional) | Ending column, exclusive (3=format A-C, 5=format A-E) Example/default shown in the editor: 1. |
| Bold (Optional) | Set to 'true' to make text bold |
| Italic (Optional) | Set to 'true' to make text italic |
| Background Color (Optional) | RGB values 0-1: '1,1,0' (yellow), '1,0,0' (red), '0,1,0' (green), '0,0,1' (blue) |
Use the result #
Choose the output from the variable picker in a later step. Output names below identify the values supplied by this node; the picker inserts the correct reference for your node instance.
| Output | Meaning / label |
|---|---|
spreadsheetId |
Spreadsheet ID |
sheetId |
Sheet ID |
formattedRange |
Formatted Range |
success |
Success |
appliedFormats |
Applied Formats |
Connect the next step #
Connect the continuation shown on the canvas. Some nodes calculate their branches from the configured options. Read each branch label in the editor and connect the paths your workflow needs.
Test it in a workflow #
- Configure this node with a small, recognizable test input or a test resource.
- Check the variables from preceding steps and the connection selected in the inspector.
- Save the workflow. For event-driven flows, generate the actual event; use Run only for a Manual workflow.
- Open Workflow Activity and check the outcome before enabling wider use.
If something goes wrong #
- Reconnect the account if authorization has expired, then verify its permissions on the specific resource.
- Check empty variables, selected resource IDs, and any fields that appeared after resource selection.
- Check the failed step in Workflow Activity before retrying. If the action may already have completed, inspect the destination first to avoid duplicates.
- Follow the troubleshooting guide for a symptom-by-symptom checklist.
Related guides #
- Work with variables
- Understand branches and error handling
- Browse all nodes
- Add Sheet to Spreadsheet
- Append Data to Google Sheet
- Clear Range in Google Sheet
- Create Folder in Google Drive
- Create Google Calendar Event
Catalog coverage #
This is the currently documented selection. Chatigram continues to add nodes, triggers, App Connections, and integrations. Use each page’s review date and the current application selectors to check what is available now; this catalog is not a fixed limit on future features.