I'm trying to find a way to generate a PDF from select fields on a record that is triggered on a status change of the record. It's a few text fields and one image field (png) that needs to populate a document and save as a PDF. Ideally it would end up back in the files&images field after creation, but it could go to GoogleDrive too.
Record is being updated via a Fillout form synced with SS. If I could populate the image field in Fillout I wouldn't need the PDF, but they tell me they can't display synced image fields from SS, just capture.
So far, I've tried:
Relay (SS to Google Docs or Google Slides) - works great, except for the image field which I can't get to map.
A couple of Google Sheets add-ons, same problem, can't get the image field to map.
Make and Documint - expensive
Document Designer in SS I can't even get a document created, behaves erratically. I've tried multiple browsers on a Mac (Chrome, Arc, Firefox).
I've looked at Pabbly and DocsAutomator, but haven't found a solution there either.
Appreciate any tips if you have managed to create a similar workflow or generate a pdf with text and image field from a record.