Simple Google Sheet notification system
Maksettu toimituksen yhteydessä
Project Description: Simple Google Sheet notification system
I am looking for a freelancer to create a simple Google Sheet notification system that will send both email and SMS notifications to a team in real-time.
- The system should be able to send both email and SMS notifications.
- The notifications should be sent to a team.
- The notifications should be received in real-time.
Ideal Skills and Experience:
- Experience with Google Sheets and Google Apps Script.
- Proficiency in integrating email and SMS notification systems.
- Strong understanding of real-time data updates and notifications.
Step 1) To check Roadtax and MOT check this site and input Car Reg Number [login to view URL] (THERE IS API FOR THIS [login to view URL] )
Step 2) Check every day at 7:30am gmt+0 if the date is expiring soon (in the next 5 days or already expired) - if YES send notification.
Step 3) Notification send via whatsapp group or SMS and multiple emails.
Excel formatting and input
Automatically retrieve the roadtax expire data and MOT expire date in realtime when inputting the car registration.
Green field if in date, red if expiring in the next 5 days
I will provide the google sheet - please message me for it.
Projektin tunnus: #37241305
40 freelanceria on tarjonnut keskimäärin $157 tähän työhön