Find And Replace Cells
Find and replace the cell value in google sheet.
Search the specified cell value or regex in a google spreadsheet and replaced it with replace value.
This activity can only be used after the Create GSuite Connection Activity
Input
Options
Search Type: The type of search.
AllSheets
- Search all the sheets of a google spreadsheet.Sheet
- Search specified sheet of google spreadsheet.Range
- Search the specified range of sheets in a google spreadsheet.
Search By Regex:
Boolean Argument
True
- Search value is a regex.False
- Search value is not a regex.
Include Formula:
Boolean Argument
True
- Search should include cells with formulas.False
- Search does not include cells with formulas.
Match Entire Cell:
Boolean Argument
True
- find value should match the entire cell.False
- find value does not match the entire cell.
Search Case:
Boolean Argument
True
- Search is case sensitive.False
- Search is not case sensitive.
Last updated