🚀 Omni-Channel Customer Success Intelligence Platform

Salesforce Lightning ⚡ Google Cloud Platform ☁️ Slack Enterprise 💬 Snowflake DWH ❄️ Google Gemini 3.6 Flash 🧠

🌟 Executive Overview

The Omni-Channel Customer Success Intelligence Platform is an enterprise-grade, event-driven solution that unifies Salesforce Lightning CRM, Google Cloud Platform, Slack Enterprise, Snowflake Cloud Data Warehouse, and Google AI Studio (Gemini 3.6 Flash) into a single, cohesive customer success copilot.

Customer Success Managers (CSMs) and Account Executives (AEs) operate with complete workflow continuity across Salesforce record pages, Slack channels, and private direct messages—with zero platform friction, zero brand leakage, and strict enterprise security guardrails.

🏛️ Grand Unified Architecture

graph TD
    subgraph SF_PLATFORM["Salesforce Lightning Platform (CRM)"]
        LWC_BOT["slackBotAgent (LWC)<br/>• Left Thread History<br/>• User Privacy Isolation<br/>• Native Desktop Alerts<br/>• Slash Commands Palette"]
        LWC_GMAIL["accountGmail (LWC)<br/>• Split-Pane Reader<br/>• RFC 2822 Header Threading<br/>• Whole Thread AI Summary"]
        LWC_CAL["accountGoogleCalendar (LWC)<br/>• Meeting Scheduler<br/>• Auto Google Meet Link<br/>• Event Type Isolation"]
        
        CTRL_BOT["SlackBotAgentController.cls<br/>& SlackUserIdentityService.cls"]
        CTRL_GMAIL["AccountGmailController.cls<br/>& AccountGmailInboundHandler.cls"]
        CTRL_CAL["AccountCalendarController.cls<br/>& GoogleAuthService.cls (JWT)"]
        
        MCP_SERVER["LearnDCAgentMCPServer.cls<br/>(Apex Invocable MCP Server)<br/>• search_accounts<br/>• query_snowflake<br/>• create_account_task"]
        
        LWC_BOT --> CTRL_BOT
        LWC_GMAIL --> CTRL_GMAIL
        LWC_CAL --> CTRL_CAL
        CTRL_BOT --> MCP_SERVER
    end

    subgraph GCP_CLOUDRUN["Google Cloud Platform (slack-gemini-agent)"]
        GATEWAY["Express HTTP Gateway (Port 8080)<br/>• GET /auth/login<br/>• POST /auth/slack/confirm<br/>• POST /api/chat<br/>• GET /health"]
        CONSENT_UI["Slack Workspace Consent Screen<br/>(Branded User Authorization UI)"]
        GEMINI_ENGINE["Google AI Studio Gemini 3.6 Flash<br/>• Multi-turn Session Manager<br/>• Autonomous Tool Loop"]
        SNOW_DAEMON["SnowflakeSyncDaemon.ts<br/>• Continuous 5s Bi-Directional Sync<br/>• 0s On-Demand SLA Reconciliation"]
        
        GATEWAY --> CONSENT_UI
        GATEWAY --> GEMINI_ENGINE
        GATEWAY --> SNOW_DAEMON
    end

    subgraph SLACK_WORKSPACE["Slack Enterprise Workspace (T0BU7EDE40P)"]
        SOCKET_MODE["Socket Mode WebSocket (wss://)<br/>• No Public Ports / Ngrok<br/>• Outbound Persistent Tunnel"]
        SLACK_BOT["Slack App: test_agent_app<br/>(App ID: A0BU7FHCFEK)"]
        SLASH_CMDS["Slash Commands Engine<br/>• /account-brief (3s ack)<br/>• /summarize-thread<br/>• /snowflake<br/>• /help"]
        PRIVATE_DMS["Private 1-on-1 DMs<br/>(conversations.open per CSM)"]
        
        SOCKET_MODE --> SLACK_BOT
        SLACK_BOT --> SLASH_CMDS
        SLACK_BOT --> PRIVATE_DMS
    end

    subgraph SNOWFLAKE_DWH["Snowflake Cloud Data Warehouse (hjyxziv-mi58790)"]
        BASE_ANALYTICS[("LEARNDC_DB.ANALYTICS<br/>ACCOUNT_ANALYTICS<br/>(Base Table - 5s Sync)")]
        SECURE_MCP[("LEARNDC_MCP_DB.SECURE_ANALYTICS<br/>V_ACCOUNT_INSIGHTS<br/>(8 Sanitized Telemetry Fields)")]
        MCP_ROLE["Role: MCP_AGENT_READER_ROLE<br/>• Least-Privilege Read-Only<br/>• Key-Pair RSA Authentication"]
        
        BASE_ANALYTICS --> SECURE_MCP
        SECURE_MCP --> MCP_ROLE
    end

    subgraph GOOGLE_WORKSPACE["Google Workspace Services"]
        GMAIL_SVC["Gmail API & Inbound Relay<br/>(RFC 2822 Headers & csm-reply@...)"]
        GCAL_SVC["Google Calendar API v3<br/>& Google Meet Video Link Generator"]
        GPUSH_SVC["Google Push Notifications Webhook<br/>(Delta Sync with syncToken)"]
    end

    CTRL_BOT <==>|Fast Identity & REST Invocable| GATEWAY
    GATEWAY <==>|Socket Mode wss://| SOCKET_MODE
    GEMINI_ENGINE <==>|Autonomous Function Calling| MCP_SERVER
    SNOW_DAEMON <==>|MERGE INTO & Telemetry Writeback| BASE_ANALYTICS
    GEMINI_ENGINE <==>|Read-Only Parameterized SQL| SECURE_MCP
    CTRL_GMAIL <==>|Inbound & Outbound Dual Delivery| GMAIL_SVC
    CTRL_CAL <==>|RSA JWT Bearer & Webhook Push| GCAL_SVC
    GPUSH_SVC -->|Delta Notification Ping| CTRL_CAL

