About
Find and Replace is a Google Sheets™ add-on that lets you batch process Google Docs™ by replacing placeholder text with values from your spreadsheet. Perfect for generating personalized letters, contracts, certificates, invoices, and more.
Select a folder containing your template documents, and the add-on will create copies with all placeholders replaced — saving you hours of manual work.
Features
- Batch processing — Process an entire folder of documents at once
- Visual folder picker — Select your source folder with Google's native picker interface
- Flexible placeholders — Use any text pattern as a placeholder (e.g., {{NAME}}, [DATE], %COMPANY%)
- Organized output — All edited copies are saved to a new folder
- Preserves originals — Your template documents are never modified
How It Works
Set up your spreadsheet
Create two columns: placeholders in column A (e.g., {{NAME}}) and replacement values in column B (e.g., John Smith).
Select your data
Highlight the cells containing your placeholder-value pairs.
Choose a folder
Use the folder picker to select the Google Drive™ folder containing your template documents.
Get your edited documents
The add-on creates copies of each document with all placeholders replaced, saved in a new folder.