Send & Email Google Spreadsheet Plugin RELEASE NOTES

Further features on TODO list:

Report Settings (next weeks)

  • Select custom range to export (not just the whole sheet)

Save to Drive (next 1-2 months):

  • Custom file names with dynamic values

Schedule (not planned yet):

  • define start and end date
  • bi-weekly functionality (like in Google calendar)

NOT planned in near future:

  • Conditional sending, because this is already possible with a little work around, see FAQ.
    • possible use case: send only when a specific cell is filled
    • possible use case: send every single time an email when a particular field is populated
    • possible use case: only send emails if value X is greater than Y

Further resources:

Latest version: #2.66

20th August 2019

  • Filters in Sheet will now be refreshed before sending
  • Bugfix: Folder selection will now display all folders hierarchically from Google Drive, even shared folders and Team Drive folders.

8th August 2019

New Feature:

  • You can now select the destination folder for „Save to Google Drive“

31st July 2019

New Features:

  • Email Settings: Set a custom senders name (senders email address can’t be changed!)
  • Email Settings: Send text-only emails
  • Advanced Settings: Disable the reference footer
  • Report Settings: Merge XSLX/ODS sheets to one file (same as PDF)
  • Updated PRO Status page with possibility to upgrade/extend current licenses

18th June 2019

Bugfix:

  • fixed a display issue in the report settings (not showing sheets to select)

10th May 2019

New Features:

  • Added advanced PDF export settings (margin, scaling, pagenumbers etc.)
  • New Preview for PDF exports available
  • Merge your sheets to one PDF document (PRO only)
  • Enable/Disable ALL schedules at once (PRO only)

Bugfix:

  • added a new error message if user is logged in with multiple Google accounts

4th February 2019

BUGFIX:

  • {%DATE%} now respects ALL timezones and correctly outputs the date

31th January 2019

  • Insert dynamic cell ranges (whole tables) in email body (inline HTML)
  • Bigger email body textarea
  • Send email now: information that email is suceccfully sent

BUGFIX:

  • Very long text in email body is now saved correctly (up to 200kb)

24th January 2019

  • BUGFIX:
    • Dynamic value {%DATE%}: shows the correct date in the correct spreadsheet timezone
  •  PRO ONLY:
    • Automatic receipt via email after purchasing PRO
    • „Copy Schedule“ feature added for easier creation of several schedules + copied schedules are automatically deactivated and need to be actived in order to run

22nd August 2018

NEW FEATURE AVAILABLE: 

PRO Version of the plugin for 9.99€/year

  • Multiple Schedule Settings
  • Unlimited Time Schedules
  • Premium Support
  • 14 Days Money-back Guarantee

12th May 2018

NEW FEATURE AVAILABLE: 

  • Report Settings:
    • Self-defined file names (optional)
    • Dynamic file names via dynamic values (current date, cell value)
  • Schedule Settings:
    • more schedule options like for specific days like (only Monday, Thurday, Sunday or only workdays, weekends)
    • more schedule options for time like every day at 3am, every day at 4am, all 3 hours, etc.

Additional Changes:

  • Tidy and clean add-on interface: reporting, email and schedule settings now available via pop-up
  • Comprehensive FAQs

07th March 2018

NEW FEATURE AVAILABLE: 

  • Dynamic date value now in local language (same as spreadsheet locale settings)
  • Dynamic values enabled for To/CC/BCC email fields
  • Enabled HTML editor for email body
  • Enabled „Insert Image“ for email body

24th January 2018

NEW FEATURE AVAILABLE: Dynamic values for Email subject and body

  • Add DATE to subject or body to get the current date (date where email is sent)
  • Add CELL VALUE to subject or body to insert the value of the selected cell. To change the cell you can simple edit the number in the subject or body field. [BETA FEATURE]
New Feature: Dynamic Values

Screenshot: New Feature – Dynamic Values

Additional Changes:

  • Email Settings: CC/BCC added
  • Save to Google Drive Settings: filename now in English

25th November 2017

Schedule Settings: Time selection to weekly/monthly schedule added

Schedule Setinngs - Weekly / Monthly time choosable

Screenshot: Schedule Settings

Email Settings: Error message added if more than 50 recipients added to list

Please note: You CAN’T send emails to more than 50 recipients because of a Google limit. Please consider that a group email does not count as single email address but for each person in the group: So when you have 30 people in a group email, it counts for 30 people.

17th October 2017

Schedule Settings: Timezone changed to spreadsheet timezone and not script

Please note: Resave your schedule to get the correct timezone.

2nd October 2017

Schedule Settings: Bugfix for sending multiple sheets (sheet selector)

1st October 2017

Schedule Settings: Hour selection for daily reports added

hour selection

Screenshot: Hour selection available now

NEW FEATURE AVAILABLE: Save your spreadsheets also to Google Drive (exerimentaly)

Please note: The files are saved in the same folder of your spreadsheet.

21th September 2017

Email Settings: Bugfixs for sending Emails

20th September 2017

NEW FEATURE AVAILABLE: You can select as many sheets as you want (not only one or all)

Sheet selection

Screenshot: Sheet selection

Email Settings: New WYSIWYG editor added

28th August 2017

Email Settings: HTML editor added

18th August 2017

Bugfix Email Scheduler

13th July 2017

File selection: Sending first sheet as PDF (before only all sheets possible)

1st July 2017

Schedul Settings: Bugfix

25th May 2017

Initial Version (yippi it’s only now :-D): Schedule & Send Emails (see detail plugin descriptions here (Germany only, will be available in English soon))