Unlock the Secrets of PDF Generation with Google Apps Script

Create a PDF using Google Docs template, populate the template from sheets data and send out the PDF via mailApp.
In this tutorial, we'll be exploring Google Apps Script and how it can be used to create PDFs. We'll be using the Google Sheets API to create and manage our PDFs, and show you how to create different types of PDFs using Google Apps Script.
If you're new to Google Apps Script and want to learn how to use it to create PDFs, then this tutorial is for you! We'll walk you through the basics of Google Apps Script and show you how to create a simple PDF document using the Google Sheets API. By the end of this tutorial, you'll have a better understanding of Google Apps Script and be able to create PDFs using the Google Sheets API!
Google Apps Script has proven itself a highly useful and highly valuable resource in the ecosystem of low-code/no-code. It’s been around long before the term “low-code” and consequently, evolved over the years, from new learnings and new opportunities within Google Workspace.
Speaker: Laurence Svekis is a Google Developer Expert who is creating online courses with over 700,000 students - web development and technology-related content creators.
#appscript #google #js #javascript #nocode #lowcode #googleappsscript #appsheet #googleworkspace #googledocs #automation

[@xxxChubyxxx]

A real Life Saver !!!!!!!! Thank you ! this saved me a ton of money and well I really appreciate it

[@BurritoBrooks]

That was awesome! Didn’t even know this was possible. Thanks!

[@brightadewole6784]

Highly resourceful. Many thanks for this

[@LaurenceSvekisCourses]

Thank you for watching

[@xxxChubyxxx]

I already Commented but this video was so good thanks !!!!!!!!!!!!!! again

[@LaurenceSvekisCourses]

Thanks for watching

[@RobKraut]

This was awesome! Thank you! One question: I have URLs to images on my google sheet as well. Is there a way to embed the image into the Google Doc template with this method?

[@Trackdaygenius]

This is a Life saver! One question, if I remove the email function will the if(row[0] == ‘’){ function still work, to check if the date column is empty? As i need the ability do select certain rows to generate the pdf, I have 120 rows, I don’t need all of them to be generated…

[@ciceropontes7732]

Beautifully done! I'm working with some dates and times. When I get the dates or times, they come in the format like Sat Apr 29
2023
02:00:00
GMT-0400
(Eastern
Daylight
Time). How can I do in order to get (and show in the pdf generated) just 4/29/23 format for dates and 11:30 PM format for time? tks.

[@brunoserman78]

Great video, Lawrence, thank you very much! Would you be able to make a copy of the code available to us, please?

[@gasparlam4267]

Thank you so much!
Is it possible to get the pdf opened right after it is created? or even get it printed by local printer?

[@LaurenceSvekisCourses]

Yes but not in the apps script, you need to run frontend code for this JavaScript can handle that.

[@LaurenceSvekisCourses]

You would need a web page to trigger the download or open to printer

[@MunnaBhaiUSA]

Great Video! How do we speed up this script to complete this process way faster (if my google sheet had many rows)

[@LaurenceSvekisCourses]

You can mail out more canned messages, how many rows do you have?

[@LightTheLampLLC]

Great Video!
Quick Question, how do you take the value of the spreadsheet classified as dollars/currency/accounting and apply it to the word document to transfer over as same $ format? This video has been beneficial and got everything working except the formatting of the numbers.
Example: In excel sheet $240,000.00 but generated in word document --> 240000 and transferred into the PDF same as the word.
Do you have any suggestions on that?
Thank you again for your time!

[@LaurenceSvekisCourses]

have you tried setting the type in Google sheets before export.

[@scotttauriello250]

@@LaurenceSvekisCourses Yes, I have tested all types in google sheets to see if it's impacted and it is not. The numbers do not generate over as same format as currency or finance. I have also tried to set the word template as well with the incorrect results. Any other suggestions? I have looked online and it seems no one has tried using $ numbers to transfer only whole numbers.

[@ashfaqashraf7700]

Try typing the replacers in doc this way ${price}

[@derekdimmick8666]

I have a sheet with a table already on it that is updated from info from other sheets all inside one sheet. Hopefully you follow. I want google sheets to automatically just make that one sheet a pdf and save it to my google drive. So probably half of what this script is doing. How can I accomplish that?

[@mpsychservices1325]

Hi can, you make a content that encrypts the pdf with a password. Thank you

[@iprsa]

Thank you very much. It it a realy great video and code. Is it posible, to replace an old pdf file with a new one in app script. I have link to pdf file in Google Drive, posted on internet, I just want to create a new pdf file and update the old one to remaine the same link.

[@LaurenceSvekisCourses]

You can create a new PDF with the same name, while deleting the old file if you need the same path.

[@immi1498]

Link plz?

[@BraveHeart-ht8zf]

How if I want sent automation email contains pdf tables with different emails every 12 hours

[@gegklungkung]

where is the pdf file, i try your code. No found error but pdf not create on folder. please other tutorial create pdf only from sheet data.

[@user-mu4ze2zh8y]

I wish you would show the code fully to help us debug easily.

[@mathewforsyth1006]

I pasted my code above in a comment. It does not include the email function, but it will save you a bit of time, if you've not already typed it out ;)

[@Nico_Aramy]

is it possible if we sent the file to whatsapp ?

[@LaurenceSvekisCourses]

Yes you can use a web hook with whatapp

[@danielpaes6457]

how to preview a pdf file for the user to choose whether to print or save to the computer? I'm trying but without success!