Google Apps Script: How to export Google Sheets as PDF

In this video you will see how you can use Google Apps Script to export a Google Sheets document as a PDF.

00:00 Intro
00:10 What we will be automating
00:23 Create PDF export script
03:34 Create message sending script
05:05 Run the code

Want to learn how to be more productive with Google Workspace? 🤩

#GoogleAppsScriptSheetsPDF #GoogleAppsScript #AppsScript #GoogleWorkspace #saperis #ChanelGreco
-----

saperis - Helping you become a Google Workspace Pro!

[alexanderbaranov]

Thanks a lot!!! You've just saved tons of hours of my life!
Moreover, everything is inspiring: the logic and style of explanation, air of the video, and your personal approach.
Great job!

[ivanurbina]

Love your tutorials. How to export google sheet to pdf was just what I needed. Thank You. I am subscribed to your wonderful tutorial❤️

[dantevivero]

this is so new for me this GAS programming, a newbie :D excellent vid!

[WaxN-eyvj]

Your video is awesome! I think app script has a potential to be an alternative of Salesforce applications.
I know app script allows you to have a html website and users can interact with data. I wonder if it has another GUI approach that anyone who is not familiar with coding can handle data manipulation.

[joshuarein]

This worked great, how do I add day and year to the "current month" portion of the code, what is the proper code?. I will be automatically sending out a pdf weekly and do not want 4 files with the same name (ex "Oil Report June", I need "Oil Report June 7 2024" or similar. Thanks

Hi, thanks for this tutorial. Is there a method to force the pdf orientation to "landscape" ? A parameter to add or something else ?

[eighthkapsule]

Thank you! So helpful. how do I name the PDF based on a cell value?

For example: .set name (‘File Name - grabs cell value A1’);

Thanks so much!

[raymondjackson]

This is fantastic! Are you able to please provide a link to - or the actual copy/paste script? Sorry if it's obvious and I just missed it.

[aljunnaag]

This is very helpful! I would like to know though if it's possible to run this code so that (1) only a specific range is exported, and (2) change some PDF format options?

[sirhenrymondeo]

Thank you so much for this tutorial. I have countless usecases for that! May I ask one question: the .setName('Revenue Stats ${currentMonth}'); statement should define the file name. In your script, the ${currentMonth} command is black and refers to the const "currentMonth". Here on my side the string ${currentMonth} is red and is not referring to the setting behind, so the final pdf is named "Revenue Stats ${currentMonth}" and does not replace the place holder with the actual month. Same in the email subject. Do you have any advise on this? Thx in advance.

[ac]

Great video!
I wish to just export the rows having the current dates to the PDF every evening. How can I achieve that with your code mentioned here?
Thanks

[joshuarmir]

Thank you so much for this. I have one question...Instead of a month, I need a weekly report. How can I add that to the script? Thank you so much again. From Medellín, Colombia.

[GenNextAnalyst]

Excellent and useful Chanel! Perhaps you can add ko-fi as a way to sustain and grow your YT.

[normantam]

Is there a way to customize this to export in landscape format? Thank you for the great video!

[hasanmia]

Thanks for your good video. I have been benefited by this one.
Now please suggest me a code for delete the specific cells data of Google sheet by app script

[jsg]

Thanks for the really good lecture :) I have one question, is it possible to extract only one specific sheet from google spread sheet file?

[sheetautomation]

Thanks for your video. If there are many sheets in the file. How could I export one specific sheet to pdf?

[videoshow]

Hello is there a google sheets native format ? Can we download it to local disk for backup to creat a an exact copy? There is only windows xlsx ods and PDF and some text files in file download menu.

[arifzainal]

Amazing tutorial thank you so much. Can you please tell me how to convert and send a specific sheet name within the file, not the entire sheets? appreciated :)

[pepemiko]

Hello, I tried this with a Google Sheet and it works. A slight issue though is that the PDF being saved/emailed includes all of the sheets within the file. If I only want to have a specific sheet sent and saved as a PDF, how should the script be tweaked? I hope you can still answer my question. Thank you in advance!