Email Google Spreadsheet at Recurring Scheduled Time as Excel, PDF

0 Comments
Editor Ratings:
User Ratings:
[Total: 1    Average: 5/5]




This article covers how to email Google spreadsheet at recurring scheduled time as Excel, PDF, or CSV format file. This simply means that the selected Google Sheet(s) will be sent to the recipient on hourly, weekly, daily, or yearly basis at the scheduled date and time. You can set start date and time and recurring schedule to send the spreadsheet to the recipient. To make it possible, you need to use a free Google Sheets add-on called “Email Spreadsheets“.

This add-on can come in handy in many cases. For example, you can use it to automatically send sales report to manager at the specified time on recurring basis, send daily expense reports to someone, etc. You just need to create a rule using the template given by this add-on and fill in the details. After that, the add-on will run in the background and automatically email Google spreadsheet to email address specified by you. The spreadsheet is sent as an attachment to the recipient.

google spreadsheet sent to email address automatically

Note: The recurring email may take 30 minutes or more of the scheduled time to send spreadsheet to the recipient.

How to Email Google Spreadsheet at Recurring Scheduled Time as Excel, PDF, or CSV File?

Step 1: Login to your Google account. After that, access this add-on homepage, and install it. Now launch the add-on and as soon as you do that a new spreadsheet will open. The spreadsheet requires your permission to run, so go ahead and grant that permission.

grant the permission to run

Step 2: Open a spreadsheet that you want to email at recurring scheduled time. When you’ve opened it, use Add-ons menu, then place mouse cursor on “Email Spreadsheets“, and click on Rules option.

use rules option

Step 3: Rules pop-up will be in front of you. It has three main fields. These are:

  • Google Sheet: It helps to add all or selected sheets of the opened spreadsheet. If there is only one sheet, then it will be selected automatically. You can also select output format for sending the spreadsheet. Available formats are: PDF, XLSX, CSV, or OpenDocument (ODS). If you have selected PDF as output format, then you can also set paper size, page orientation, margins (narrow, normal, wide, or none), cell range (like A1:G5) to share only specified cells, etc.

set google sheet options

  • Email Editor: Here, you can set options related to email that will be sent with your spreadsheet. You can add sender email, Cc, Bcc, email subject, sender name, and email body.

set email editor options

  • Scheduler: This is an important and final option. Here, you can set start date and time and recurring frequency (hourly, daily, weekly, monthly, or yearly).

email spreadsheets

Now, you can save your rule.

The template and rule will do its work and automatically email Google spreadsheet at recurring scheduled time as the output format set by you.

You can also open Rules pop-up again to create new rule or edit the existing rule.

Did you know you can also send customized emails using Google Sheets?

The Conclusion:

This is a very useful add-on that makes it possible and pretty easy to email Google spreadsheet automatically at recurring scheduled time as XLSX, PDF, CSV, or ODS format file. Just create the rule once and it will do everything automatically. The good thing is you can also edit a rule and create a new rule from the scratch.

Get this add-on.

Editor Ratings:
User Ratings:
[Total: 1    Average: 5/5]
Works With: Google Sheets
Free/Paid: Free