F1 Data Integration System

A comprehensive system for fetching, processing, and sharing Formula 1 standings data using multiple integrations:

• F1 Data API: Fetches current driver and constructor standings
• Google Drive: Creates and shares spreadsheets
• Gmail: Sends email notifications
• Telegram: Delivers instant messages
• SSE Server: Provides real-time event updates

Core Features

• Fetch F1 standings data from official sources
• Create formatted spreadsheets in Google Drive
• Share documents via email and Telegram
• Monitor workflow events in real-time
• Set up scheduled updates and notifications

Quick Start

1. Install dependencies:

   pip install -r requirements.txt
   

2. Set up credentials (see the F1 Workflow Guide)

3. Start the required servers:

   python start_servers.py
   

4. Run the agent:

   python agent.py
   

Telegram Integration

The system can process Telegram messages like:

"Find the Current Point Standings of F1 Racers, then put that into a Google Excel Sheet, and then share the link to this sheet with me on Gmail"

When you select option 7 in the agent menu, it will:

1. Fetch current F1 standings
2. Create a Google Sheet
3. Share it with your email
4. Send a confirmation via Telegram
5. Broadcast events to the SSE server

Real-Time Monitoring

The system includes an SSE (Server-Sent Events) server that allows real-time monitoring of workflow events.

Access the monitoring dashboard at:

http://localhost:8080

Documentation

• F1 Workflow Guide - Detailed setup and usage instructions
• API Reference - API documentation for developers

Scripts

• agent.py - Main agent interface with menu-driven options
• start_servers.py - Starts all required MCP servers
• test_f1_workflow_integration.py - Tests all integrations
• f1_workflow.py - Standalone workflow implementation
• f1_schedule.py - Scheduled updates and notifications
• display_f1_standings.py - Simple script to display current standings

Architecture

The system uses a microservices-like architecture with:

• MCP servers for each integration (Gmail, GDrive, Telegram, F1, SSE)
• Agent loop for orchestrating workflows
• Event-driven communication via SSE

Requirements

• Python 3.8+
• Google API credentials (Drive & Gmail)
• Telegram Bot API token

See the F1 Workflow Guide for detailed requirements.

License

This project is available under the MIT License.