Completed

Google sheets script writing for sending out email reminders based on variables.

Sending out email reminders for staff's email for certain tasks that are not done.

We are a small business child care center looking for help with reminders for all the little items that staff need to remember to do.

I have been able to alter a script to send out reminders to just me. But have not been able to finetune getting a script to run for each staff's tab in a sheet.

Hope: To have a script setup to send out email reminders based on the email address in each tab. The script would look at each row, if Column E does not say "Done" then it would send out an email if the date in Column B is within 14 days or 1 day.

- The email address would be pulled from G1 on the given tab.

- The email subject would read: "Sprouts Task Reminder"

- The body would read: "The following items are coming up due: - List of all the items that need to be done from Column A. Please refer to your tab in the document, click the link here: .......

Skills: Javascript

See more: automatically email google spreadsheet, google sheets email trigger, google spreadsheet send email when changed, automating google spreadsheets email reminders, google spreadsheet script send email, google sheets send email based on date, google sheets send email based on cell value, google spreadsheet email notification script, \ google sheets\ script, \ google sheets script\ , i am looking for someone to write a google apps script in google sheets, google apps script for sheets, script update cell google sheets, script writing email marketing automation, sending email script, google apps script email validation, email validation google apps script, google apps script email verification, script mini sending email javascript, script sending email godaddy linux

About the Employer:
( 1 review ) Menomonie, United States

Project ID: #15501264

Awarded to:

celalaybar

Hello. I can create a script function that sends email remainders based on values on sheet. I can make script cycle through column values and send emails accordingly. Relevant Skills and Experience I have done with si More

$250 USD in 3 days
(41 Reviews)
5.4

8 freelancers are bidding on average $157 for this job

mohamedkaram93

Hi! We will have a script that runs daily using a time driven trigger. It will go through each sheet of every staff member you have. Then it will go through all rows, if the due date is 1 or 14 days Relevant Skills a More

$90 USD in 3 days
(21 Reviews)
4.5
$155 USD in 3 days
(5 Reviews)
4.3
artistixeit

. “””Before moving to chat please check our previous projects links””””””” Please check the work below: Relevant Skills and Experience Angular : [login to view URL] [login to view URL] [login to view URL] More

$155 USD in 3 days
(2 Reviews)
3.6
itsmfarhan

I read all the requirements of your task and am able to do this job ver well as i am expert developer more than 10 years of experience.I have already done many email sending scripts. Relevant Skills and Experience my More

$140 USD in 3 days
(2 Reviews)
2.2
saikatkm

Hey I have experience in google scripting for long time. I used them for analytics. please let me know if you are interested

$222 USD in 7 days
(1 Review)
1.6
roboinfotech2017

We Believe in Delivering Perfect Work and Providing Full Satisfaction to Our Client . We also Insure to Deliver the Work in the given Time Frame . we have highly Qualified Professionals in our team Relevant Skills and More

$80 USD in 3 days
(2 Reviews)
1.0
fsh59c6cd2f56ce3

Hi, Hope you are doing good. I can write the script to automatic sending the emails to staff. I have seen your attached script. I using this method in my website also www.imagesol.co. Relevant Skills and Experience C# More

$166 USD in 3 days
(0 Reviews)
0.0