App Icon
Schedule and automatically send emails after exporting your Google Sheets data on a recurring basis. Convert your sheets as PDF, XLSX, ODS or CSV. Save it to Google Drive too.
Works with:
105,693
Overview
Your advantages: 
- Automate an never ending and kind of boring task: Sending emails manually. 
- Simplify your work: Lean back and let the plugin do the recurring work. 
- Reduce making mistakes: The add-on never forgets to send your emails. 

The โ€œSchedule & Send Email Addonโ€ for Google Sheets lets you schedule emails to export your Spreadsheet data and send it automatically to one or several recipients on a regular basis - in three simple steps. 

๐—ฆ๐—ง๐—˜๐—ฃ ๐Ÿญ: Define your export settings. Convert your entire spreadsheet, individual sheets or even a selected range of cells inside a sheet as PDF, Excel, ODS or CSV file. For PDF export you can select all typical PDF settings like paper size, paper orientation, etc. 

Choose a custom filename including the current date or other dynamic cell values for your email attachments.

NEW: Export each file individually or merge them together to one file attachment. 

๐—ฆ๐—ง๐—˜๐—ฃ ๐Ÿฎ: Define your email settings. You have the typical mail functionalities available: To, CC, BCC, subject and body field. Use dynamic values like current date in email subject or important metrics from your sheet data in the email body. Send your mails to one and up to 50 recipients (Google limit). 

NEW: To send different sheets with different settings to different recipients you need the โ€œmultiple configurationsโ€ feature which is available in the PRO version. Simply upgrade to PRO to use it. 

Optionally, save a snapshot of your file exports to Google Drive e.g. for documentation reasons.

๐—ฆ๐—ง๐—˜๐—ฃ ๐Ÿฏ: Define your schedule settings. Set up your email trigger on an hourly, daily, weekly, monthly or annually basis. You can even add weekday, weekly or bi-weekly schedules. Add a start and end date or define after how many occurences your schedule should end. 

You can also create a one-time schedule that doesnโ€™t repeat but will be sent once on a specific date and specific time in the future. 

NEW: To create multiple triggers within the same sheet you need the โ€œmultiple scheduleโ€ feature which is available in the PRO version. Simply upgrade to PRO to use it. 

๐—จ๐˜€๐—ฒ ๐—–๐—ฎ๐˜€๐—ฒ๐˜€:
- Email PDF reports to your clients daily around 6 PM.
- Submit expense reports to your boss on the last day of the month.
- Send your weekly timesheets as CSV files automatically on Friday evening to your team leader and BCC it to you. 
- Mail the ecommerce dashboard on the first day of the month to your management.
- Mail the same report to your boss daily, to your colleagues once a week and to the management once a month. 
- Schedule and send client reports as Excel sheets for Google Ads, Search Console or Google Analytics for decision making on specific dates and times. 

๐—ฆ๐—ฐ๐—ต๐—ฒ๐—ฑ๐˜‚๐—น๐—ฒ ๐—™๐—ฒ๐—ฎ๐˜๐˜‚๐—ฟ๐—ฒ๐˜€ ๐—ข๐˜ƒ๐—ฒ๐—ฟ๐˜ƒ๐—ถ๐—ฒ๐˜„:
- One-time schedule: send once on a specific date and time in future
- Hourly schedule: repeat every 1, 2, 3โ€ฆ hours 
- Daily schedule: repeat every 1, 2, 3,... days on a specific time 
- Weekly schedule: repeat every 1, 2, 3,... weeks on Mo-Su on a specific time 
- Monthly schedule:  repeat every 1, 2, 3,... month on specific day and time
- Annually schedule: repeat yearly on specific day and time  
- Weekday schedule: will be send Mo-Fr  
- Weekend schedule: will be send on Sa and Su  
- [PRO] Bi-Weekly schedules: e.g. every two weeks, every third month (=quarterly), etc. 
- [PRO] Define start date and time
- [PRO] Define end date or after how many occurrences your schedule should end
- [PRO] Combine Multiple Time Schedules

๐—˜๐—บ๐—ฎ๐—ถ๐—น ๐—™๐—ฒ๐—ฎ๐˜๐˜‚๐—ฟ๐—ฒ๐˜€ ๐—ข๐˜ƒ๐—ฒ๐—ฟ๐˜ƒ๐—ถ๐—ฒ๐˜„:
- NO ad or watermark in your emails, even if you use the free version.
- To field: Send emails to one or up to 50 recipients (Google limit).
- Specify recipients in CC and BCC fields.
- Dynamic fields to enhance subject: current date, cell value
- HTML or text-only body. 
- Dynamic fields to enhance body: current date, cell value, cell range.
- WYSIWYG editor for body. 
- Insert images to email body e.g. company logo.
- Send Email Now: Instantly send emails for testing or manual sendings.
- [NEW] Save exports to Google Drive in a specific folder
- [PRO] Multiple Emails: Send sheets with different settings to different recipients. 

