Use of formulas cell Version 5 (Net)

Action group: Google services

Description

The action uses formulas in a specified range in Google Sheets.

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextIndentifier of session for action.Robin.SpreadShee tsSpreadSheets contextYes
Document IDIndentifier of document for action.Robin.String
Yes
SheetName of working sheet. By default, the first sheet of the document.Robin.String
No
Start cellThe cell from which the formula will be applied. The format of the cell address is XY, where X is the column name, Y is the column index.Robin.String
Yes
End cellThe cell to which the formula will be applied. Format XY, where X is the column name, Y is the column index.Robin.String
Yes
FormulaFormula to use in range.Robin.String
Yes

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.

Example of use

Task

There is a table with values:

Connect to Google Sheets and use formula "А1"+"В1" in cell "С1".

Solution

Use the "Context Google tables", "Use of formulas cell" 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 "Use of formulas cell" action parameters.

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

Result

The program robot completed successfully.

The specified formula is used in cell "С1".