Question: Using google sheets write a script to send a remainder via email to the following assigned staff about their duties. Emails must be sent every
Using google sheets write a script to send a remainder via email to the following assigned staff about their duties.
Emails must be sent every morning at 7:00 am. Emails must state: Good morning, Name please help us to complete this duty by today during the assigned time.
| Monday | Tuesday | Wednesday |
| 1/6/2020 | 1/7/2020 | 1/8/2020 |
| Walk-through PSA (7:00 & 10:00 AM) | ||
| Jessica | Meline | Edderli |
| Meline | Edderli | Jessica |
| Javier | Jemelly | Adianis |
| Jemelly | Adianis | Giovanni |
| Freddy | Nufergi | Maria |
| Nufergi | Maria | Alonso |
| Escorting (7:15 - 8:15 AM) | ||
| Lesly | Ronald | Jemelly |
| Ronald | Jemelly | Adianis |
| Attendance Duty (8:30-9:30 AM) | ||
| Kaurynis | Lesly | Luis |
| Meline | Nemesis | Nufergi |
| Ruth | Stephanie | Adianis |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
