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!

[brightadewole]

Highly resourceful. Many thanks for this

[xxxChubyxxx]

I already Commented but this video was so good thanks again

[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?

[ciceropontes]

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 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.

[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…

[MunnaBhaiUSA]

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

[gasparlam]

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?

[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!

[derekdimmick]

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?

[brunoserman]

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

[mpsychservices]

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

[BraveHeart-htzf]

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

[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.

[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.

[muzezhy]

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

[Nico_Aramy]

is it possible if we sent the file to whatsapp ?

[danielpaes]

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!