The Scenario
Your marketing team raised prices last month. Across the past year, you sent 30 client proposals — all built from the same Google Doc template, all with the old pricing language. Some of those clients are still in active conversations. Your VP just flagged it: if any of them pull up an old proposal link and see the outdated rates, it's a problem. The tracking sheet has all 30 doc IDs in column A, the old price text in column B, and the updated text in column C. She wants them fixed before the team sync tomorrow morning.
The bad version:
- Open doc 1. Go to Edit > Find & Replace. Type the old text from column B, row 2. Type the replacement from column C, row 2. Click Replace All. Check that it worked. Close. Back to the sheet. Row 3.
- Thirty docs. Thirty Find & Replace operations. Some of the old text appears in multiple places in each doc — an intro paragraph and again in the pricing table. Make sure Replace All caught both instances.
- On doc 19, the old price text in column B has a stray space that doesn't match what's in the actual doc. Replace All finds zero matches. You have to open the doc, manually read the text, figure out the discrepancy, fix it by hand.
Thirty docs is the kind of task that sounds like twenty minutes until you're ninety minutes in and on doc 22.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your data and talks to Google Docs directly — it can open each doc, replace all occurrences of the old text with the new text, and confirm the update without you touching a single document.
Open the SheetXAI sidebar and paste this prompt:
For each row in the Proposals tab with a Doc ID in column A, old text in column B, and new text in column C, open that Google Doc and replace all occurrences of the old text with the new text. Write "Updated" or the error message to column D.
What You Get
- Each Google Doc in column A opened and updated with the replacement text from column C.
- All occurrences of the old text in column B replaced throughout the document — not just the first match.
- Column D populated with "Updated" for successful replacements, or a specific error message if the doc couldn't be accessed or the text wasn't found.
- Any doc where zero matches are found gets flagged in column D so you can investigate rather than silently pass.
What If the Data Is Not Quite Ready
The old price text in column B has inconsistent spacing or punctuation compared to what's actually in the docs
Before replacing, normalize the search text in column B: trim whitespace, normalize smart quotes to straight quotes, and collapse double spaces. Then open each doc in column A and replace all occurrences of the normalized text with the value from column C. Write the result to column D.
Some docs need two separate replacements — pricing language in column B/C and a footer disclaimer in columns E/F
For each row in Proposals, open the Google Doc in column A and perform two replacements: replace column B text with column C text, and replace column E text with column F text. Write "Updated" or an error to column G.
Some doc IDs in column A are actually full Google Doc URLs, not bare IDs
Before opening the docs, extract the document ID from any value in column A that looks like a full URL (take the ID segment between "/d/" and "/edit"). Then replace all occurrences of column B text with column C text in each doc. Write the result to column D.
Normalize the search text, extract IDs from URLs, skip rows where column D already says "Updated," perform both pricing and disclaimer replacements, and log the results — all in one run
In the Proposals tab, skip any row where column D already says "Updated." Extract doc IDs from full URLs in column A where needed. Normalize whitespace and quote characters in columns B and E. For each remaining row, open the doc and replace column B text with column C, and column E text with column F. Write "Updated" or the specific error to column D.
Batching the normalization, the dedup check, and both replacements into one prompt means every doc is correct after a single run — no second pass required.
Try It
Get the 7-day free trial of SheetXAI and open your proposal tracking sheet, then ask it to update all 30 docs with the new pricing language before your morning sync. For related tasks, see how to mail-merge a template into fresh doc copies or browse the Google Docs integration hub.