Amit Agarwal
p/amit-agarwal
Tech Guides, Software Tutorials and Google.
Amit Agarwal
Email Google Spreadsheets — Send Google Sheets via email on a recurring schedule.
Featured
11
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.
Replies
Nate Desmond
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?
Amit Agarwal
@natedesmond 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. https://ctrlq.org/code/19869-ema...
Nate Desmond
@labnol 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.
Amit Agarwal
@natedesmond thank you Nate!
Amit Agarwal
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: https://chrome.google.com/websto... Tutorial: https://www.labnol.org/software/... Video Demo:
For help and feedback, tweet me at https://twitter.com/labnol
Mani Karthik
Incredibly useful tool. I can see it saving me a lot of time and missing timelines/schedules. Thanks Amit! <3
Amit Agarwal
@manikarthik thank you!
Uday Kiran
Everything about this product is pros. No cons at all. Thank you @amit for creating such a amazing product.
Amit Agarwal
@ukiran_2 thank you!
Rydale Country Clothing
This looks great!
Sahib SanDhu
Ih