Is it possible to automatically send weekly emails to a list of recipients of PDFs of each sheet in Google Spreadsheet? I've looked around but haven't found any ways to do this, only found ways to send the actual email, but not with the sheets.

1 Answer 1


Yes, it's possible by using a Google Sheets add-ons and Google Apps Script (GAS). Please checkout the help article Use add-ons & Apps Script to learn the basics.

If you decide to use GAS, you will need a time-driven trigger to send your email weekly.

Below is a related question that may help you to write your own script:

Trying to send email from Google Sheets with image attachment

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.