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

Pipeline Briefing — Week of 9 Jun 2026

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

Top 5 deals:

1. NCBA Group — Enterprise (KES 4.2M) · Proposal · Closes 25 Jun

2. Equity Bank — Starter x 80 seats (KES 3.1M) · Negotiation · Closes 30 Jun

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

4. KCB Group (KES 1.9M) · Demo Scheduled · Closes 28 Jun

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

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

— Barclays Kenya (KES 950K) — stuck in Negotiation for 22 days. Last activity: 18 May. Owner: James Otieno.

— UAP Old Mutual (KES 620K) — stuck in Proposal for 17 days. No recent activity. Owner: Alice Kamau.

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