Amit Agarwal
Tech Guides, Software Tutorials and Google.
Start new thread

Email Google Spreadsheets - Send Google Sheets via email on a recurring schedule.

by
•
Automatically send Google Spreadsheet reports to email recipients on a recurring schedule in PDF, CSV or Excel format. For e.g., set up a cron job that emails the employee attendance sheet to your manager around 5 PM on the last Friday of every week.

Add a comment

Replies

Best
Love this! What's are the security/privacy implications? Is it sending my data off-platform? I'm far from an engineer, but it seems to be giving third-party access rather than running locally?
Maker
The add-on uses Google APIs to convert your sheets into PDF and sends the files as attachments using the Gmail API. It does not read, store, share or upload your data anywhere. The Google Sheets add-on is written in Google Apps Script. If you do not prefer a fancy GUI, you can manually run the code and create your own conversion engine with the add-on.
That's amazing, thanks Amit! Appreciate you sharing the code approach. Also - thanks for everything you've been doing for years. I came across your site probably 10+ years ago now, and it's always had some of the best guides I've seen.
Maker
thank you Nate!
Everything about this product is pros. No cons at all. Thank you for creating such a amazing product.
Maker
thank you!
This looks great!
Maker
If your work involves emailing the same spreadsheet to your colleagues and customers on a regular basis, the Email Spreadsheets add-on can save you a lot of time. The add-on lets you send spreadsheet reports to one or more recipients on a recurring schedule. For instance, you can setup a job that emails the employee attendance sheet to your manager around 5 PM on the last Friday of every week. Or you can set up a schedule that emails the sales performance dashboard to your team daily around 9 PM. The sheets can be sent as PDF, Excel or CSV files. You can email entire workbooks, specific sheets inside a workbook or a range of cells. A portion of any Google Sheet can also be embedded inline in an email message using the A1 notation. Download: Tutorial: Video Demo:
For help and feedback, tweet me at
Ih