Reminder Requests App

Inspiration

We were inspired for this program by our own planners, everyone has planners whether in their bag or in their phones that help them schedule their tasks. We wanted to build an APP that made planning your day easier, if you have an important assignment or exam, now all you have to do is schedule an email to remind you!

What it Does

Leveraging the Google Sheets API, users can schedule emails based on a specified date they input. The user simply provides their message along with the desired delivery date, and the system automatically dispatches the email on the morning of the scheduled date. Additionally, a calendar feature offers a visual representation of dates throughout the year for user convenience.

How We Built It

We built the project using Google Sheets API and nodemailer, a library in node.js that allows programmers to schedule emails based on a specific time and date. The html form we built recieves user data and sends it to the Google Sheet API to then sent be to the nodemailer program. The nodemailer program schedules the emails when run by the console, and sends them based on the user-given date.

Challenges We Ran Into

Time constraints caused to change many of our initial plans, we wanted to include a login form to allow users to save the reminders they set using our app. We also wanted to add functionality to the calendar on the right where reminders added would be shown.

Accomplishments that we're proud of

I am proud to say that we built this using the Google Sheets API as it was difficult finding YT videos for guidance on both the API and the nodemailer. We've never worked on a website using APIs or back-end technology at all, it was definitely an experience that we learned a lot from.

What We Learned

We learned a great deal about using APIS, difficulties with configuring databases such as MYSQL, and the nodemailer library. I learned about the amazing work you can create with coding!

What's next for Reminder Requests App

We want to add the original functionality we intended, such as the login form and showing reminders on the calendar app, allowing user data to be saved.