Google Apps Script: How to export Google Sheets as PDF 

Happy to hear the video was useful! Automation is all about being more efficient so I'm really happy this video has helped you to save time.

Awesome, thank you! 😀

Welcome to the GAS community! Happy you liked the video.

Welcome 😊

Welcome

Glad you enjoyed it 😀

Thanks for watching. Yes, you could have people add their data to a website if they might be intimidated by a spreadsheet.

Oh, so easy. I am posting the solution here. For setting the name use ` instead of '. ;-)

Yes. You need to use backticks and not common ticks. Looks almost the same but has a very different outcome.

Thanks 😀

Grazie 😀😀

@@saperis ma sai anche l'italiano?🤩

@Andrea Guerri Si, un po.

Thanks for the tip! 😀

You would probably want to change the naming of the file to contain the week or the date. And then you would choose a weekly trigger instead of a monthly one.

You would have to modify the script to get a value out of a certain cell and then using that as the name of the document.

Not that I know of

Check this blog post as it seems it's more what you are looking for than my video. xfanatical.com/blog/print-google-sheet-as-pdf-using-apps-script/

@@saperis Thank you for the link!

No, you can't download any of the Google file formats directly to your computer. That's why in the menu you can only choose non-Google formats to download. But there are backup solutions out there. I remember seeing this video that might be helpful: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UiZYy-146_0.html

Thanks for watching. We don't share the code of the scripts directly. You get the script by copying as we write the code.

Hm. Not quite sure what the best option would be as it depends on your Sheets and your expectations. You would essentially be only copying data and so you would loose the spreadsheet layout. So it probably would be best to copy that new row into another Sheets and then export that one. But there might also be a more straight forward way of achieving your goal. Best you try it out.

I don't think you can. The official documentation doesn't make any mention of passing in the paper format when creating a new file: developers.google.com/apps-script/reference/drive/folder#createfilename,-content,-mimetype

Check this tutorial to see how you could possibly only export one sheet: stackoverflow.com/questions/38335143/export-single-sheet-to-pdf-in-apps-script

Check out this blog post to see how it's done: xfanatical.com/blog/print-google-sheet-as-pdf-using-apps-script/

Have a look at this blog post: xfanatical.com/blog/print-google-sheet-as-pdf-using-apps-script/

Thanks for the feedback. 😀 Check this blog post to see how to export only a certain region. xfanatical.com/blog/print-google-sheet-as-pdf-using-apps-script/

@@saperis splendid thanks, exactly what I needed. But don't really understand the script on the page. Please can we get a video on this issue....thanks u d best

@@oluwayomidada3536 Very sorry, but I don't do any Apps Script videos anymore.

Check this tutorial to see how you could possibly only export one sheet: stackoverflow.com/questions/38335143/export-single-sheet-to-pdf-in-apps-script

@@saperis Thank you so much.

If it doesn't work as expected you could maybe try to create the file with a different mimeType: developers.google.com/apps-script/reference/drive/drive-app#createfilename,-content,-mimetype

You would have to write a new script for that. Check the official documentation to find out how to use Apps Script to achieve your goals: developers.google.com/apps-script

As what type of file do you want to export it?

Sure, you can do almost anything with Apps Script. Check the Apps Script documentation to find out how to achieve what you want to do: developers.google.com/apps-script/reference/spreadsheet

Thank you for your request. I don't do any Google Apps Script or Google Workspace videos anymore. Find out more in this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-OHd_xEabivg.html

@@saperis Thank you so much.

The error message tells you that you are using "Driveapp" but that doesn't exist. Note how I wrote "DriveApp" in my script. It has to be a capital A.

I'm guessing there is an error in our script. Try to find it by following this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-L4V15ZxIjBQ.html

Sure. You are the creator of the script. So you decide how it works.

I'm not quite sure but I think CSV is not supported for what the script I wrote does. Check: ramblings.mcpher.com/gassnippets2/apps-script-file-conversions/ And also: github.com/prasmussen/gdrive/issues/303

Alright thank you for the reply@@saperis . One would think exporting as csv would be the easiest function from sheets. Apparently not. I'll work around it.

Check this tutorial to see how you could possibly only export one sheet: stackoverflow.com/questions/38335143/export-single-sheet-to-pdf-in-apps-script

@@saperis Thanks a lot

You can only create a PDF from a spreadsheet and not from a single sheet within a spreadsheet. But after some research I think this might be the approach: - hide the other sheets within the spreadsheet - create your PDF of the spreadsheet (the hidden sheets are omitted) - un-hide the other sheets Here is where I read about this approach: stackoverflow.com/questions/38335143/export-single-sheet-to-pdf-in-apps-script

Well, those are some very specific questions. I've never done what you want to do but I, in theory, it should be possible. Obviously, you would have to adapt the script to your needs.

@@saperis Yes, I'm looking to see what that script is. But this got me off to the right start. Thank you!

Check out this blog post to see how it's done: xfanatical.com/blog/print-google-sheet-as-pdf-using-apps-script/

Check this tutorial to see how you could possibly only export one sheet: stackoverflow.com/questions/38335143/export-single-sheet-to-pdf-in-apps-script

@@saperis Thanks a lot

I don't know how to change the page orientation either.

@@saperis Oh I see, thanks for your response! Looking forward for more tutorial

You can only create a PDF from a spreadsheet and not from a single sheet within a spreadsheet. But after some research I think this might be the approach: - hide the other sheets within the spreadsheet - create your PDF of the spreadsheet (the hidden sheets are omitted) - un-hide the other sheets Here is where I read about this approach: stackoverflow.com/questions/38335143/export-single-sheet-to-pdf-in-apps-script

@@saperis Thank you for your support.

I had the similar challenge. My total Google Spreadsheet has 10+ sheets in it. I only need to export 4 special sheets as pdf regularly (these 4 sheets contain the reporting dashboards). So here is the work around: Create a completely new Google Spreadsheet and use the "Importrange" formula to mirror/autosync the sheet from the original spreadsheet you need to export. As a result, this new spreadsheet only contains the sheet you need to export. You can do that with as much sheets as you might need for your regular export. Finally, use the spreadsheet-id of this new mirrored spreadsheet as the basis for the script you learned in this video. You do not have to touch this new "mirror spreadsheet" anymore. Whenever there is a change in your main spreadsheet, the "importrange" function will update everything automatically in the mirror spreadsheet. If you need help, how to use this magic "importrange" function, watch this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5S7laJS9meU.html hope that helps! I have built lots of automated regular reports based on these two hacks and it spends me a ton of time. crazy!

@@sirhenrymondeo Yes this how we are doing !!

Check the comments on this video. I've re-shared a tutorial to do so multiple times.

I don't know as I've never had your exact situation. Maybe you could use the debugging mode to run your code to find out why it isn't working: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-L4V15ZxIjBQ.html

Check the comments as this has been asked many times and I always share a link to a tutorial you will want to check out.

Check this video to find out how you can add such a button: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Xd56y8GZbIM.html

The error means that you are trying to run a function that isn't one. Check your code for any typos. Be aware that whenever you want to call a function you have to make sure to add the parentheses at the end: functioName()

Please check your code again. Did you write all the necessary symbols? Any typos? The message is telling you that Pl.getAs is not a function. That could be because you didn't add the parentheses () or something similar.

Check the documentation to find out: developers.google.com/apps-script/reference/spreadsheet/sheet

If I'm not mistaking this script makes a PDF from a spreadsheet. So from the entire file including all the sheets within the file.

Check your code again because you somehow aren't referencing the DriveApp correctly. Is there maybe a typo in your code?

We have no video about how to do that. Maybe this article can help you: stackoverflow.com/questions/38335143/export-single-sheet-to-pdf-in-apps-script

Have a look at this tutorial: xfanatical.com/blog/print-google-sheet-as-pdf-using-apps-script/

I guess you export it next month?

@@saperis I want to do it for salary slip

hello mam pls reply

Check this tutorial: spreadsheet.dev/comprehensive-guide-export-google-sheets-to-pdf-excel-csv-apps-script

Maybe you could hide the sheets you don't want to have exported. Check this information to get an idea on how you could solve your problem: stackoverflow.com/questions/38335143/export-single-sheet-to-pdf-in-apps-script

Ohh 😂 Thanks a lot. 🙏

I this method page will not setup How to setup page like A3 ,A4 and Make pdf a particular sheet Can you help me please 🙏

You can't print with Apps Script as it doesn't have a way to connect to your computer or printer.

@@saperis I mean how do I export to pdf but from specified sheet and want 2 pages

I'd check Stackoverflow to see if you can find a code snippet there. I don't have one at hand myself.

Hey Anh. We don't offer any support for Google Apps Script projects or automations.