Help & Support
Send Feedback
Schedule & Send Emails in Spreadsheets
Schedule Emails and send your Spreadsheet data automatically to one or more recipients. Convert your sheets in PDF, Excel or CSV.
Works with
Install
Overview
The main idea of the Schedule & Send Emails Add-On is that you schedule emails on a regular basis in order to send Spreadsheet data automatically to the email inbox of your recipients. Optionally you can save your files in Google Drive too e.g. for documentation reasons. Both is especially required when you create reports or dashboards with the use of the Google Analytics Spreadsheet Add-On. 

The following settings and features are available: 

Report Settings
With the report settings you can define which of your sheets you want to convert. Use the “Edit Report Settings” Button to define your report settings. 

You can convert one, several or your entire spreadsheet as PDF, Microsoft Excel, Open Document Spreadsheet or CSV files. For the PDF export you can select all typical PDF settings like the paper size e.g. A4 or A5, paper orientation e.g. portrait or landscape, margin, scale, formatting, etc. 

NEW: You can even merge ALL PDF SHEETS IN ONE FILE. This is especially required to work around the Google export limit which allows to only export 5 files per email.    

Choose a desired filename including the current date or other dynamic cell values of your spreadsheet or just the current sheet name for your email attachments. 

NEW: You can have a preview of your exporting files to check if the formatting corresponds to your desires. 


Email Settings
You can then define to whom you send your reports by using the “Edit Email Settings” button. The email settings have the typical email functionalities: A To, CC, BCC, subject and body field. 

To send your sheets to several recipients simply add several email addresses in the designated text field and separate several addresses via a semicolon.

To send different sheets with different settings to different recipients you need the “multiple schedules” feature which is available in the PRO version. Simply upgrade to PRO to use it.  

Insert dynamic values to your email settings like current date in the email subject or important spreadsheet metrics in the email body. 

Save your settings: You can now send the sheet(s) manually to your recipients with the “Send Email Now” button. This is helpful if you want to test your setup and send a test email to you, before you start sending it to e.g. your boss. 

This is also helpful when you often need to send Spreadsheet data manually per email but don’t want to export the files and attach it to your email client each time. 

Optionally you can save your files to Google Drive too e.g. for documentation reasons. Please note: This is a BETA-feature and will be optimized in future. 

Schedule Settings
Next to the manual email sending, set up a schedule on a one time, hourly, daily, weekly and monthly basis for reporting automation. For this, choose the “Edit Schedule Setting” button to open the settings field. Click on “Add” to add a new email schedule. You can create one or several schedules for your spreadsheet. 

For example, if you wish to automatically send your reports only on weekdays add five “daily” email schedules - one for each weekday. Note: There is no “weekdays” option. Instead you can add multiple schedules for multiple requirements. This allows you to send your Monday-schedule between 8am and 9am and your Tuesday-schedule between 4pm and 5pm, etc. This makes the Add-On much more flexible and dynamic, instead of adding a static weekday-schedule.  

Note: In the free version you can create several schedules but need to send it always to the same recipients. To send different sheets with different settings to different recipients you need the “multiple schedules” feature which is available in the PRO version. Simply upgrade to PRO to use it.  
Save your settings and start scheduling your emails by clicking the “Enable Schedule” button. You will be noticed that scheduling is enabled via a green bar at the top of the add-on. 

To disable scheduling for one specific person, delete this person from the email address field. Save and schedule your settings again. 

To disable scheduling for all persons, click on the “Disable Schedule” button. You will be noticed that scheduling is disabled via a red bar at the top of the add-on.

PRO VERSION: Multiple Schedules
You can upgrade this add-on to the PRO version anytime. 

The most important benefit of the PRO version are multiple schedules: With this you can send different sheets with different settings to different recipients. To do so, you can create one or several schedules in the schedule overview menu. For each schedule  you can set your report settings, email settings and schedule settings exactly like in the free version. 

For example, you can set up a schedule for your marketing department and send your reports on a daily basis. The marketing manager might need the report only once a week: So set up another schedule and send your report on a weekly basis. Also the CEO might need an update but only once a month: So set up another schedule and send your report on a monthly basis as well. 

You can rename your schedules to easier manage them like for example Marketing Schedule, Manager Schedule and CEO Schedule.  

Save your settings and start scheduling your emails by clicking the “Enable Schedule” button exactly like in the free version. You will be noticed that scheduling is enabled via a green bar right to the schedule name. You will also be noticed about the amount of active schedules via the green bar at the top of the add-on.  

