Concerto

Harness team communication for hands-free project management

Comment

Inspiration

  • Project management practices often involve cumbersome manual updates and information scattered across various platforms, leading to inefficiencies, communication breakdowns, and a lack of visibility into project progress.
  • This "fog of war" hinders decision-making, delays projects, and limits learning opportunities.
  • So we wanted to build something that helps us to automate that process and improve productivity, ensure consistency and accuracy in project tracking.

What it does

A tech demonstrator to enhance project management leveraging Gemini's capabilities in accurately understanding natural language with limited data in a short amount of time, to capture task creation and updates when they happen spontaneously – during communications -- and post it on a Google Sheet.

Benefits

  1. Improved Productivity: Automating information capture reduces manual effort, allowing team members to focus on core tasks and project completion.
  2. Enhanced Communication & Visibility: Centralized project tracking and real-time updates ensure everyone is on the same page, minimizing communication gaps and the "fog of war".

How we built it

Concerto uses GetStream for chat UI and chat storage service, and NodeJS for listening/sending to chat content and fetching the Gemini API, and Google Sheet for visualization and ticket management.

Challenges we ran into

  1. Google cloud setup
  2. Initially we wanted to integrate with Google Chat, but
    • Requirements on Workspace account to interact API
    • Google AppScript is not supporting all Google’s AI product
    • lack of template on Google’s builder platforms like Cloud Function hindered our progress
  3. Return stable JSON with field on return result(will be fun to explore GraphQL-like notation)

Accomplishments that we're proud of

What we learned

What's next for Concerto

  1. Integration across G Suite apps (i.e. Chat, Meet, Drive, Doc, Slide, Sheet) to unleash the full potential of automation
    • Transcribe and include meeting notes as part of the source data
  2. Improvements on UX
    • In-line interactions in messaging to collaboratively manage tickets (e.g. use reactions to confirm or discard tickets)
    • Point to source data in Google Chat history
    • Support for file analysis
    • More intuitive presentation/format of project information
  3. End-to-end encryption to guarantee privacy

Built With

Share this project:

Updates