Teams Summary

Status: Completed

Teams Summary is a PHP-based web application that automatically generates a daily digest of Microsoft Teams activity. It connects with Microsoft Graph API to collect overnight chats, mentions, and shared files, then leverages OpenAI API to summarize discussions, extract action items, and highlight key decisions. The digest is stored in MySQL and delivered to team members via email using SMTP, ensuring teams start their day fully aligned.

Key Features

  • πŸ”— Microsoft Teams Integration – Retrieves chat activity, mentions, and file updates using Microsoft Graph API.
  • πŸ€– AI Summarization – OpenAI API generates concise summaries with key points and actionable items.
  • πŸ’Ύ Data Storage – Activity logs and digests are saved in MySQL for tracking and analytics.
  • πŸ“§ Automated Notifications – Daily digest sent via SMTP email in a clean, formatted template.
  • ⏰ Scheduling – Cron jobs trigger the summarization and notification process automatically.
  • πŸ“Š Web Dashboard – Simple PHP-based dashboard for reviewing past summaries and managing settings.

Tech Stack

  • Backend: PHP
  • Database: MySQL
  • APIs: Microsoft Graph API, OpenAI API
  • Notifications: SMTP (email delivery)
  • Automation: Cron jobs for daily scheduling