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.