codingprivacy / automatic-remider-system Goto Github PK

This repository is an automatic reminder application for various documents needed for the international students for our university. A system where students in the institution gets reminders as messages or E-mail, where the students data is to be kept updated in an excel file. Application automatically fetches the data and sends reminders everyday to the selected students.

1.The excel sheet must contain following rows with exact names:
    a."name of student" #shows the name of the student
    b."frro 1(rc/rp) start" #gives start date of the rc/rp process
    c."frro 2(rc/rp) start"
    d."frro 3(rc/rp) start"
    e."frro 4(rc/rp) start"
    f."contact number"
    g."email"
2. Names of all the students whose process is going on will be saved in data.json file
3.If any frro row contain no entries ; for the moment make it as 0000-00-00 i.e as a dummy entry

1. Script triggers every day at a specific time
2. Check if database is updated.
3. Fetch the database from excel file from cloud.
4. Take the 'frro student date' from the the database.
5. Start the scheduling for 1,2,3,8,9,10 day for the all the students and will send messages to all those students on those specific days.
6. Make the scheduling for same students on 11th month as the same students will have to do the same process after 11 months.

    1. schedule
    2. gspread
    3. oauth2client
    4. twilio

    Harsh Patel
    Vatsal Mistry