Merge Google Sheets and Forms into Docs and PDFs, reliably.
TrustyMerge turns each row of a Google Sheet or each Google Form response into a Google Doc, Slides deck or PDF in your Drive, and can email it for you. It uses the same <<Column Name>> tags as Autocrat and can import your existing Autocrat jobs.
Sign in with GoogleFree for 50 documents a month. No card needed.
The Google Workspace Marketplace listing is coming soon. Questions: [email protected]
What it does
Rows to documents
Pick a Google Docs or Slides template with <<tags>>. Each row becomes a Doc, a PDF, or both, named and filed by patterns you set.
On form submit, on a schedule, or now
New Form responses are picked up automatically. Conditions let you merge only rows that match, for example Status = Approved.
Email each result
Optionally send each result as an attachment or link to the address in the row. It arrives as "you via TrustyMerge" and replies come to you. Each email is sent once.
Status written back
Every row gets a status, Doc link and PDF link in your sheet. Rows that fail say why, in plain words.
Set up in three steps
- 1
Choose the spreadsheet
Sign in with Google and pick the sheet whose rows you want to merge, or open TrustyMerge from the side panel inside Google Sheets.
- 2
Pick a template and a folder
Any Google Doc or Slides file with
<<tags>>that match your column names, and the Drive folder the results go to. - 3
Save
Existing rows are merged, and new rows and form responses merge on their own from then on, even while the sheet is closed.
Built to keep running
Merges run in a server-side queue rather than in one shared Apps Script project. TrustyMerge paces its calls to stay under Google's per-user API limits, retries temporary Google errors for up to 24 hours, and resumes interrupted runs where they stopped, without creating duplicate documents or emails. Current service health is on the status page.
Narrow Google permissions
TrustyMerge uses Google's per-file permission (drive.file): it can only see the sheet, templates and folders you choose, never the rest of your Drive. TrustyMerge never asks for access to your Gmail. Your sheet values and documents are processed in memory and written only to your Drive; if you turn on emailing for a job, each email and its attachment are handed to our email provider for delivery. Details: privacy policy.
Coming from Autocrat?
Open your sheet, start TrustyMerge and choose Import Autocrat job. TrustyMerge reads the job from the sheet's Autocrat settings, keeps your template and tags, and marks rows Autocrat already merged as done so nobody gets a second email. Then turn off the Autocrat job's triggers. How TrustyMerge compares to Autocrat.
Pricing
Free
$0
- 50 documents per month per Google account
- Form check every 5 minutes, hourly schedules
- Standard queue
- A small "Made with TrustyMerge" line in emails only, never in your documents
Pro
$5/month or $39/year
- 5,000 documents per month
- Form responses processed within a minute
- Schedules every 15 minutes
- Priority queue
- Email support within 1 business day
School / Domain
$249/year
- Every user in one Google Workspace domain
- 50,000 documents per month, pooled
- Admin (domain-wide) install
- Invoice or purchase order on request
A document is one merged output for one row (a Doc and its PDF count once). A row that fails before its document is made never counts. Over the limit, rows wait with the status "Waiting: monthly limit reached" and nothing is lost. Annual plans can be refunded within 14 days; monthly plans can be cancelled any time.
Sign in with GoogleEvery plan starts free. Upgrade inside the app when you need more.