Find Jobs
Hire Freelancers

Analyze employee time spent via Calendar integration

$30-250 USD

In Progress
Posted about 10 years ago

$30-250 USD

Paid on delivery
Deliverables: 1) A fully hosted ruby on rails, python, or (less ideal) PHP 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 (dropdown) to the event types (text field). The Goal: 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? * Etc. 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 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. - There is a filter button to include or exclude the default event color (if excluded, it will not show up at all). See photo sample_screenshot.png. Now, for the way the dashboard could look, I attached a design. You can ignore the productivity pulse and the green bar in the middle of the page. If you hover over one of the options on the right hand side like Shopping, it wouldn't show the percentage, but the number of hours : number of minutes (0h 23m) along with the meeting people's email addresses. If you clicked on the "Communication & Scheduling", it would show a breakdown by either meeting title or email address (as a user, I can select which one). There should be a button at the top that lets you switch between event types and email addresses of the people. For example, if event type is selected: It would show each of the twelve colors with event types such as "Communications & Scheduling" "Reference & Learning" "Marketing" "Sales" etc all from the Settings. If email addresses is selected, then it would show a bar graph of "Meeting with <email 1>" "Meeting with <email 2>" 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 below photo, so where it says Event Color, it would be a dropdown. See photo [login to view URL]
Project ID: 5393097

About the project

5 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
5 freelancers are bidding on average $599 USD for this job
User Avatar
Hi, I (Myself a senior PHP, ASP.NET programmer using C# and VB) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-free codes at the very first instance. After seeing our quality of work and the cooperation offered to you even after the work has been delivered to you, you’ll come to us again and again to avail our services. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I can achieve the results that you are asking for within your timeframe and budget. I am confident I can exceed your expectations and I would love to work on your project. Thanks, Priyanka
$257 USD in 10 days
4.9 (56 reviews)
7.3
7.3
User Avatar
Can help... I am an Expert... Please start a Discussion with me and we can get started from there... Please check the past projects I have handled and check my reviews for what employers have to say about my work... Can start right now...
$1,250 USD in 30 days
5.0 (80 reviews)
6.9
6.9
User Avatar
I have two years plus experience in RoR. I've worked on many projects which are using oauth authetication with linkedin, facebook and twitter. I find myself to be comfortable in integrating Google Calender authentication using oauth in RoR.
$305 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
San Francisco, United States
0.0
0
Payment method verified
Member since Oct 4, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.