How arunmanikandan-c/ai_sheets_does_mail_workauto works
Cloud Orchestrator is a browser dashboard backed by FastAPI for authenticated Google Workspace operations. The main workflow is Google sign-in, then browse or create Drive files, edit Docs or Sheets, and view or send Gmail messages; an AI agent provides an additional conversational workflow. The graph reflects documented capabilities and sampled calls; some router and agent details are only partially shown, so uncertain internal wiring is omitted.
Main entry points: main.py FastAPI app · app.js App coordinator · dependencies.py Google clients · drive.js Drive browser
Components 23
Web dashboard
- Dashboard shell
frontend/index.html - App coordinator
frontend/app.js - Sign-in
frontend/js/auth.js - Drive browser
frontend/js/drive.js - Folder tree
frontend/js/folder_tree.js - Docs actions
frontend/js/docs.js - Sheets actions
frontend/js/sheets.js - Gmail inbox
frontend/js/gmail.js - Agent chat
frontend/js/agent.js - Client state
frontend/js/state.js
API backend
- FastAPI app
backend/main.py - Quota middleware
backend/rate_limiter.py - System routes
backend/routers/system.py
Workspace services
- Drive routes
backend/routers/drive.py - Docs routes
backend/routers/docs.py - Sheets routes
backend/routers/sheets.py - Gmail routes
backend/routers/gmail.py - Google clients
backend/dependencies.py
AI assistant
- Agent routes
backend/routers/agent.py
Other components
- Workspace user
- Google APIs
- Gemini API
- Firebase Auth
Connections 31
- Workspace user → Dashboard shell: opens dashboard
- Dashboard shell → App coordinator: loads interface
- App coordinator → Sign-in: initializes sign-in
- Sign-in → Firebase Auth: authenticates with
- Sign-in → Client state: stores token
- App coordinator → Drive browser: loads files
- App coordinator → Gmail inbox: loads inbox
- App coordinator → Folder tree: loads folders
- App coordinator → Agent chat: initializes chat
- Drive browser → Drive routes: requests file list
- Folder tree → Drive routes: requests folders
- Drive browser → Docs actions: opens document actions
- Drive browser → Sheets actions: opens sheet actions
- Docs actions → Docs routes: creates or appends
- Sheets actions → Sheets routes: creates or appends
- Gmail inbox → Gmail routes: reads or sends mail
- Agent chat → Agent routes: sends chat request
- FastAPI app → Quota middleware: limits API requests
- FastAPI app → Drive routes: dispatches routes
- FastAPI app → Docs routes: dispatches routes
- FastAPI app → Sheets routes: dispatches routes
- FastAPI app → Gmail routes: dispatches routes
- FastAPI app → Agent routes: dispatches routes
- FastAPI app → System routes: dispatches routes
- Drive routes → Google clients: builds API clients
- Docs routes → Google clients: builds API clients
- Sheets routes → Google clients: builds API clients
- Gmail routes → Google clients: builds API client
- Agent routes → Google clients: builds Workspace clients
- Google clients → Google APIs: calls Workspace APIs
- Agent routes → Gemini API: calls model API