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.

Here is a list of all the options I could find for exporting a PDF from a Google spreadsheet.

Further to user requests, I have created many variations on the PDF creation theme.

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.

The Gist of the script.