Convert multi-sheet Google Sheet to PDF using Apps Script

This Google Apps Script creates a PDF from a multi-sheet Google Sheet with the option of emailing the PDF.

Simply copy the script into the script editor (Tools > Script editor…) of the GSheet in question, save it, refresh the sheet and use the new custom menu option (Create PDF > Create PDF).

It is also possible to call the script for another spreadsheet, specify just the one tab to be exported and specify an email address to send it to.

It is a variation on the popular PDF Creator script.

Get in touch now if you need any help with this or any other GAS scripts or have a look through some other free scripts and snippets.

Here is the Gist of the scipt.