GoogleDocs Script to notify me via email, when heartbeat email is not received

Closed

My AWS server will be sending "heartbeat" email to my gmail account every 5mins.

firstly there should be 2 cells in the spreadsheet with global variables:

add_time - number of minutes to add to "hearbeat time" cell

check_every - frequency with which application is run

When email is received, from a particular address () and a particular subject ("heartbeat"), I would like to run a Google Docs Scirpt to increase value of the cell called "heartbeat time" in google Doc spreadsheet to now() + add_time mins (say every 6 min)

I would like to run periodic check, every check_every minute, (say every 1 min), of "heartbeat time" to check if email has not been received when it should have been

there should also be a cell in the spreadsheet called "lock", which takes value 0 or 1

'Application

'Run every check_every (say 1) minute

If now() > "heartbeat time" and lock = 0 then

notify me via email ( , " Heartbeat email is not received")

lock = 1

end if

'end of application

Furthermore google docs should have 4 buttons

lock - to change value of "lock" cell to 1

unlock - to change value of "lock" cell to 0

start check - to switch on script to run every minutes as above

stop check - to switch off script to run every minutes as above

Finally, there should be script that restarts the application, ie does the following:

lock = 0

start check

when email from a particular address () and a particular subject ("restart") is received

and a script that switches off the "application" ie does the following

lock = 1

stop check

when email from a particular address () and a particular subject ("stop") is received

To check that application is running correctly - I will send you several emails every 5 mins, then stop and after no email is received you should email me with warning "Heartbeat email is not received"

Some usefull links

Send emails with Google Apps:

[url removed, login to view]

[url removed, login to view]

apparently there is now new email trigger

[url removed, login to view]!topic/apps-script/iaA48L_Ay9k

so that emails have to be checked periodically

[url removed, login to view]

simple triggers are described here

[url removed, login to view]

triggers via email:

[url removed, login to view]

[url removed, login to view]

Skills: Google App Engine

See more: script email received, spreadsheet script google, spreadsheet script, script google spreadsheet, script developers, new spreadsheet app, https developers, google docs mail, googledocs com, google apps spreadsheet, google apps script spreadsheet, google apps script developers, google apps email, aws developers, apps script google, app script spreadsheet, app engine email, appengine account, app engine account, app developers forum, google script spreadsheet, google docs is

Project ID: #4494292

5 freelancers are bidding on average $185 for this job

Viqtor

Hi, can help.

$170 USD in 2 days
(5 Reviews)
4.3
srinichal

I look forward to deliver the project

$263 USD in 9 days
(2 Reviews)
3.5
suriyant

I can do it.

$126 USD in 3 days
(0 Reviews)
0.0
GeorgeKazi

Please see your inbox.

$154 USD in 3 days
(0 Reviews)
0.0
thetechie13

Google Docs Expert

$210 USD in 5 days
(0 Reviews)
0.0