The Scenario
You manage 15 client accounts and at the end of Q1 you updated your pricing model. Every client has their own Google Slides deck with last quarter's revenue figures embedded in it — the deck ID and the old and new figures are all sitting in an Excel workbook 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. 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 workbook, 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 matched a figure in the footer that wasn't supposed to change, undo, re-do it more carefully
- Realize at deck 11 that you've been referencing 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 Excel workbook. It reads the presentation IDs and replacement pairs from your workbook and, through its Google Slides integration, applies a batch text replacement to each deck — in one request, without you opening a single presentation.
Update the revenue figures in 15 client slide decks using the presentation ID, old value, and new value from each row of my Excel sheet by applying a replaceAllText batch update to each deck
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 Excel workbook, 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 modify anything.
For each row in my Excel workbook, 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 Excel workbook, 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 workbook in Excel 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.