Google Sheet Script - Scan spreadsheet once per week, compile email with details and email to an external email
€8-30 EUR
Pagado a la entrega
Google Spreadsheet that is to have a script that can scan several sheets every Monday and send an email to an email address with a list of Names who's courses are within 6 months of expiring.
For example on the 2nd tab sheet name "Sub-contractors" , XC's safe pass is expiring in June 2018, XS safe pass is expiring Sep 2018. Also XC's first aid expires in Nov 18 and XS's safe pass expires on Sep 19.
On the first tab sheet "office based", BN's safe pass is expiring in June 18 and EN manual handling is expiring in June 18.
The google script will scan the sheets once a week (on a monday) and send an email from the gmail account to an external email containing a list of the name of the person, the course that is expiring and when it will expire for example:
Hi
Office Based Staff
1. BN, Safe Pass Expiring Jun-2018, Manual Handling Expiring Jul-18
2. ED, Manual Handling expiring June 2018
Sub-Contractors
1. XC, Safe Pass Expiring Jun-2018, First Aid Expiring Nov-18
2. XS, Safe Pass Expiring September 2018
Staff
1. XD, Safe Pass Expiring Jun-2018, Manual Handling Expiring Jul-18
2. FS, Manual Handling expiring June 2018
Regards
Eoghan
Nº del proyecto: #17065772
Sobre el proyecto
Adjudicado a:
I can write Google Spreadsheet script that can scan several sheets every Monday and send an email to an email address with a list of Names who's courses are within 6 months of expiring. Mohsan
12 freelancers están ofertando un promedio de €50 por este trabajo
Google apps script guru.. I can write a script, that will scan the list of given spreadsheets, every Monday, and send the email, to the mentioned email addresses, if they are expiring, as requested. I have written Más
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
Hello, sir! (First Bidder to offer this) I hope I will be awarded from you. ************I agree for any price you will set ** You can test me over chat before you award me! give it a try over chat before you award Más
Hello sir iam a desktop application developer I have a long experience in this field especially in network programming and web data scraping. I will create an application which will be easy to use so it can automate Más
Hello, I am very much interested on your project.I feel that I am the exact match for your requirements after thoroughly reviewing the job description and desired skills. Thanks
I am a young, energetic, trust worthy worker. data copying,data entry, online marketing , article writing, book writing etc are the major strengths of mine. you can hire me if you want a work done in few time. comput Más
I haven't works done here yet, but I'm a good worker and I'm here to help you in whatever you need. I have been working with web and desktop systems, making upgrades and fixing bugs, using all windows technologies.