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.

Last updated