PDF Creation and Download In AppSheet From Google Doc

[JamesS]

Hello All,

I have an automation that is linked to an action via a update trigger. This automation creates a google doc which is specially set up to be the size of a label(1.5 x 3.5 inches) and pulls relevant data.

I have the google doc app script set up for the automation, but want to know if there is a way to add a function or something to automate the creation of the pdf version, and let the pdf show and be downloaded from the app

[WillowMobileSys]

---

@JamesS wrote:

I have the google doc app script set up for the automation

---

This is unclear.  Are you using a Google Doc template in an AppSheet automation to create your output?   Or are you using a Google App Script to create your output.

As implied above,  you can create automations in AppSheet that use a Google Doc as a template to specify output to a generated PDF.  It is not extremely robust but with some compromises, most/many things can be generated to PDF this way.

You can also create functionality in Appsheet that will let you view the generated PDF's.  The easiest way is, using Google Drive, to place all the PDF's into a single folder and then pull that folder into the app as a table source.  This allows you view all of the PDF files and their meta data in table row form.  With Virtual Columns, you can also link these to other table rows.

There is no way to automatically download PDF files from within AppSheet.   However, you can download manually.  When you view a PDF file, the viewer does provide a download feature.

[JamesS]

I am using appscript to set up the google doc.

The automation in appsheet triggers an app script file to run and create the google doc. This was used instead of the 'Create File' selection as I needed to be able to control the document size(make it 1.5 in by 3.5 in instead of the normal 8.5 in by 11 in).