Google Gmail Missing Email Alert Script
Google Sheet Script to send an email notification alert if you have not received an expected email message in xx number of days.
Script missing email notification
I receive so many emails for online payments due, backup reports, battery UPS backup test reports, room temperature monitor reports, etc. Sometimes I do not know if any of these systems failed to send an email message like they should have, I never know what emails I am missing. This script reminds me that I have not received a particular email that I was expecting or should have received.
Works with Gmail or Google Apps accounts.
Get notified if you have not been emailed a server backup report in the past xx number of days.
Receive an email notification alert if your utility bill was not emailed to you in the past xx number of days.
Get reminded if your friend or elderly person has not sent you an email in xx number of days.
Get notified of important emails missing.
Did not receive the auto deposit notification from your bank.
To get a copy of this Google Sheet and script CLICK HERE You need to be logged in to your Google account. Opens in new window. Select Make a copy.
If you need help on how to use this script, visit https://developers.google.com/apps-script/your_first_script
Information about the missing email notification Google Script
Create a new Google Sheet, and add the above code to it under the menu EXTENTIONS / APPS SCRIPT
You can use any names that you want, but they must he in this exact order. i.e.
Must be the email address to sent the notification to.
Must be the email address that the missing email is from.
Supports any combination of, FROM: email address TO: email address, or email SUBJECT. Use an "*" asterisk to indicate anything. Do not leave any blank rows.
Send email notifications to any email address, or multiple email addresses, comma separate, i.e. Send To "email@example.com,firstname.lastname@example.org"
E1=Notify After Days
used in the subject line of the email alert you receive. i.e. "Have not received an email from mom in xx days"
Configure script to run once per day
or ever how often you want. Using time trigger in Google Scripts.
I would leave line 2 as is, that way you will receive an email notification alert every day letting you know the script ran successfully.
Script written by Ken. for William April 2013.