One PDF per row of your Google Sheet
Write a Google Doc with <<tags>> for your column names. RowDocs fills a copy for every row, saves it as a PDF in the Drive folder you choose, and writes the PDF link back into the sheet.
Install from Google Workspace Marketplace
RowDocs is in Google's review right now. It will be installable from the Marketplace as soon as Google approves it.
Your Autocrat templates just work
Same <<Column Name>> tags, so switching takes minutes, not a rebuild.
Runs on form submit
New Google Form response in, document and email out. No button to press.
Only the rows you want
Merge rows that match a condition, like Status is "Approved", and skip the rest.
Links written back
The document link and status go into your sheet, so you always know what was sent.
Formatting built in
<<Amount|number:2>>, <<Date|date:d MMMM yyyy>>, <<Name|upper>>.
Minimal access
RowDocs only works with the files you pick and the documents it creates. It never reads your Gmail.
Questions
Can I name each PDF from the row?
Yes. The file name is a template too, e.g. Invoice <<Number>> - <<Client>>.
Can it skip rows that are already done?
Yes. Rows that already have a merge status are skipped, and you can add a condition like Status is "Approved".
Can I format numbers and dates?
Yes: <<Amount|number:2>>, <<Date|date:d MMMM yyyy>>, <<Name|upper>>.
Free to start
20 documents a day free, forever. Pro removes the limit for $49 a year. See pricing.