[aavang]

I built an application that used Gmail to drive an application to automatically share generated reports with a set of users.

A user would fill out a Google Form, which would send an email to a specific Gmail account when the user submits the form. An automated process would scrape the Gmail account every 5 minutes looking for unread emails containing setup requests. The process would then create a new drive folder and share it with the users specified in the onboarding request. Then, generated reports would be emailed to the same email referencing the newly created folder. The automated process would download the reports, upload them into the shared folder, and send the users who can access the folder an email notifying them that a new set of reports is available.

I had a lot of fun using the Google APIs! I played around with translating the reports into a Google Sheet as well.