Skip to main content
Docs
Go to the Studio
Roberty Studio
RPAGoogle Sheets

Find and replace

Find and replace

Finds and replaces a text in a spreadsheet, tab or 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.

Find​

Enter the text to find.

Replace with​

Enter the text that will replace the occurrences found.

Tab name or ID (optional)​

Leave it empty to search the whole spreadsheet. Enter the tab name (e.g. Página1) or, using the number type, the numeric ID of the tab.

Advanced options​

Range fields (optional — default: the whole tab) and the advanced search settings.

Start row​

Optional. Enter the start row of the search range (1 = first row). It only takes effect when Tab name or ID is also given.

Last row​

Optional. Enter the last row of the search range. It only takes effect when Tab name or ID is also given.

Start column​

Optional. Enter the start column of the search range (1 = first column). It only takes effect when Tab name or ID is also given.

Last column​

Optional. Enter the last column of the search range. It only takes effect when Tab name or ID is also given.

Match case​

When enabled, the search distinguishes upper from lower case. Default: disabled.

Match the entire cell content​

When enabled, the replacement only happens when the entire cell content equals the searched text. Default: disabled.

Search using a regular expression​

When enabled, the Find field is read as a regular expression. Default: disabled.

Search inside formulas too​

When enabled, the search also covers the text of the cell formulas, besides the displayed values. Default: disabled.

Returns​

Javascript code​

js
actions["action-id"].valuesChanged // number of values changed (Number)
actions["action-id"].formulasChanged // number of formulas changed (Number)
actions["action-id"].rowsChanged // number of rows changed (Number)
actions["action-id"].sheetsChanged // number of tabs changed (Number)
actions["action-id"].occurrencesChanged // number of occurrences changed (Number)

Field selection​

  • valuesChanged — Number of values changed.
  • formulasChanged — Number of formulas changed.
  • rowsChanged — Number of rows changed.
  • sheetsChanged — Number of tabs changed.
  • occurrencesChanged — Number of occurrences changed.

Rules and Conditions​

  • The Google Sheets connection, Spreadsheet ID, Find and Replace with fields are required.
  • When Tab name or ID is not given, the find and replace runs on the whole spreadsheet (every tab).
  • When Tab name or ID is given and no range field (row/column) is filled in, the search runs on the whole selected tab.
  • The range fields (start/last row/column) only take effect when Tab name or ID is also given; if the tab is left empty, the range fields are ignored and the search runs on the whole spreadsheet.
  • If the Last row is lower than the Start row, or the Last column is lower than the Start column, the robot stops the run with an error.
  • If the given tab is not found in the spreadsheet, the robot stops with an error.
  • Row and column positions are given 1-based (1 = first row/column).