Schedule & Send Email in Spreadsheets 41 CRX for Chrome or Chromium
Updated: September 30, 2018
Schedule & Send Email in Spreadsheets (jfmcgoflikkgpilaaencmobegkapljda): The main idea of the Schedule & Send Email 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. ... Read More > or Download CRX >
More about Schedule & Send Email in Spreadsheets
Schedule & Send Email in Spreadsheets Description: The main idea of the Schedule & Send Email 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:
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 or CSV files. For this you can select the paper size e.g. A4 or A5 as well as the paper layout e.g. portrait or landscape.
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.
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.
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:
* Unlimited Time Schedules
* Premium Support
* 14 Days Money-back Guarantee
Schedule & Send Email in Spreadsheets Specifications & Downloads >