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.
Listing updated:April 6, 2023
Works with:
154K+
Overview
This addon is completely free forever (not just a trail!), but has some advanced features which need a paid license.
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
PricingFree of charge
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:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Al Baird
March 6, 2023
Excellent Product and excellent service, Does exactly what i needed done and has saved me so much time and hassle! I add myself on cc on the meails that are sent so if i need to follow up with any comments on the reports its really easy to do so.
Is this review helpful?
Yes
No
Profile Picture
Mike Switzer
January 23, 2023
Excellent product, and great customer service! Sent a request about an issue I was having, and received an extremely fast and helpful response that resolved my concern immediately! Would strongly recommend this addon/developer to anyone!
Is this review helpful?
Yes
No
Profile Picture
Aleiya Virgo-Herron
January 7, 2023
It does exactly what I need it to do. Makes my day efficient, runs in the background, is intuitive and the PRO account gives so much more options and flexibility. The programme is smooth with no hiccups thus far. I just set it and forget it. It keeps my colleagues updated and frees me from repeated duties to do other tasks. Tutorials are detailed and very helpful. The programmer answers all queries quickly.
Is this review helpful?
Yes
No
Profile Picture
George Tosounidis
February 16, 2023
It's a GODsend! It's so good, i wish the price for the PRO was HIGHER!! that's not a joke lads...
Is this review helpful?
Yes
No
Profile Picture
Jim Herbert
July 1, 2022
Wow. Works great. Needed something so my wife can send emails to a group. This was so much easier for her then to download as a pdf then attach to an email. As she needs to send it out monthly a great feature is that it automatically sends the email monthly to the group. Made her life easier and less complicated. Not to mention I had some questions and Michaela was very prompt in getting back and was very helpful. Definitely canโ€™t go wrong with this Addon.
Is this review helpful?
Yes
No
Profile Picture
Jeff Pierre
August 29, 2022
There was a similar product provided by Digital Inspiration that we used for quite some time until their basic product was no longer free. I found your product and Iโ€™m thrilled that it helps us get the right information to the people who need to see it. It gets the job done!
Is this review helpful?
Yes
No
Profile Picture
Sandya D
November 27, 2022
We're sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED. Getting above error, kindly help on this please.
Is this review helpful?
Yes
No
Profile Picture
Pritesh Chandarana
December 6, 2022
Simple and easy to use. Plus very impactful, thanks!
Is this review helpful?
Yes
No
Profile Picture
oilmax office
March 1, 2023
Very nice
Is this review helpful?
Yes
No
Profile Picture
Patrick Fransz
October 28, 2021
This is a great addon. I worked using the free version for nearly a year, and decided to upgrade because when my colleagues seen the reports I was automating to my inbox everyday, they wanted them too! The licence is worth it to have the functionality. One of the many challenges today is there is so much data and many dashboards/spreadsheets available - people don't always check (or have the time to check!). This simple addon allows me to send the most important information, automatically, to the people who need it - so they can always access the data in their inbox.
Is this review helpful?
Yes
No
1-10 of 89
Search
Clear search
Close search
Google apps
Main menu