PickMerge turns each row of a sheet, or each new Google Forms™ response, into its own Google Docs™ file or PDF, built from a template you design in Google Docs™. Invoices, certificates, offer letters, receipts, reports, permission slips: if you can lay it out in a Doc, PickMerge can fill it in.
HOW IT WORKS
1. Write a Google Docs™ file with placeholders that match your column headers, like {{Client}} and {{Amount}}. Or click "Make one from my columns" and PickMerge writes a starter template for you.
2. Open Extensions > PickMerge and pick the template.
3. Press Check and preview to see exactly what will be created. Then press Generate.
Each row gets its own file in a PickMerge folder in your Google Drive™, and a link plus a status appear in new columns at the right of your sheet.
WHY PEOPLE SWITCH TO PICKMERGE
- It opens only the files you pick. Most document merge add-ons ask to "see, edit, create and delete all of your Google Drive™ files". PickMerge uses Google's file picker, so it can open the template you choose and the files it creates, and nothing else in your Google Drive™.
- Your formatting stays put. PickMerge copies your template and replaces the placeholders in place, so fonts, colors, tables, headers, footers, images and document tabs stay as you designed them. Dates and currency appear the way your sheet shows them.
- You see problems before anything runs. Preview flags placeholders that don't match a column (with "did you mean" suggestions), missing email addresses and empty headers. Preview never uses trial documents.
- Running it twice won't make duplicates. Rows marked Done are skipped unless you choose Regenerate. Big sheets run in batches with a progress bar and pick up where they left off.
- Errors in plain words. If a row fails, its status cell says why, so nobody has to guess what "Exception: undefined" meant.
- A person answers. Email hello@greatwork.company and you get a reply within 1 business day.
EVERYTHING IT DOES
- Google Docs™ file, PDF, or both, for every row
- File names from your columns, for example "Invoice {{Invoice #}} {{Client}}"
- Only rows that match a filter (for example Send? equals Yes), or a row range like 2-50
- Placeholder fallbacks for empty cells: {{Nickname|there}}
- Built-in values: {{_row}}, {{_today}}, {{_sheet}}, {{_spreadsheet}}
- Word templates (.docx): PickMerge makes a Google Docs™ copy and leaves your file untouched
- Output to the Google Drive™ folder you choose, or let PickMerge create one
- Optional email: send each PDF to the address in the row, with your subject and message (placeholders work there too). You see every recipient and must confirm before anything is sent.
- Automatic mode for Google Forms™: each new response gets its document within about a minute. Turn it off with one click.
- Sample data: one click adds a sample tab and template so you can see a full run in under a minute.
PRICING
- Free trial: 50 documents or 14 days, whichever comes first. No card needed to start.
- After the trial: $99 per year or $8.99 per month for unlimited documents. Prices are in US dollars; sales tax or VAT may be added where required.
- Nothing is charged unless you choose a plan. Your remaining trial is always shown at the top of the sidebar.
- Subscriptions renew automatically at the end of each month or year until you cancel. Cancel any time in one step from Extensions > PickMerge > Upgrade or manage billing; you keep access until the end of the period you paid for.
- UK and EU consumers can cancel within 14 days of purchase for a full refund. Email hello@greatwork.company.
PERMISSIONS, IN PLAIN WORDS
- This spreadsheet: read your rows and write links and status in new columns.
- Google Drive™ files you pick or PickMerge creates: open your template, save documents. No access to your other files.
- Send email as you: only for the emails you set up and confirm. Untick it if you don't need email.
- Run when you're not present: only for Automatic mode with Google Forms™.
- Your email address: to look up your license.
PickMerge doesn't store your documents or spreadsheet data on our servers. Merges run inside Google™. Our license server only sees your email address and how many documents you've made.
GET STARTED
Open your sheet, then Extensions > PickMerge, and pick a template (or try it with sample data first).
Made by Great Work, a small software company. Questions go to hello@greatwork.company and a person replies within one business day. (We're the ones with the duck.) Website: https://addons.greatwork.company/sheets-doc-merge
Great Work LLC, 651 N Broad St Suite 206, Middletown, DE 19709, USA.
Google™, Google Sheets™, Google Docs™, Google Forms™ and Google Drive™ are trademarks of Google LLC. PickMerge is not affiliated with or endorsed by Google.