1) Fully hosted python app on Heroku that integrates with google calendar API v3 (newest edition) via oAuth 2.0 and uses Google Calendar oAuth to do the user authentication. So the login page is just Google Calendar login.
2) Google Chrome extension that maps the event colors for each event (dropdown) to the event types (text field). It should work when creating / editing an event in the main calendar OR when selecting more options to see the event details.
1) During setup, the user can set text to correspond to each event color in Google Calendar. For Lavender color for eg, the user could set it to "Recruiting". 11 colors total so 11 text fields total.
2) The Chrome extension needs to show the text next to the Color in the Colors dropdown available in the Calendar Event. So when I am in the Google Calendar itself and I try to edit an event, I'll see all the colors next to each text field. So the colors that show instead are replaced with the color AND the text. As an example refer image "Google Calendar integration"
It needs to work in this view and if I select the color dropdown, it'll show each color AND the text next to it. It should work in this view and the prior view if I select the calendar event from the main calendar.
3) On the Heroku app, there needs to be a "Sign out" or "Deauthorize" button so I don't have to clear my cookies.
4) The Extension must not affect page load / speed and must load the calendar fast. You can have a button that says "reload tags" if you prefer to cache.
5) The graph example is attached.
If you use Google Calendar for organizing meetings, activities and events, you will have a wealth of valuable data stored inside Google Calendar. Data that could answer questions like:
* How many hours are we spending on different types of meetings? What percentage of time?
* Who spends most/least time on different types of activities?
* How often do we meet with customer X?
The app should connect to the Calendar data via the Google Calendar API, retrieve live data, analyze it, and generate a report with charts. It should be able to handle a calendar with over 100,000 events.
Specs for Onboarding/Settings:
- oAuth integration for your Google Calendar. Once done, please select which calendars to import. No need for auth login. It will be a website hosted on Heroku using Google Calendar oAuth for user authentication.
- It would ask the user to "Please match the event color with the different types of events" (for example "Sales" or "Marketing" or "Legal"). (There will be 11 colors and 11 text fields, one next to each color for the user to enter "Sales" or "Legal" or whatever) so the program knows what each color means.
Specs for main page of Heroku app:
- It will chart the different types of events colors (ie. Recruiting for example) by number of activities, hours, and percentages spent across a selected date range and lets you filter down to activities with specific owners, specific participants, etc. The key here is that the activities will always be categorized by the event color name (ie. Recruiting for example)
- There is a filter button to include or exclude the default event color (if excluded, it will not show up at all).
- Requirement: It has a date input at the top that defaults to today. I can select a different date or a date range.
Attached image "sample report" is what the graph will look like (but there would only be 11 options, one for every color)
There should be a button at the top that lets you switch between event color types (ie. Sales) and email addresses of the people.
Specs for Google Chrome extension:
The last part is there would be a very simple Google Chrome extension so that instead of the Event color, it would show a dropdown that had each color followed by the event type selected in the Onboarding/Settings of the Heroku app. See photo "Google Calendar integration", so where it says Event Color, it would be a dropdown.