Skip to main content
Go to the Studio
Google Sheets

Style cells

Style cells

Sets the background/text color, bold, italic, alignment and border of a cell range.


Options​

Google Sheets connection​

Select the Connection action set up in the flow.

Spreadsheet ID​

Enter the ID of the spreadsheet. The ID can be found in the spreadsheet URL: docs.google.com/spreadsheets/d/{spreadsheetId}/edit.

Tab name or ID​

Enter the tab name (e.g. Página1) or, using the number type, the numeric ID of the tab.

Set a background color​

Option to select Yes or No to apply a background color to the cell range. When enabled, pick the desired color in the color picker.

Set a text color​

Option to select Yes or No to apply a color to the text of the cell range. When enabled, pick the desired color in the color picker.

Bold​

Option to select Yes or No to apply bold to the range's text.

Italic​

Option to select Yes or No to apply italic to the range's text.

Font size​

Enter the font size to apply to the range's text (optional).

Horizontal alignment​

Select the horizontal alignment of the cell content: Left, Center or Right. Leave it blank to keep the current alignment.

Vertical alignment​

Select the vertical alignment of the cell content: Top, Middle or Bottom. Leave it blank to keep the current alignment.

Set a border​

Option to select Yes or No to apply a border around the cell range.

Border style​

Select the border style: SOLID, SOLID_MEDIUM, SOLID_THICK, DASHED, DOTTED or DOUBLE. When not given, the default SOLID is used.

Border color​

Option to select Yes or No to set a color for the border. When enabled, pick the desired color in the color picker.

Advanced options​

Start row​

Enter the number of the first row of the range (optional).

Last row​

Enter the number of the last row of the range (optional, included in the range).

Start column​

Enter the number of the first column of the range (optional, 1 matches column A).

Last column​

Enter the number of the last column of the range (optional, included in the range).

Returns​

This action has no returns.

Rules and Conditions​

  • The Google Sheets connection, Spreadsheet ID and Tab name or ID fields are required.
  • At least one style option (background color, text color, bold, italic, font size, horizontal/vertical alignment or border) must be set; otherwise the robot stops with an error.
  • When Start row, Last row, Start column and Last column are not given, the style is applied to the whole tab.
  • If a border is set with no specific style, the default SOLID is used.