Closed

Google Sheets Script - Send Email Based On Input

This is an easy job for a good coder who knows they are doing.

I have a google sheet (test one for this purpose) that has some weekly data inputed on to it.

I have a conditional formatting set up that if it is below a certain number it turns red or green.

I want to create a script that checks when an input happens (which might be at any time ) and then see's if its red or green. If its red then it waits 60mins to allow for any corrections by the inputter, then if not automatically sends a template email which inputs the target no and the actual number (red number) with a short pargprah of text. It must come from a gmail or normal email account to allow the person receiving it to respond to the email as normal and it arrive in an inbox like any other email.

I know there is ways to do this using google api so should be a simple script to create. I have a sample email and test sheet ready to work with.

Skills: Google Chrome, Javascript, PHP, Software Architecture

See more: script send email facebook network, script send email confirm registration, php script send email ixwebhosting, email reminder script google spreadsheet, alert by email when input data on google spreadsheet meets given condition, send email from google sheets, google sheets send email based on date, google apps script send email on form submit, google spreadsheet send email when changed, send email when cell value changes google, google sheets email trigger, php, google chrome, php script send email form cc, make web script send email, google app engine send email attachment, script send confirmation email, php script send email birthday, script send email web page smtp, shell script send query result email

About the Employer:
( 264 reviews ) billericay, United Kingdom

Project ID: #16588735

3 freelancers are bidding on average $37 for this job

pavka007

Hello, Nice to meet you. I am familiar with Google sheet. I have 10 year programming experiences and with my experiences, I can develop this in only 1 day. Let's discuss more details. Thanks.

$25 USD in 1 day
(7 Reviews)
4.7
JackandMadchen

PHP expert with APIs. I can do the script as you want, and we can use the test doc you mentioned to assure that it works as you expect. I am ready to start immediately. Please message me now to get started.

$50 USD in 1 day
(9 Reviews)
2.7
kishu0079

Hello I have done so many email Automation [login to view URL] it would be so simple for me. I have more than 2 years of experience in Google sheet and Google apps script. you can check my reviews. if you are interested , plea More

$35 USD in 1 day
(2 Reviews)
2.6