Monday pipeline summary in Copilot

Start every Monday with a CRM-fresh pipeline briefing posted directly to your Sales channel. One Copilot prompt pulls live Salesforce data and posts the summary to Teams. No dashboard tabs, no exports.

Connectors used
Salesforce Microsoft Teams
Works with
Copilot Claude
Best run Monday morning, manually or on a schedule

The problem

Sales managers spend the first hour of Monday pulling pipeline reports from Salesforce, formatting them, and pasting into a Teams message or email. With Salesforce and Teams connected to Msharti, this is one sentence to Copilot, and it posts itself.

The prompt

Paste this into Microsoft Copilot on Monday morning 
Pull our Salesforce pipeline for deals closing this month. Include: total pipeline value, number of deals, top 5 deals by value with their current stage and close date, and any deals that have been stuck in the same stage for more than 2 weeks. Format it as a clean weekly briefing and post it to the Sales channel in Teams.

What fires

  • soql_query (Salesforce): queries all opportunities closing this month, ordered by amount, with stage and last activity date
  • A second soql_query: identifies deals where stage hasn't changed in 14+ days
  • post_message (Teams): posts the formatted briefing to the specified channel

What comes back in Teams

Company names and figures below are sample data.

Pipeline Briefing: Week of 9 Jun 2026

Total pipeline (closing this month): KES 18.4M across 14 deals

Top 5 deals:

1. Acacia Manufacturing: Enterprise (KES 4.2M) · Proposal · Closes 25 Jun

2. Rift Valley Traders: Starter x 80 seats (KES 3.1M) · Negotiation · Closes 30 Jun

3. Coastline Holdings (KES 2.8M) · Presentation · Closes 20 Jun

4. Highland Logistics (KES 1.9M) · Demo Scheduled · Closes 28 Jun

5. Tana Foods (KES 1.4M) · Qualification · Closes 15 Jun

Stuck deals (14+ days, no stage change):

· Sunrise Supplies (KES 950K), stuck in Negotiation for 22 days. Last activity: 18 May. Owner: regional sales lead.

· Meridian Insurance (KES 620K), stuck in Proposal for 17 days. No recent activity. Owner: account manager.

Variations

  • Summarise deals that closed last week in Salesforce and post the win/loss summary to the Sales-Wins Teams channel
  • Pull all accounts with no activity in the last 30 days from Salesforce and post a re-engagement list to Teams
  • Every Friday: pull the 5 deals most likely to close by month-end and post to the Sales channel with a risk flag if any have been stalled