Google Sheet Script - Scan spreadsheet once per week, compile email with details and email to an external email

€8-30 EUR

Ολοκληρώθηκε

Αναρτήθηκε

περίπου 6 χρόνια πριν

€8-30 EUR

Πληρωμή κατά την παράδοση

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

Data Entry

Data Processing

Excel

Software Architecture

Ταυτότητα εργασίας: 17065772

Σχετικά με την εργασία

12 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 6 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

Βραβεύτηκε στον/στην:

@MohsanEijaz

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

€100 EUR σε 1 ημέρα

5,0

(87 αξιολογήσεις)

6,3

12 freelancers δίνουν μια μέση προσφορά €50 EUR για αυτή τη δουλειά

@KulfiSoftwares

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 several Google apps Script, and can do this for you, with absolutely best optimized code. ZERO ERROR GUARANTEED!! Please read my 350+ reviews. I am here to impress you with my work.

€150 EUR σε 5 ημέρες

4,9

(350 αξιολογήσεις)

7,7

@elqueabandona

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

€100 EUR σε 7 ημέρες

5,0

(251 αξιολογήσεις)

7,0

@Harun1986

Hello, I am here last 5 years done too many research work. If you look at my rating you will know about my experience. I have best 10 employee where I can support you 10X faster work delivery with quality service. I have best scraping skills and I can collect any targeted Leads contact information Over internet. I saw your attached file and I am ready to show you a sample right now. Please reply for details. Waiting for your positive reply. Thank you

€30 EUR σε 1 ημέρα

4,8

(203 αξιολογήσεις)

6,7

@MarkSalib1511

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 me! .. you will be %100 satisfied I saw your project and I would like to work on it . I am available 24 hours a day and I have fast response, I will be always there to fulfill your requirement. I always offer low cost and good perfect quality (Just try and see by yourself), I will make you get 100% satisfaction with the best quality service. I will be very happy to work with you, and I hope you too. Thank you

€8 EUR σε 1 ημέρα

5,0

(49 αξιολογήσεις)

5,2

@AMRKAMAL2025

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 this process easy and as efficient as possible on your computer. with one press it checks the sheets and sends the emails as you want exactly. if you look for long-term and future updates I will be with you at any time. waiting for your response to talk more about the app will be created and your ideas. Thank you.

€20 EUR σε 1 ημέρα

5,0

(4 αξιολογήσεις)

3,9

@Dipatish

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

€8 EUR σε 1 ημέρα

5,0

(5 αξιολογήσεις)

1,8

@sachinxsshrestha

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. computer works like ms excel, ms word, note pad etc can be perfectly handled by me.

€23 EUR σε 1 ημέρα

0,0

(0 αξιολογήσεις)

0,0

@gchapani

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.

€24 EUR σε 1 ημέρα