Strived to automate the process of creating a calendar for college application deadlines. This resource was not available to us and we still could not find one online.

What we want it to do

User opens the Google Form, selects which colleges they are applying to, selects which deadline they choose, and sends email invites to user to add deadlines/events to calendar.

How we built it

We used UiPath to populate Google Sheets of all the colleges and their deadlines. We used Apps Script to create a Google Form with the data from the sheets and to send a calendar invite.

Challenges we ran into

We had some difficulty populating the Google Sheets with UiPath and ran out of time to scale the form.

Accomplishments that we're proud of

We went out of our comfort zones and explored new tools.

What we learned

Learned about UiPath and other ways to populate Google Sheets through web scraping. We also learned to be mindful about scaling.

What's next for College Applications Calendar

Including open house events that the user can select by location and date.

Built With

Share this project: