Pdf creation with button

[Waser_I_Solutions]

Hello everyone, I would like to use a button to create a pdf, for this I have prepared a google doc with placeholders from the google table. as soon as the button is pressed, a pdf is to be created from a copy of the doc and sent to a folder on google drive and in a line in the google table so that it can be viewed in the glide app, how can i do that? I’m completely lost

[Darren_Murphy]

There is a thing called PDF Monkey which is quite popular for this sort of thing. I’ve never used it, but I’ve seen others recommend it. If you search around the forum, you should find plenty of threads about it.

Another way to create PDF’s is with Apps Script (this is what I do). But if you’re not comfortable with Apps Script, that may not be the best approach.

[Roldy]

This can be an approach:

How to generate a PDF in pdfmonkey.io via Zapier

I want to premise that the method I am presenting here is currently the only one that I have tested and for which I am sure that it works. It is likely that there are better methods than mine; I think that through webhook it is possible to do better than this but I have not yet had the opportunity to experience it. In any case, if you want to know how to generate a PDF from your sheet which is the datasource of your Glide application, this tutorial will probably be useful for you. So let’s ge…

[Eric_Penn]

Here is the app script for that

PDF Generation - Google Scripts help

function emailSpreadsheetAsPDF() { DocumentApp.getActiveDocument(); DriveApp.getFiles(); // This is the link to my spreadsheet with the Form responses and the Invoice Template sheets // Add the link to your spreadsheet here // or you can just replace the text in the link between "d/" and "/edit" // In my case is the text: 17I8-QDce0Nug7amrZeYTB3IYbGCGxvUj-XMt8uUUyvI const ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/17I8-QDce0Nug7amrZeYTB3IYbGCGxvUj-XMt8…

[Darren_Alderman]

@Waser_I_Solutions That script is a great example of how I typically set this up.

One thing to keep in mind is there will be a delay from when the document is generated to when it is visible in the app because you have to wait for the url to document to be added to your Google Sheet then wait for Glide to sync to the Google Sheet again and grab the URL.

[Mark_Turrell]

Integromat is actually really easy to use for this too

[Jesus_Valenzuela_Dia]

I use integromat to do it. Here is a video of the scenario, basically I created a template in google drive, then 1. Document is created from the template replacing the {{tags}} with the parameters values received in the webhook. 2. Once created, the .doc and .pdf links are pasted in a sheet (link columns) 3. Both documents (.doc and .pdf) are sent by email

Export PDF scenario.mp4 (video)

[Waser_I_Solutions]

Thanks, that helps me. I could now create a pdf and save it in a folder in drive. I don’t know what to fill out for the google sheets so that the pdf is saved in the cell, can you help me?

[ThinhDinh]

For my use cases in Integromat, this means having a column in the Sheet and your last node in Integromat writes back the Drive link to that document into the Sheet.

[Jesus_Valenzuela_Dia]

Sure,

1. it is important to send the Row ID to integromat
   

2. Then you search in the proper google sheet that Row ID value to get the row number.
   

   

3. Once found the row, update a cell using the variable of the row number and the column corresponding to the link, I write both links .doc and .pdf one at the time in different modules, for that for sure i use two different columns in google sheets.
   

   
   
   
   
   
   

Hope this may help you.

[Waser_I_Solutions]

Thank you very much, again a great help in this community. my cell will not be filled, am i missing something? Does something already have to be in the cell so that it can be recognized?

[ThinhDinh]

Seems like the search did not find the cell. You can try “update a row” and then put the right value in the right column.

[Waser_I_Solutions]

It worked, I used the wrong ID in the series.