Google Sheets add-on

Sheet rows into Docs and PDFs, and you find out when one fails.

You write a Google Doc with placeholders like {{Name}}, point it at a sheet or a Form's responses, and MergeWorks makes one Doc or PDF per row. It can email each one too.

See how it works Free for 25 a month

Certificates (Form responses)

	Name	Course	MW Status	MW Error
2	Ana Ruiz	CPR Level 1	Done
3	Ben Cole	CPR Level 1	Done
4	Kim Lau	First Aid	Error	Not an email: kim@exmaple
5	Raj Patel	First Aid	Pending

MergeWorks: 1 row failed Row 4 (Kim Lau) wasn't sent. The email address looks mistyped. Fix it and use Retry rows with errors. to: you · 9:14 AM

Why this exists

The merge part isn't new. The failure part is.

A lot of add-ons merge rows into documents. What I cared about is what happens when something goes wrong. With most of them, when a form trigger stops working, nothing tells you. You find out a week later when someone asks where their certificate is. Google doesn't email anyone when an add-on's trigger fails, so unless the add-on does it, nobody knows.

MergeWorks writes a status on every row, keeps a run log, retries the errors that are worth retrying, and emails you when a row fails. That's the whole pitch.

How it works

Four steps, then it runs on its own.

Install it from the Google Workspace Marketplace and open it from Extensions > MergeWorks.
Paste the link to your template Doc. It finds the placeholders and matches them to columns with the same name. You can change any match.
Pick PDF, Doc or both, a file name like {{Name}} - {{Course}}, and optionally an email with the PDF attached.
Press Run for the rows you already have, and turn on "Run when a form response comes in" for new ones.

Rows marked Done are skipped, so running it twice doesn't make duplicates. To redo a row, clear its status. Files go into a "MergeWorks output" folder in your Drive.

Limits

What it doesn't do

It can't send from an alias or a shared mailbox. Emails go out from your own account.
It can't look around your Drive. It only sees the template you point it at and the files it makes.
Templates have to be Google Docs. Not Slides, not Word files.
Output goes to its own folder for now. You can move or share that folder. Choosing any folder is next on the list.
It copies the body, header and footer of your template. A table of contents doesn't come across, and very fancy layouts can shift a bit. Run one row first and look at it.
Google limits how much email an add-on can send for you: about 100 a day on a gmail.com account, 1,500 on Workspace. When you hit it, the rest wait in the queue and go out later, and the sheet says so.

Pricing

Free until it's doing real work for you.

Free

25 merges a month. Everything works, including email and form triggers.

Pro

$8 / month

or $69 a year. No monthly limit. Pay with the same email as your Google account, then click "I paid, check again" in the sidebar.

Monthly Yearly

A merge is one row turned into its files (Doc, PDF or both) and its email. Cancel any time from your billing page; you keep Pro until the end of the period you paid for. Payments go through Stripe.

Permissions, and why

What it can touch, in plain words.

No restricted scopes

When you install it, Google shows a list of what the add-on can do. Here's each one. None of them are Google's "restricted" kind, the ones that reach your whole Drive or read your email.

See and edit the spreadsheet you open it in: To read your rows and write the status columns and the run log. Only that one spreadsheet.
See and edit your Google Docs: To read the template you paste in and fill in the copies it makes. It doesn't open any Doc you haven't pointed it at.
See and edit only the Drive files MergeWorks creates: The output folder and the Docs and PDFs in it. The rest of your Drive is invisible to it.
Send email as you: Only if you turn on emailing, plus a short note to you when something fails. It can send, it can't read.
Run when you're not there: For the form-submit trigger, and an hourly pickup of rows that were waiting.
Connect to an external service, and see your email address: One call to our license server with your email address, to check if you have Pro. Nothing else is sent. Details in the privacy policy.

Support

A person answers.

Email hello@lemnosholdings.com. I read these myself. If a row failed, the text from the MW Error column or the Run log line is usually enough, no need to share the sheet.

If something fails, first look at the "Run log" sheet. Most errors are a column that was renamed, an email address with a typo, or a template link you no longer have access to. Fix it, then Extensions > MergeWorks > Retry rows with errors.