Find and replace in Google Sheets automatically

What it does

This automation runs on a schedule (hourly, daily, or weekly) and performs a find-and-replace across the sheet — for example normalizing N/A to a blank, fixing a recurring typo, or renaming an old product label wherever it appears. Pair it with imports, form feeds, or integrations that keep writing the same inconsistencies.

How to set it up

1. Install Sheet Automation from the Google Workspace Marketplace and open it from your sheet.
2. Pick the “Scheduled find and replace” template.
3. Enter the text to find and its replacement, and choose how often to run.
4. Save. The cleanup runs automatically on schedule from then on.

The ready-made template

Scheduled find and replace — Trigger: the sheet is scheduled daily → Action: replace every N/A with a blank. Edit it live below:

How to use this template

The builder above is a live preview of this automation. To run it in your own spreadsheet:

1. Click Add to Google Sheets to install Sheet Automation (free).
2. Open it from your sheet: Extensions → Sheet Automation → Open.
3. Open the Templates tab and choose “Scheduled find and replace”.
4. Adjust the fields to match your data, then click Save.
5. Trigger it once to confirm the automation runs.

Related automations