ANALYTICSkiste.blog
•  40,327
Overview
Schedule and automatically send email 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. New: Multiple configurations per sheet available.
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/
Reviews
Language:
Sort by:
Profile Picture
A User of Schedule & Send Emails in Spreadsheets
June 3, 2020
pdf export doesn't support Arabic letters
Is this review helpful?
Yes
No
Profile Picture
A User of Schedule & Send Emails in Spreadsheets
May 22, 2020
I super duper love this auto spreadsheet sending thing. I have a different report that I share every morning. And I've used it for more than one of my clients. Your service plus my zapier workflows is a great time saver. I tried another similar service before this one, which worked fine and then stopped working one day, I tried to go premium on that service with no response after they took my money. Schedule & Send works awesome. I want to send reports to my team from my work's outlook email, but for a reason that I cannot remember now, automations from sites like zapier are blocked or something like that. So I auto send to a gmail account which zapier then finds, reformats and forwards from my outlook email to the team. Another one I did was I set up a simple order form for a restaurant to sell their products while they were closed because of COVID. the orders were added to a series of sheets depending on product category. I set up a auto send to share a sheet that summed up all of the items sold that day on a daily sales report PDF. The owner was an older gentleman that preferred looking at a report on a piece of paper vs the spreadsheet of orders. Also, the support is great. They are very friendly and helpful. Definitely recommend.
Is this review helpful?
Yes
No
Profile Picture
A User of Schedule & Send Emails in Spreadsheets
May 20, 2020
good
Is this review helpful?
Yes
No
Profile Picture
Chris Ortleib
May 14, 2020
set up a texting program for a company of ice rinks in Columbus, Ohio and wanted to send them some statistics on a weekly basis. Instead of having to use the snipper tool to send them graphics of my tables on Google Sheets, your add on made it infinitesimally easier to automate. This is something I'm planning on doing in the long-term future, so I am sure I will get much more use out of your add-on. Thank you for putting out a great product at a reasonable price.
Is this review helpful?
Yes
No
Profile Picture
A User of Schedule & Send Emails in Spreadsheets
May 9, 2020
YESSS
Is this review helpful?
Yes
No
Profile Picture
Amanda Bailey
April 29, 2020
Best add-on ever bought. Has saved me countless hours of work!!
Is this review helpful?
Yes
No
Profile Picture
A User of Schedule & Send Emails in Spreadsheets
April 22, 2020
Feature rich, and the creator takes the time to address concerns.
Is this review helpful?
Yes
No
Profile Picture
Ron Rose
April 22, 2020
Excellent, time saver. I use it for a number of projects.
Is this review helpful?
Yes
No
Profile Picture
A User of Schedule & Send Emails in Spreadsheets
April 22, 2020
Great Tool
Is this review helpful?
Yes
No
Profile Picture
A User of Schedule & Send Emails in Spreadsheets
April 20, 2020
I use this add-on in conjunction with a Google BQ plugin. So I am able to refresh data from BQ and then send an email with data to users. The plugin is very easy to use and setup.
Is this review helpful?
Yes
No
1-10 of 52
Additional information
ANALYTICSkiste.blog
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu