Salesforce & Microsoft Teams Integration for Sales Teams

Comparison matrix

ROI metrics

Integrating Salesforce CDC with Microsoft Teams provides immediate ROI within 4 weeks by eliminating daily sync standups and manual deal notifications for a 10-person sales team.

Step-by-step setup guide

1. 1.Enable Change Data Capture in Salesforce

   Navigate to Setup > Integrations > Change Data Capture in Salesforce. Move 'Opportunity' from Available Entities to Selected Entities. This automatically exposes real-time streaming events on the '/data/OpportunityChangeEvent' bus.

   /* Validated via Salesforce Tooling API */
   GET /services/data/v60.0/tooling/query/?q=SELECT+Id,DeveloperName+FROM+PlatformEventChannelMember+WHERE+EventChannel='ChangeEvents'

2. 2.Provision an Azure AD App Registration for Graph API

   In the Microsoft Entra admin center, register a new application. Add Application permissions for 'ChannelMessage.Send' and 'Teamwork.Migrate.All' under Microsoft Graph. Generate a client secret and record the Directory (Tenant) ID, Application (Client) ID, and secret value.

   curl -X POST https://login.microsoftonline.com/{tenant-id}/oauth2/v2.0/token \
     -H 'Content-Type: application/x-www-form-urlencoded' \
     -d 'client_id={client-id}&scope=https%3A%2F%2Fgraph.microsoft.com%2F.default&client_secret={client-secret}&grant_type=client_credentials'

3. 3.Create an Incoming Webhook Connector in Microsoft Teams

   Open the target deal room channel in Microsoft Teams, select 'Connectors' from the channel settings, add 'Incoming Webhook', configure the display name to 'Salesforce Deal Bot', and capture the generated webhook URL.

   https://yourorg.webhook.office.com/webhookb2/xxxx-xxxx/IncomingWebhook/yyyy/zzzz

4. 4.Configure Apex Callout or Middleware Worker

   Deploy an Apex trigger on OpportunityChangeEvent or a Node.js/Python listener consuming the Salesforce Pub/Sub API. Map the Opportunity data into an actionable Microsoft Adaptive Card JSON payload.

   trigger OpportunityCDC on OpportunityChangeEvent (after insert) {
     for (OpportunityChangeEvent event : Trigger.new) {
       EventBus.ChangeEventHeader header = event.ChangeEventHeader;
       if (header.changetype == 'UPDATE' && event.StageName != null) {
         SalesforceTeamsDispatcher.sendCard(event.StageName, event.Amount, header.getRecordIds());
       }
     }
   }

5. 5.Post the Formatted Adaptive Card to Teams Channel

   Dispatch the formatted HTTP POST payload directly to the Teams Webhook URL or execute via Graph API POST to /v1.0/teams/{team-id}/channels/{channel-id}/messages.

   curl -X POST https://yourorg.webhook.office.com/webhookb2/xxxx-xxxx/IncomingWebhook/yyyy/zzzz \
     -H 'Content-Type: application/json' \
     -d '{"type":"message","attachments":[{"contentType":"application/vnd.microsoft.card.adaptive","content":{"$schema":"http://adaptivecards.io/schemas/adaptive-card.json","type":"AdaptiveCard","version":"1.4","body":[{"type":"TextBlock","text":"Sales Alert: Opportunity Won!","weight":"Bolder","size":"Medium"}]}}]}'

Webhook payload example

{
  "schema": "N6g0XjWn9Vw4YkF7Jd1wLg",
  "payload": {
    "ChangeEventHeader": {
      "commitTimestamp": 1716912000000,
      "transactionKey": "0002b0c9-044d-f684-2f08-3e4b771e892c",
      "commitUser": "0055e000000XyZaAAK",
      "commitNumber": 1048576,
      "entityName": "Opportunity",
      "changeType": "UPDATE",
      "changeOrigin": "com/salesforce/api/soap/59.0",
      "recordIds": ["0065e000002A1bCAAS"]
    },
    "Name": "Acme Corp - Enterprise Expansion",
    "Amount": 120000.0,
    "StageName": "Closed Won",
    "Probability": 100.0,
    "CloseDate": "2024-05-31"
  },
  "event": {
    "replayId": 48102
  }
}

FAQ