Convert and Email Google Spreadsheets as PDF Files

You can setup a cron job in Google Drive using Google Apps Script that will send any Google Spreadsheet, or any other document or file in the Drive, to one or more email addresses at a specified time. You can set the time-based trigger to run weekly, daily, every hour and other recurring schedule.

This example shows how to send a Google Spreadsheet to the specify email address automatically as a PDF file daily. The Google Script converts the Google Spreadsheet into a PDF file and send them to any email address using the MailApp service. You can further customize the PDF output – like remove gridline, hide frozen rows, change to landscape mode, etc. by setting the correct export parameters.

If you require customization or need help to install the script in your Google Drive, please contact me via the contact form at

The Google Script function will convert each of the worksheets of a Google spreadsheet into a PDF file, compresses all the PDF files in a ZIP file and sends it to a designated email address. You can send to multiple email addresses too – just separate each of them with a comma.

The method currently sends all the sheets of a Spreadsheet in the ZIP file but you can also specify a sheet ID with the &gid parameter to email a particular sheet only. For instance, to send a first sheet, you can set the gid=0 and so on.