Your further PRO benefits: 
* Multiple schedule settings
* Unlimited Time Schedules
* Merge several sheets to one PDF file 
* Dynamic values for reporting settings 
* Premium Support (I answer ALL of your questions within the next 48 hours) 
* 14 Days Money-back Guarantee
Reviews
A User of Schedule & Send Emails in Spreadsheets
May 7, 2019
Good to use, free version is enough to create one schedule
Submit reply
Cancel
A User of Schedule & Send Emails in Spreadsheets
May 7, 2019
This is a well-crafted and easy to use mailer that saves you a lot of coding time.. Incredibly reasonable cost per year as well!
Submit reply
Cancel
A User of Schedule & Send Emails in Spreadsheets
April 22, 2019
very useful , but how can i download all sheets one time without separated sheet , can i ?
Submit reply
Cancel
A User of Schedule & Send Emails in Spreadsheets
April 18, 2019
Love this add-on. It keeps me and the teams I work with connected to our spreadsheets automatically in our inbox. Well worth the cost.
Submit reply
Cancel
A User of Schedule & Send Emails in Spreadsheets
March 28, 2019
Super useful.
Submit reply
Cancel
David Klein
February 26, 2019
Incredibly well featured add-on that does exactly what we need - such granular controls over sending schedules and settings, perfect to personalise to your individual needs. This makes our workflow more automated. The developer also gave us in-depth assistance in getting our add-on up and running to work well with our data, for which we are very grateful. Great value.
Submit reply
Cancel
Sachin Panaskar
February 12, 2019
This works amazing with a lot of features built in!!! In the body of the email, I am trying to add a table (10 rows x 4 columns). On a daily basis, there will be anywhere between 1 and 10 rows in my spreadsheet. In the email that is sent, is it possible to show the table with only those rows with non-blank values? Thanks!
Submit reply
Cancel
A user of Schedule & Send Emails in Spreadsheets
March 17, 2019
Hi Sachin! Thank you very much for your great rating and feedback. Regarding your question: Currently it is not possible to add a dynamic table into the email body. What you can do is, to send the desired data as an excel or pdf attachment to your recipients. Or you can insert the link to your spreadsheet and your recipients can view the data directly in the spreadsheet. Because this is the main idea of this add-on. As a workaround I can recommend to set the border to 0 (instead of 1). This makes the border invisible. Furthermore I will consider your idea and think about how to implement it in my add-on in the future. Hope this helps you further. Best, Michaela
A User of Schedule & Send Emails in Spreadsheets
February 6, 2019
I love this add-on! Although I only use it to submit weekly timesheet and expense reports now, the ability to automate and customize the process are features I hope to take advantage of in the future. The highly responsive developer is a huge bonus, too.
Submit reply
Cancel
Laurance Narbut
January 24, 2019
Fantastic plug-in - THANK YOU! Request: While you allow for a cell to be place in the email itself, it would be great to allow it to be a range of cells (table format or even a JPG would be fine). This would allow lazy recipients the opportunity to just see the content without even clicking on the attachment. Many, many thanks for your consideration!
Submit reply
Cancel
A user of Schedule & Send Emails in Spreadsheets
January 24, 2019
Hi Laurance! Thank you so much for your rating and your great feedback. :-D I do have this feature on my feature list but didn't had time to implement it so far because I really want to make this feature useable (which just needs some thinking-time). I will priorize this for you (and some other who wished to have this feature as well) and will publish it in the next few weeks (end of Q1 2019 latest).
A User of Schedule & Send Emails in Spreadsheets
January 24, 2019
After paid the pro version, the developer didn't give me any response for either the receipt or solving my problem which is the add on didn't allow me to send report anymore.
Submit reply
Cancel
A user of Schedule & Send Emails in Spreadsheets
January 24, 2019
Hi, very sorry for answering so late. I really do my best to answer every request within 24 hours but sometimes I need 48 hours as I am doing this all in my free time and have a busy fulltime job as well. I have sent you the receipt and I have also answered your request regarding the Google limit (100 emails per day) with three workarounds. I really hope one of them fits for you. If you need anything else, please do not hesitate to contact me again. I do give my best to answer you earlier. Regards, Michaela
1-10 of 22
Additional information
Search
Clear search
Close search
Google apps
Main menu