๐—˜๐˜…๐—ฝ๐—ผ๐—ฟ๐˜ ๐—™๐—ฒ๐—ฎ๐˜๐˜‚๐—ฟ๐—ฒ๐˜€ ๐—ข๐˜ƒ๐—ฒ๐—ฟ๐˜ƒ๐—ถ๐—ฒ๐˜„:
- Export one or several sheets, the entire spreadsheet or a selected range. 
- Shows hidden sheets as well. 
- Choose custom file names for mail attachments. 
- Dynamic fields to enhance file name: date, cell value.
- File formats: PDF, Excel, ODS, CSV
- PDF: Different paper sizes
- PDF: Paper orientation landscape, portrait
- PDF: Advanced paper formattings like paper scale, margin, gridlines...
- PDF: Paper header and footer settings
- Auto refresh formulas & filters before sending
- [NEW] Preview for export configuration per sheet. 
- [PRO] File Merger: Merge all sheets in a single PDF file for exporting.
- [PRO] Export a custom cell range only

๐—™๐—ฅ๐—˜๐—˜ ๐—™๐—ฒ๐—ฎ๐˜๐˜‚๐—ฟ๐—ฒ๐˜€:
- No ads or watermarks inside your emails
- Email sending is not restricted at all (Google's limits still apply)
- Free version works forever - no time limit!
- Basic email support included

๐—ฃ๐—ฅ๐—ข ๐—™๐—ฒ๐—ฎ๐˜๐˜‚๐—ฟ๐—ฒ๐˜€:
- Setup multiple configurations for any spreadsheet.
- Setup unlimited schedules for any spreadsheet. 
- Advanced schedule settings: start date, end date, bi-weekly schedules. 
- Dynamic values for export and email settings: date, cell values.  
- File Merger: Merge all sheets in a single PDF file for exporting.
- Premium Support: I answer ALL your questions within 48 hours. 
- 14 Days Money-back Guarantee

Go to https://www.analyticskiste.blog/schedule-send-emails-google-sheets-addon/ to upgrade to PRO. 

The add-on is completely secure and private. No part of your spreadsheet data is read, shared or uploaded anywhere. And because it works in the Google Cloud, your scheduled spreadsheets reports will be delivered even if you are offline or on vacation.

If you have any questions or feedback, email to the developer at support@analyticskiste.blog. 

Addon overview: https://www.analyticskiste.blog/schedule-send-emails-google-sheets-addon/

Getting started tutorial: https://www.analyticskiste.blog/schedule-send-emails-google-spreadsheet/en/
Additional information
Privacy policy
Terms of service
Schedule & Send Email in Spreadsheets will ask for the permissions shown below. Learn more
Schedule & Send Email in Spreadsheets will need access to your Google account
This will allow Schedule & Send Email in Spreadsheets to :
See, edit, create, and delete all of your Google Drive files
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
Send email as you
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
A User of Schedule & Send Email in Spreadsheets
September 3, 2018
Works exactly as promised. Just remember, when you delete a workbook, you have to deactivate the email system for that workbook or it will still send emails. I felt like I had a ghost following me until I learned that the deleted workbook was still sending emails.
Is this review helpful?
Yes
No
Profile Picture
A User of Schedule & Send Email in Spreadsheets
August 13, 2019
This is well built and easy to use. It saves a lot of time and is very helpful in doing exactly what I need to do with it. Highly recommend it!
Is this review helpful?
Yes
No
Profile Picture
A User of Schedule & Send Email in Spreadsheets
August 1, 2019
I use it to automatically send emails to different recipients daily. It really is pretty strong, especially being able to include cells as variables in the TO, CC, Subject and Body. Well done. Michaela's customer support is really good. She replies to most problems within 24 hours. Pro is definitely worth it.
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
Filly Campbell
August 1, 2019
This plugin is really powerful, I love how customisable it is. Being able to pull data from anywhere in your workbook and include that in your exported documents filename & also into your email subject line great. Really happy with it and what it has allowed me to create.
Is this review helpful?
Yes
No
Profile Picture
A User of Schedule & Send Email in Spreadsheets
April 22, 2019
very useful , but how can i download all sheets one time without separated sheet , can i ?
Is this review helpful?
Yes
No
Profile Picture
Jason Wood
January 12, 2019
OMG!! This Add-On is amazing The possibilities are limitless, the amount if time I am going to save this year while still keeping people updated (theyโ€™ll think Iโ€™m a machine!) This has been the find of the year from me!
Is this review helpful?
Yes
No
Profile Picture
A User of Schedule & Send Email in Spreadsheets
July 22, 2019
Amazingly useful app! Works perfectly and Michaela provides fantastic quick support!!
Is this review helpful?
Yes
No
Profile Picture
A User of Schedule & Send Email in Spreadsheets
January 12, 2019
This is very nice add on and very useful for my personal and office related work. Just wanted to check, how can I add the custom size and layout in report setting.
Is this review helpful?
Yes
No
Profile Picture
Akshay M
August 23, 2019
Works great. Really really helpful. Saves your time by avoiding multiple logins to the same sheet to see the data. Can get weekly data over email. If only you could add conditional emails. like if a few cell or one cell is empty, then email will not go or similar.
Is this review helpful?
Yes
No
1-10 of 76
Search
Clear search
Close search
Google apps
Main menu