Collecting data on a google form. Need that to generate a doc from a template (ideally google docs), then send a pdf of that doc via email. Constraints:
- google doc created needs strict permissions (not available to public via url)
- pdf should not be saved at end of process
I’ve setup google doc template, and successfully merged rows from sheets w doc, which creates a doc file that is private.
Issues:
- Cloud print even using same credentials can’t access the doc correctly and “prints” a login screen to pdf rather than the doc
- convertapi returns “success” without any document payload
- docmerge looks like it might work but is prohibitively priced
- If I use the Drive app in zapier to adjust permissions on doc, I can’t change them back to private at end of zap
- Even if I successfully cloud print the doc to pdf, it saves to root (ok - I can “move” it), and I can’t delete it after emailing it
So, any suggestions? Ideal would be solution that can convert private google doc file to pdf, but not save to docs.
Best answer by BowTieBots
View original