Unlock the Secrets of PDF Generation with Google Apps Script

Google Developer Communities North America

Подписаться 10 тыс.

Просмотров 18 тыс.

50% 1

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

Наука

Опубликовано:

9 авг 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 39

@BurritoBrooks 3 месяца назад

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

@xxxChubyxxx Год назад

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

@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 7 месяцев назад

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?

@brunoserman78 10 месяцев назад

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

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

@Trackdaygenius 5 месяцев назад

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)

@LaurenceSvekisCourses Год назад

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

@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

@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 9 месяцев назад

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

@derekdimmick8666 8 месяцев назад

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?

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

@mpsychservices1325 Год назад

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

@BraveHeart-ht8zf 8 месяцев назад

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

@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 ;)