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]

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