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

• Credential: Object Variable A variable name that references the user credential to access the resources.

• SpreadSheet Id: String Argument The Id of the spreadsheet in which cell value is to be searched.

• Sheet Name: String Argument The name of the sheet in which the value is to be searched.Set this property only when the Search type is Sheet.

• Range: String Argument The range of the sheet in which the value is to be searched.Set this property only when the Search type is Range.

• Search Value: String Argument The cell value is to be searched. Search value is a regex if Search By Regex property is true.

• Replace Value: String Argument The cell value is to be replaced.

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.