Meteorite logoMeteorite
Back to videos

Video unavailable

This video can't be played right now.

How to Mail Merge in Google Docs Without an Add-on

To mail merge in Google Docs without an add-on, type your column headers into the letter in double curly braces ({{First name}}), then add a short Apps Script to the doc (Extensions → Apps Script). It reads your Google Sheet and writes one copy of the letter per row. Google Docs has no mail merge of its own: the built-in one lives in Gmail, sends emails rather than documents, and isn't offered on personal Google accounts. Get the script, ready to copy (YouTube won't allow some of its characters in a description): https://hablotech.com/tools/google-docs-mail-merge-script/?utm_source=youtube&utm_medium=video&utm_campaign=how-to-mail-merge-in The page writes it with your own sheet name and menu, can make one document per row instead, and checks your letter's placeholders against your headers before you run anything. The steps: 1. Write the letter. Wherever a value should change, type the column header in double curly braces. 2. Keep the data in a Google Sheet with the headers in row 1. The script finds the sheet by its name. 3. In the letter, open Extensions → Apps Script, paste the script over the starter code, and save. 4. Reload the letter. A new Mail merge menu appears at the end of the menu bar. 5. Click Mail merge → Create letters. A link to the new doc appears a few seconds later. The first run only: Google asks for permission and warns the app isn't verified — expected, because you wrote it. Click Review permissions, pick your account, then Advanced → Go to (your project) (unsafe), tick Select all, and Continue. Worth knowing: • Placeholders must match the header exactly, capitals and spaces included. A typo doesn't fail — it prints in braces in every letter. • A header containing ( ) $ . or similar needs the escaped version of the script; the page above adds it when you paste your headers. • A letter with a table or a bulleted list needs the version with three extra lines (also on the page). ⏱ Timestamps: 0:00 - Set up the letter 0:27 - Add the script 0:56 - Run the merge 1:22 - Open the letters 👍 If this helped, like the video and subscribe to Hablo Tech for more Google Docs tutorials!

Suggested videos