# Generating a PDF Report from Glide

**URL:** https://community.glideapps.com/t/generating-a-pdf-report-from-glide/57379
**Category:** Ask for Help
**Created:** [February 1, 2023, 5:43pm UTC](https://community.glideapps.com/t/generating-a-pdf-report-from-glide/57379 "2023-02-01T17:43:31Z")
**Posts on this page:** 18
**Page:** 1

<div class="post-metadata">

### Author: ![Chuntyboy123](https://avatars.discourse-cdn.com/v4/letter/c/b2d939/32.png) [@Chuntyboy123](https://community.glideapps.com/u/Chuntyboy123)
#### Post date: [February 1, 2023, 5:43pm UTC](https://community.glideapps.com/t/generating-a-pdf-report-from-glide/57379/1 "2023-02-01T17:43:31Z")

</div>

I need to generate a monthy report from Glide.

The App enters a daily task based on activity performed. At the end of the month, I will like to have a PDF report with all these tasks captured in a report.

Is there a way in Glide to do this or I will need API ?

Thanks in advance.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 1, 2023, 11:56pm UTC](https://community.glideapps.com/t/generating-a-pdf-report-from-glide/57379/3 "2023-02-01T23:56:11Z")

</div>

Do you store your data in Google Sheets, Glide Tables or somewhere else?

---

<div class="post-metadata">

### Author: ![M.V\_Consulting\_SRL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/m.v_consulting_srl/32/3613_2.png) [@M.V\_Consulting\_SRL](https://community.glideapps.com/u/M.V_Consulting_SRL)
#### Post date: [February 2, 2023, 9:17am UTC](https://community.glideapps.com/t/generating-a-pdf-report-from-glide/57379/4 "2023-02-02T09:17:34Z")

</div>

Hi,  
I was about to post same question.  
I’m using Glide Tables and I cannot figure how to export all the items to Make and how to generate a new document (report) with all the fields, based on a template.  
I will follow your post.  
Thank you

---

<div class="post-metadata">

### Author: ![Andrew\_Davies](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_davies/32/41838_2.png) [@Andrew\_Davies](https://community.glideapps.com/u/Andrew_Davies)
#### Post date: [February 2, 2023, 12:25pm UTC](https://community.glideapps.com/t/generating-a-pdf-report-from-glide/57379/5 "2023-02-02T12:25:58Z")

</div>

This may help (or May not) but I generate a lot of reports using on2air (very helpful developer too)

However - it only works with Airtable so your data needs to be stored there (which mine is)

Here’s a link to the specific product [https://on2air.com/documents/](https://on2air.com/documents/)

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 2, 2023, 11:45pm UTC](https://community.glideapps.com/t/generating-a-pdf-report-from-glide/57379/6 "2023-02-02T23:45:25Z")

</div>

I usually construct a HTML/CSS template in [PDFMonkey](https://www.pdfmonkey.io/) beforehand.

In that template, I define my variables and have a plan on structuring the data accordingly in Glide.

Then, in Glide, I create a button to trigger a webhook in Make. That webhook payload will contain all the variables I have constructed in PDFMonkey.

Then, in Make, I add a PDFMonkey node to generate the PDF based on the input data. I get the resulting document URL, use a HTTP module to download it and upload it to Google Drive.

Finally, I get the Google Drive link back to Glide using Glide’s API.

---

<div class="post-metadata">

### Author: ![FV.io](https://avatars.discourse-cdn.com/v4/letter/f/49beb7/32.png) [@FV.io](https://community.glideapps.com/u/FV.io)
#### Post date: [February 2, 2023, 11:46pm UTC](https://community.glideapps.com/t/generating-a-pdf-report-from-glide/57379/7 "2023-02-02T23:46:54Z")

</div>

Do you know if its possible to export glide-generated QR-codes and images to PDFMonkey?

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 2, 2023, 11:58pm UTC](https://community.glideapps.com/t/generating-a-pdf-report-from-glide/57379/8 "2023-02-02T23:58:40Z")

</div>

I imagine if you use a service like this:

[https://goqr.me/api/](https://goqr.me/api/)

You would be able to send the URL of the QR code to PDFMonkey and load it in an img HTML tag.

---

<div class="post-metadata">

### Author: ![FV.io](https://avatars.discourse-cdn.com/v4/letter/f/49beb7/32.png) [@FV.io](https://community.glideapps.com/u/FV.io)
#### Post date: [February 3, 2023, 12:02am UTC](https://community.glideapps.com/t/generating-a-pdf-report-from-glide/57379/9 "2023-02-03T00:02:22Z")

</div>

I’ll try that - Thank you!

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 3, 2023, 12:02am UTC](https://community.glideapps.com/t/generating-a-pdf-report-from-glide/57379/10 "2023-02-03T00:02:46Z")

</div>

Please let me know in this thread if I can help with anything. Thank you!

---

<div class="post-metadata">

### Author: ![Chuntyboy123](https://avatars.discourse-cdn.com/v4/letter/c/b2d939/32.png) [@Chuntyboy123](https://community.glideapps.com/u/Chuntyboy123)
#### Post date: [February 3, 2023, 2:26pm UTC](https://community.glideapps.com/t/generating-a-pdf-report-from-glide/57379/11 "2023-02-03T14:26:44Z")

</div>

Data is stored in Google Sheets.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 3, 2023, 2:31pm UTC](https://community.glideapps.com/t/generating-a-pdf-report-from-glide/57379/12 "2023-02-03T14:31:38Z")

</div>

Might be the same concept as I mentioned above.

> [@Generating a PDF Report from Glide](https://community.glideapps.com/t/generating-a-pdf-report-from-glide/57379/6):
>
> I usually construct a HTML/CSS template in [PDFMonkey](https://www.pdfmonkey.io/) beforehand. In that template, I define my variables and have a plan on structuring the data accordingly in Glide. Then, in Glide, I create a button to trigger a webhook in Make. That webhook payload will contain all the variables I have constructed in PDFMonkey. Then, in Make, I add a PDFMonkey node to generate the PDF based on the input data. I get the resulting document URL, use a HTTP module to download it and upload it to Google Drive. …

I was asking because I think you can get away from relying on a button click in the app, and instead using Make to search the Sheet rows you want to send to the report, but gotta take into account that I don’t know about your data structure.

---

<div class="post-metadata">

### Author: ![M.V\_Consulting\_SRL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/m.v_consulting_srl/32/3613_2.png) [@M.V\_Consulting\_SRL](https://community.glideapps.com/u/M.V_Consulting_SRL)
#### Post date: [February 3, 2023, 4:32pm UTC](https://community.glideapps.com/t/generating-a-pdf-report-from-glide/57379/13 "2023-02-03T16:32:20Z")

</div>

As for me, this is a little bit complicated 🤔  
My ideea is to export in Make with a Webhook all the records as a Joined List.  
Then, with an Iterrator to split that Joined List into ‘X’ records.  
An then, in some way, to write all those separated records into a single Google Doc Template (each record as a row) … but i don’t know how to do this last part of the scenario 🤨

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 3, 2023, 11:31pm UTC](https://community.glideapps.com/t/generating-a-pdf-report-from-glide/57379/14 "2023-02-03T23:31:55Z")

</div>

@Robert_Petitto @Darren_Murphy are you aware of an easy way to have a “joined list” of records as a variable value in Google Docs Templates?

What I usually do in PDFMonkey is pass a JSON object containing multiple rows’ info, and then use the loop feature in PDFMonkey.

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [February 3, 2023, 11:47pm UTC](https://community.glideapps.com/t/generating-a-pdf-report-from-glide/57379/15 "2023-02-03T23:47:56Z")

</div>

Not to my knowledge. Looking to dynamically fill a space in a Google Doc with an iteration of sorts?

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 4, 2023, 2:09am UTC](https://community.glideapps.com/t/generating-a-pdf-report-from-glide/57379/16 "2023-02-04T02:09:25Z")

</div>

> [@ThinhDinh](#):
>
> @Robert_Petitto @Darren_Murphy are you aware of an easy way to have a “joined list” of records as a variable value in Google Docs Templates?

Not something that I’ve tried. Until now, I’ve always used Apps Script to generate PDF from a GDoc template, so anything like that I’ll do programmatically.

I wonder if this use case could be a good candidate for the pure Glide method that we’ve been discussing with Jeff?

---

<div class="post-metadata">

### Author: ![M.V\_Consulting\_SRL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/m.v_consulting_srl/32/3613_2.png) [@M.V\_Consulting\_SRL](https://community.glideapps.com/u/M.V_Consulting_SRL)
#### Post date: [February 4, 2023, 8:04am UTC](https://community.glideapps.com/t/generating-a-pdf-report-from-glide/57379/17 "2023-02-04T08:04:19Z")

</div>

I have a solution for my pdf report:  
In my glide table, I have a template column, with all the information i need for my report. And those info are already spaced as a row for my report. Then i used a joined list in order to be able to export the info with a webhook to Make.  
Once there, I used an Itterator in order to split the info and obtain my future report rows

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/9/b9627fc551a3c3ab4cf5ffa135ff5cbf473f7332.jpeg)  
then i used a table aggregator

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/5/55d7252fd241bbd3d0f9a2c628c5e01ea4419629.jpeg)

I used the value from Table aggregator in my Doc Template together with several info from Webhook

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/4/b44226f7814d4a05ba45ef4f733d46c0bcfbc032.jpeg)

then I download this doc as a pdf, using Make again

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/c/ec03fdaffd06a9207b0c4b40a9aa41135173df9e.jpeg)

This is the Report resulted:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/0/103124bc215b8387f0523af94699a8cb9e4710ae.jpeg)

Is not a simple solution, but i was interested to have one in a very short time 🙂

---

<div class="post-metadata">

### Author: ![Andrew\_Davies](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_davies/32/41838_2.png) [@Andrew\_Davies](https://community.glideapps.com/u/Andrew_Davies)
#### Post date: [February 4, 2023, 9:43am UTC](https://community.glideapps.com/t/generating-a-pdf-report-from-glide/57379/18 "2023-02-04T09:43:13Z")

</div>

Great!

This looks fabulous. Thanks for posting

---

<div class="post-metadata">

### Author: ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)
#### Post date: [March 6, 2024, 3:20pm UTC](https://community.glideapps.com/t/generating-a-pdf-report-from-glide/57379/19 "2024-03-06T15:20:17Z")

</div>

Imagine if they just added a feature that allowed you to export as pdf…would save so much time…
