Closed

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

This project received 5 bids from talented freelancers with an average bid price of $185 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
5
Project Description

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]

SUBMIT DATE

LAST UPDATED

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online