⚡ Key Core Capabilities & Architectural Pillars

1. 🤖 Omni-Channel Slack Bot Agent & LWC Copilot (`slackBotAgent`)

Headless AI Agent Architecture: Single primary Gemini 3.6 Flash engine powers both Slack and the Salesforce Account LWC.
Left Sidebar Thread History: Scoped by Account and strictly isolated by user (CreatedById = :currentUserId). Users never see other reps' private chats.
Activity Timeline Hygiene: General chats never flood Salesforce with dummy tasks. Salesforce Task records are only created with explicit parameters and an intentional user confirmation modal.
Slack Deep Links (Slack ↗): One-click navigation to the exact persistent Slack thread in desktop or web.
Hybrid High-Availability Fallback: Automatic failover from Node.js Gateway to native Apex MCP Server if the gateway is ever offline.

2. 📬 Domain-Free Bidirectional Gmail Threading

Overcomes Domain & Admin Restrictions: Bypasses corporate Google Workspace domain verification and daily developer email limits.
RFC 2822 Inbound & Outbound Header Engine: Injects Message-ID, In-Reply-To, and References headers, ensuring native Gmail thread grouping.
Dual-Delivery Routing: Automatically delivers to the customer and mirrors to the CSM's personal inbox (skgsummo5@gmail.com).
Whole-Thread AI Summarizer: Gemini 3.6 Flash analyzes entire conversation chains to produce an executive summary, discussion highlights, and action items, cached in Gmail_Thread_Summary__c.

3. 📅 Real-Time Google Calendar & Meet Sync

