# Knack and PDFs and Google and Sheets and Knack

**URL:** <https://forums.knack.com/t/knack-and-pdfs-and-google-and-sheets-and-knack/13677>\
**Category:** Get Answers\
**Created:** [January 23, 2023, 2:44pm UTC](https://forums.knack.com/t/knack-and-pdfs-and-google-and-sheets-and-knack/13677 "2023-01-23T14:44:48Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![JarrodSevi20608](https://avatars.discourse-cdn.com/v4/letter/j/ec9cab/32.png) [@JarrodSevi20608](https://forums.knack.com/u/JarrodSevi20608)\
**Post date:** [January 23, 2023, 2:44pm UTC](https://forums.knack.com/t/knack-and-pdfs-and-google-and-sheets-and-knack/13677/1 "2023-01-23T14:44:49Z")

</div>

Ok - So here me out…I’m not smart enough to even know if this would work, but wanted to get thoughts on this before I spend 132 hours figuring it out. For the sake of this convo, let’s use Zapier.

Basically, what I’d like to do is…

Update a record (Let’s call it “Create PDF”)  
Knack sends data to Google Sheets  
Google Sheets sends to Google Docs Template  
Google Docs Template creates PDF  
PDF Doc is inserted in Google Sheets as a file  
Google Sheets sends the PDF file to Knack

Would this work or is this the dumbest thing anyone has asked since the last time I participated in the community? I understand this wouldn’t work for all intended applications, but in theory, it could help me create some training certificates.

---

<div class="post-metadata">

**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\
**Post date:** [January 23, 2023, 10:32pm UTC](https://forums.knack.com/t/knack-and-pdfs-and-google-and-sheets-and-knack/13677/2 "2023-01-23T22:32:23Z")

</div>

I’m not sure about inserting a pdf inside a Google Sheet, you can add the file URL but I don’t think you can embed the actual PDF file.  
Creating a certificate from dynamic Knack data into Google Docs is completely possible. I don’t use Zapier (I use Make) so you will need adapt the below video to suite. Depending on your knowledge level the video should help move you forward.

PS. This is obviously not my video production, just one of many channels I follow. 😀🚀

[![](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/f/f81a7819d8a88a926b884b16b057ad21b421ac6d.jpeg "Generate Dynamic PDF's in Integromat (without paid apps)") ](https://www.youtube.com/watch?v=ZenYtu4BRL8)

---

<div class="post-metadata">

**Author:** ![JarrodSevi20608](https://avatars.discourse-cdn.com/v4/letter/j/ec9cab/32.png) [@JarrodSevi20608](https://forums.knack.com/u/JarrodSevi20608)\
**Post date:** [January 24, 2023, 11:40am UTC](https://forums.knack.com/t/knack-and-pdfs-and-google-and-sheets-and-knack/13677/3 "2023-01-24T11:40:29Z")

</div>

@CarlHolmes Thanks! Maybe my first thought should have been insert a pdf to google drive and then back to Knack. Thank you for posting this video. I’m a big fan of your channel, as well! I appreciate the feedback!

---

<div class="post-metadata">

**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\
**Post date:** [January 24, 2023, 2:32pm UTC](https://forums.knack.com/t/knack-and-pdfs-and-google-and-sheets-and-knack/13677/4 "2023-01-24T14:32:41Z")

</div>

Thanks @JarrodSevi20608 - hopefully it was of help and some inspiration 😊