Find text (Google services)

Find text Version 8 (Net)

Action group: Google services

Description

The action returns the address of the cell containing the specified text.

Action icon

Settings of parameters

Property	Description	Type	Filling example	Mandatory field
Parameters
Context	Identifier of the session to which the action will be applied.	Robin.SpreadShee ts	SpreadSheets context	Yes
Document ID	Identifier of the document to apply the action to.	Robin.String		Yes
Sheet	Name of working sheet. By default, the first sheet of the document.	Robin.String		No
Start cell column	Column of the initial cell from which the search will be performed. By default, the boundaries of the used area from the context are applied.	Robin.String		No
Start cell row	Row of the initial cell from which the search will be performed. By default, the boundaries of the used area from the context are applied.	Robin.Numeric		No
End Cell column	Column of the end cell to which the search will be performed. By default, the boundaries of the used area from the context are applied.	Robin.String		No
End Cell row	Row of the destination cell to which the search will be performed. By default, the boundaries of the used area from the context are applied.	Robin.Numeric		No
Text	Text to be searched for.	Robin.String		Yes
Skip hidden	Hidden cells will not participate in the search.	Robin.Boolean	true	No
Search method	Search method. Full-text search will be applied by default.	Robin.String		No
Results
Result	Dictionary with elements - found cells: element key = cell address, element value = cell value.	Robin.Dictionary

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.

Example of use

Task

There is a table with values:

Connect to Google Sheets and find text "Test2".

Solution

Use the "Context Google tables", "Find Text", "Get value" actions.

Implementation

Assemble a robot scheme with the actions:
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).
Set the "Find text" action parameters.

In the ID field specify the part of the table's link.
Test the action by using the "Get value" action.
Click "Start" in the top panel to start the robot.