Enterprise JWT Bearer Authentication: Apex crafts RSA-SHA256 signed JWT assertion tokens for Google Workspace Domain-Wide Delegation.
Google Meet Auto-Generation: Seamlessly generates and binds Google Meet video links (https://meet.google.com/...) upon booking.
Push Webhook Delta-Syncing: Inbound changes from Google Calendar trigger webhook pings, processed via queueable jobs using syncToken to eliminate infinite loops.
Event Type Isolation: Calendar meetings and email interactions maintain strict type separation on the standard Event object.

4. ⌨️ Slack Slash Commands Engine (`/account-brief`, etc.)

3-Second Acknowledgment Rule: Immediate await ack() prevents Slack operation_timeout errors.
360° Account Briefing (/account-brief): Parallel retrieval of Salesforce CRM vitals, Snowflake telemetry, and Gmail thread intelligence in an executive Block Kit card.
Dynamic Thread Summarization (/summarize-thread): Extracts critical action items from email chains on demand.
Snowflake Telemetry (/snowflake): Direct read of warehouse health scores and compute hours.

5. 🔔 Native OS Desktop Notifications & Background Alerts

Page Visibility API: Detects when the user minimizes the browser or multitasks in another tab (document.hidden === true).
HTML5 Web Notification API: Dispatches native Windows 11 / macOS desktop toast cards with sound and Salesforce cloud branding.
One-Click Tab Focus: Clicking the notification instantly brings the browser tab to the front.
Tab Title Pulsing: Alternates tab title with 🔔 (1) New Reply Ready | Salesforce until focused.

6. ❄️ Snowflake Two-Tier Bi-Directional Sync & Secure MCP View

Tier 1 (5s Daemon): SnowflakeSyncDaemon.ts continuously syncs modified Accounts to LEARNDC_DB.ANALYTICS.ACCOUNT_ANALYTICS and writes back telemetry.
Tier 2 (Secure MCP): Dedicated database LEARNDC_MCP_DB and Secure View V_ACCOUNT_INSIGHTS restrict access to strictly 8 sanitized telemetry fields.
Least-Privilege Role: MCP_AGENT_READER_ROLE with key-pair RSA authentication and zero DML/DDL permissions.
Zero Platform Brand Leakage: AI synthesizes unified dossiers without exposing vendor names to business users.

7. 🔐 Multi-User Identity & OAuth Consent Handshake

Frictionless Onboarding: Clicking "Sign in with Slack" opens a secure popup to the GCP Gateway (/auth/login).
User Authorization Screen: Presents a branded Slack Workspace Consent Screen detailing permissions.
Automated DM Channel Provisioning: POST /auth/slack/confirm creates a dedicated 1-on-1 private channel (conversations.open) and updates the Salesforce User record in <5ms.

📂 Repository Structure

├── force-app/main/default/              # Salesforce DX Metadata
│   ├── classes/                         # Apex Controllers, Services & Tests (100% Pass)
│   │   ├── SlackBotAgentController.cls  # LWC Copilot Controller & Session Resumption
│   │   ├── SlackUserIdentityService.cls # User Identity Resolver & Auth URL Generator
│   │   ├── AccountGmailController.cls   # Gmail Split-Pane Backend Controller
│   │   ├── AccountGmailInboundHdlr.cls  # Inbound RFC 2822 Email Service Handler
│   │   ├── GmailAIService.cls           # Whole Thread Gemini AI Summarizer
│   │   ├── AccountCalendarCtrl.cls      # Google Calendar Meeting Scheduler
│   │   ├── GoogleAuthService.cls        # RSA-SHA256 JWT Bearer Assertion Generator
│   │   ├── GoogleCalendarService.cls    # Google Calendar API v3 Callout Engine
│   │   ├── GoogleCalendarQueueable.cls  # Delta-Syncing Webhook Queueable Job
│   │   └── LearnDCAgentMCPServer.cls    # Apex Invocable MCP Server Provider
│   └── lwc/                             # Lightning Web Components
│       ├── slackBotAgent/               # AI Copilot Cockpit & Notification Controller
│       ├── accountGmail/                # Master-Detail Split-Pane Conversation Reader
│       └── accountGoogleCalendar/       # Interactive Meeting Scheduler with Meet Link
├── slack-gemini-agent/                  # Google Cloud Platform Node.js/TS Middleware
│   ├── src/
│   │   ├── index.ts                     # Express HTTP Server & Socket Mode Entry Point
│   │   ├── api/auth.ts                  # OAuth Handshake & Consent Screen Controller
│   │   ├── bot/slackBot.ts              # Slack Bolt Framework Event Orchestration
│   │   ├── commands/slashCommands.ts    # Slash Command Handlers (/account-brief, etc.)
│   │   ├── services/geminiService.ts    # Google AI Studio Gemini 3.6 Flash Interface
│   │   ├── services/snowflakeDaemon.ts  # 5-Second Real-Time Salesforce <-> Snowflake Sync
│   │   └── mcp/                         # Model Context Protocol Client Implementations
│   ├── Dockerfile                       # Multi-stage Container Runtime
│   └── package.json                     # Node.js Dependencies & Build Scripts
├── docs/                                # Technical Markdown Documentation
└── docs-html/                           # Interactive HTML Documentation with Mermaid & SVGs

📚 Documentation Library

Every architectural component is documented with both a Markdown specification and an interactive HTML guide featuring embedded SVG illustrations and Mermaid diagrams:

Documentation Topic	Markdown Guide (`docs/`)	Interactive HTML Guide (`docs-html/`)
⭐ Grand Unified Master Playbook	`MASTER_SALESFORCE_INTEGRATION_GUIDE.md`	`MASTER_SALESFORCE_INTEGRATION_GUIDE.html`
☁️ GCP Slackbot & Salesforce MCP Setup	`GCP_SLACKBOT_MCP_SETUP_GUIDE.md`	`GCP_SLACKBOT_MCP_SETUP_GUIDE.html`
📬 Gmail Real-Time Bidirectional Sync	`SALESFORCE_GMAIL_INTEGRATION.md`	`SALESFORCE_GMAIL_INTEGRATION.html`
📅 Google Calendar & Meet Booking	`SALESFORCE_GOOGLE_CALENDAR_INTEGRATION.md`	`SALESFORCE_GOOGLE_CALENDAR_INTEGRATION.html`
🤖 Slack & Google AI Studio Integration	`SALESFORCE_SLACK_GOOGLE_AI_STUDIO_INTEGRATION.md`	`SALESFORCE_SLACK_GOOGLE_AI_STUDIO_INTEGRATION.html`
❄️ Snowflake Two-Tier Bi-Directional DWH	`SALESFORCE_SNOWFLAKE_INTEGRATION.md`	`SALESFORCE_SNOWFLAKE_INTEGRATION.html`
💬 Slack Bot Agent LWC Architecture	`SLACK_BOT_AGENT_LWC_INTEGRATION.md`	`SLACK_BOT_AGENT_LWC_INTEGRATION.html`
⌨️ Slack Slash Commands Implementation	`SLACK_SLASH_COMMANDS_GUIDE.md`	`SLACK_SLASH_COMMANDS_GUIDE.html`
🔔 Native OS Desktop Notifications	`LWC_DESKTOP_NOTIFICATIONS_INTEGRATION.md`	`LWC_DESKTOP_NOTIFICATIONS_INTEGRATION.html`
🔌 Snowflake Model Context Protocol (MCP)	`SNOWFLAKE_MCP_INTEGRATION_GUIDE.md`	`SNOWFLAKE_MCP_INTEGRATION_GUIDE.html`

🛠️ Quick Start & Local Setup

1. Prerequisites

Node.js: v20.x or v22.x+
Salesforce CLI (sf): v2.x+
Docker (Optional, for containerized local runtime)

2. Salesforce Deployment

Deploy the metadata to your target org:

sf project deploy start -o <your-org-alias>

Run the test suite to verify 100% test pass rate:

sf apex run test -n "SlackBotAgentControllerTest,SlackUserIdentityServiceTest" -o <your-org-alias> -r human -c

3. Middleware Service Configuration

Navigate to slack-gemini-agent and configure environment variables:

cd slack-gemini-agent
cp .env.example .env

Fill in your secrets:

PORT=8080
GEMINI_API_KEY=your_gemini_api_key
SLACK_BOT_TOKEN=xoxb-...
SLACK_SIGNING_SECRET=your_signing_secret
SLACK_APP_TOKEN=xapp-...
SF_LOGIN_URL=https://login.salesforce.com
SF_CLIENT_ID=your_connected_app_client_id
SF_CLIENT_SECRET=your_connected_app_client_secret
SF_USERNAME=your_salesforce_username
SF_PASSWORD=your_password_and_token
SNOWFLAKE_ACCOUNT=your_snowflake_account
SNOWFLAKE_USERNAME=LEARNDC_MCP_AGENT
SNOWFLAKE_PRIVATE_KEY_PATH=./secrets/rsa_key.p8
SNOWFLAKE_DATABASE=LEARNDC_MCP_DB
SNOWFLAKE_SCHEMA=SECURE_ANALYTICS
SNOWFLAKE_ROLE=MCP_AGENT_READER_ROLE

Install dependencies and start the service:

npm install
npm run build
npm run start

🛡️ Enterprise Security & Quality Certification

Zero Brand Leakage: Business users interact with a unified AI persona without underlying infrastructure seams.
Least-Privilege Security: Snowflake access is restricted to read-only views with key-pair authentication.
Privacy Isolation: User chat histories in Salesforce are scoped by CreatedById, preventing cross-rep data leaks.
Activity Hygiene: Chat messages do not pollute CRM timelines with unnecessary tasks.
Production Certified: Verified with 100% Apex test coverage across all controller and service classes.

👤 Author & Support

Lead Engineer & Architect: Summo CSM (skgsummo5@gmail.com)
Organization: Teqfocus Solutions / Learn DC Enterprise Architecture

Name		Name	Last commit message	Last commit date
.husky		.husky
.vscode		.vscode
config		config
docs-html		docs-html
docs		docs
force-app/main/default		force-app/main/default
manifest		manifest
scripts		scripts
shareable_file		shareable_file
slack-gemini-agent		slack-gemini-agent
.forceignore		.forceignore
.gitignore		.gitignore
.graphqlrc.yml		.graphqlrc.yml
.prettierignore		.prettierignore
.prettierrc		.prettierrc
README.md		README.md
eslint.config.js		eslint.config.js
jest.config.js		jest.config.js
package.json		package.json
sfdx-project.json		sfdx-project.json

Navigation Menu

Repository navigation

About

Repository files navigation

🚀 Omni-Channel Customer Success Intelligence Platform

Salesforce Lightning ⚡ Google Cloud Platform ☁️ Slack Enterprise 💬 Snowflake DWH ❄️ Google Gemini 3.6 Flash 🧠

🌟 Executive Overview

🏛️ Grand Unified Architecture

⚡ Key Core Capabilities & Architectural Pillars

1. 🤖 Omni-Channel Slack Bot Agent & LWC Copilot (`slackBotAgent`)

2. 📬 Domain-Free Bidirectional Gmail Threading

3. 📅 Real-Time Google Calendar & Meet Sync

4. ⌨️ Slack Slash Commands Engine (`/account-brief`, etc.)

5. 🔔 Native OS Desktop Notifications & Background Alerts

6. ❄️ Snowflake Two-Tier Bi-Directional Sync & Secure MCP View

7. 🔐 Multi-User Identity & OAuth Consent Handshake

📂 Repository Structure

📚 Documentation Library

🛠️ Quick Start & Local Setup

1. Prerequisites

2. Salesforce Deployment

3. Middleware Service Configuration

🛡️ Enterprise Security & Quality Certification

👤 Author & Support

About

Releases

Packages

Contributors

Languages

Latest commit

History

Folders and files

Repository files navigation

🚀 Omni-Channel Customer Success Intelligence Platform

Salesforce Lightning ⚡ Google Cloud Platform ☁️ Slack Enterprise 💬 Snowflake DWH ❄️ Google Gemini 3.6 Flash 🧠

🌟 Executive Overview

🏛️ Grand Unified Architecture

⚡ Key Core Capabilities & Architectural Pillars

1. 🤖 Omni-Channel Slack Bot Agent & LWC Copilot (slackBotAgent)

2. 📬 Domain-Free Bidirectional Gmail Threading

3. 📅 Real-Time Google Calendar & Meet Sync

4. ⌨️ Slack Slash Commands Engine (/account-brief, etc.)

5. 🔔 Native OS Desktop Notifications & Background Alerts

6. ❄️ Snowflake Two-Tier Bi-Directional Sync & Secure MCP View

7. 🔐 Multi-User Identity & OAuth Consent Handshake

📂 Repository Structure

📚 Documentation Library

🛠️ Quick Start & Local Setup

1. Prerequisites

2. Salesforce Deployment

3. Middleware Service Configuration

🛡️ Enterprise Security & Quality Certification

👤 Author & Support

About

Topics

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors

Languages

1. 🤖 Omni-Channel Slack Bot Agent & LWC Copilot (`slackBotAgent`)

4. ⌨️ Slack Slash Commands Engine (`/account-brief`, etc.)