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.
3 freelancers are bidding on average $37 for this job
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.
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.