Check if the cell is empty Version 5 (Net)

Action group: Google services

Description

The action checks if the cell is empty.

Action icon


Settings of parameters 

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextIdentifier of the session to which the action will be applied.Robin.SpreadShee tsSpreadSheets contextYes
Document IDIdentifier of the document to apply the action to.Robin.String
Yes
SheetName of working sheet. By default, the first sheet of the document.Robin.String
No
Cell ColumnColumn of the cell in which the absence of values will be checked.Robin.String
Yes
Cell RowRow of the cell in which the absence of values will be checked.Robin.Numeric
Yes
Results
ResultVariable where the value from the cell will be written. If the cell is empty, then «True», else «False».Robin.Booleantrue

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:

 

Check if the "А3" cell is empty. 

Solution

Use the "Context Google tables", "Check if the cell is empty" 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 "Check if the cell is empty" 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 result is "False", which means that the cell is filled.