Finds and replaces data in cells
Finds and replaces data in cells over a sheet or column.
Google Sheets Action
Automating tasks with Google Sheets allows you to efficiently manage and update your spreadsheets. With Botize's integration, you can perform actions such as searching and replacing data in specific cells, facilitating the updating and maintenance of your documents without manual intervention.
This integration allows you to configure parameters such as the spreadsheet's URL, the value to search for, the replacement value, and the column in which to perform the search. Additionally, you can customize options like case sensitivity, exact text matching, and the inclusion of cells with formulas, tailoring the automation to your specific needs.
- Case sensitive and insensitive matching.
- Match the entire cell content or part of a cell.
- Include or skip cells with formulas.
Customization Options
Configurable fields you can adjust in your automation
- URL of your sheet document
- Value to search
- Value to use as the replacement
- Find and replace in column
- Find value should match the entire cell
- Search is case sensitive
- Include cells with formulas
- From sheet (selection method)
- Sheet Number
- Sheet name
Information provided
When executed, this operation delivers the following data, which can be used in the same automatic task.
Tags
- Total Cells changed {{cells_changed}}
Let's talk
Choose day and time.
We share the screen and answer all your questions.