The Scenario
You manage 15 client accounts and at the end of Q1 you updated your pricing model. Every client has their own slide deck with last quarter's revenue figures embedded in it — the deck ID and the old and new figures are all sitting in a Google Sheet you maintain. Your job today is to get the right number into every deck before the account team sends them out at noon.
Your instinct is to open each deck, use Find & Replace, type the old number, type the new one, confirm, close, next deck. You've done it before. You'll do it again. It takes about 25 minutes for 15 decks if nothing goes wrong.
The bad version:
- Open deck 1, press Ctrl+H, type the old revenue figure, type the new one, replace all, close
- Open deck 2 from the sheet, notice it uses a slightly different format ("$1.2M" instead of "$1,200,000"), realize your replacement string won't match
- Fix the format mismatch manually, close
- On deck 6, find that the replacement replaced a figure in the footer that wasn't supposed to change, undo, re-do it with more precision
- Realize at deck 11 that you've been replacing the wrong column — column C was the new value, but you've been typing from column B for the past five decks
Fifteen decks. One column-reference error you didn't catch until deck 11. Now you're not sure which five decks have the wrong number.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the presentation IDs and replacement pairs from your sheet and, through its Google Slides integration, applies a batch text replacement to each deck — in one request, without you opening a single presentation.
For each row in my sheet with a presentation ID in column A, old revenue figure in column B, and new revenue figure in column C, open that presentation and replace all occurrences of the old text with the new text
What You Get
- Each of the 15 decks updated with the correct replacement applied
- Replacements scoped to the exact string in column B — no unintended matches in footers or unrelated text boxes
- A confirmation note in column D for each row indicating whether the replacement succeeded or whether the old string wasn't found in that deck
- No presentation windows opened, no manual Find & Replace cycles
What If the Data Is Not Quite Ready
The old figures are formatted differently across decks
Some decks show "$1.2M," others show "$1,200,000," others show "1.2M" without the dollar sign. Your column B only has one version.
For each row in my sheet, open the presentation in column A and replace any occurrence of the old value from column B — including common formatting variants like adding or removing "$", "M" notation, or comma separators — with the new value from column C
Some decks have the old figure in the speaker notes, not the main slide body
The replacement needs to cover notes too, not just visible slide text.
For each row, open the presentation from column A and apply a replaceAllText batch update that covers both slide body text and speaker notes, replacing column B with column C
You want to do a dry run before committing the replacements
You'd like to see which decks contain the old string before you actually modify anything.
For each row in my sheet, open the presentation in column A and check whether the text in column B appears anywhere in the deck. Write "Found" or "Not found" to column D without making any replacements yet.
Kill chain: audit matches, normalize formats, apply replacements, and log results
For each row in my sheet, first check whether the old value from column B (or any formatting variant of it) appears in the presentation from column A, and write the result to column D. For rows where it was found, apply the replacement with the new value from column C and write "Updated" to column E. For rows where it wasn't found, write "Check manually" to column E.
One prompt does the pre-check and the update in sequence, so you know exactly what changed and what needs a human look.
Try It
Open your deck-tracking sheet with presentation IDs in column A and replacement pairs in columns B and C, then get the 7-day free trial of SheetXAI and run the batch update in one request. Related workflows: generating new decks from a template per row or the Google Slides overview.