Changing cell style Version 5 (Net)

Action group: Google services

Description

The action changes text style.

Action icon


Settings of parameters 

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextIndentifier of session for actionRobin.SpreadShee tsSpreadSheets contextYes
Document IDIndentifier of document for actionRobin.String
Yes
SheetName of working sheet. По умолчанию первый лист документа.Robin.String
No
From сellAddress of starting сell to apply style in format «XY», where «X» - column name and «Y» - row index.Robin.String
No
To cellAddress of last сell to apply style in format «XY», where «X» - column name and «Y» - row index.Robin.String
No
Font familyThe font family to set. Leaves the same by default.Robin.String
No
Font styleThe font style to set. Leaves the same by defaultRobin.String
No
Font sizeFont size to set. Leaves the same by defaultRobin.Numeric
No
ColorColor to set.Robin.String
Yes
Color codeCustom color hexadecimal code that will be applied if «Custom» was selected for «Color».Robin.String
No

Special conditions of use

The Google Sheets API has a limit of up to 60 read-requests per user per minute. To ensure that the action does not immediately generate an error when the limit on the number of requests is reached, the action includes a loop operation that will resend requests within a minute.

  • If the request is completed in that time, the action will complete successfully.
  • If the request cannot be sent in this time, the robot will terminate with an error.

The edited text must not have the "Default (Arial)" font.

If the font is set as "Default (Arial)", the text will not change in any way.

Example of use

Task

There is a Google spreadsheet:

Set the text style in the table with parameters:

  • font style - "italics",
  • size - "18",
  • color - "red".

Solution

Use the "Context Google tables", "Changing cell style" actions.

Implementation

  1. Assemble a robot scheme with the actions:
  2. Set the "Context Google tables" action parameters.

    Fill in the "The file path" and "Application name" fields (more about filling in these fields in section Instructions for setting up a connection to Google Sheets/Docs/Drive).
  3. Set the "Changing cell style" action parameters.

    In the ID field specify the part of the table's link.
  4. Click "Start" in the top panel to start the robot.

Result

The program robot completed successfully.

The text style is changed.

  • Нет меток