Copilot Cowork for Sales: Prompts, Plugins, and Automation That Work
Most sales tools promise to save you time. Copilot Cowork actually does it. Instead of answering one question at a time, Cowork runs entire workflows in the background: cross-referencing your emails, Teams chats, and meetings against your pipeline data, then handing you a finished analysis, brief, or deck. Sales managers are using it to surface deal risk that never makes it into the CRM, automate weekly pipeline reviews, and prep for customer meetings in seconds instead of hours.
This guide covers how to set up Cowork for sales, the Dynamics 365 Sales plugin that connects your CRM, and the exact prompts that sales teams are using right now.
New to Cowork? Start with our complete guide to understand how it works, then come back here for sales-specific workflows.
Why Cowork changes sales workflows
The core insight is simple: sales data lives everywhere. Your CRM has pipeline numbers, but the real context is in email threads, Teams calls, meeting notes, and chat messages. Before Cowork, pulling all that together meant manual work. Now you describe what you want and Cowork does the cross-referencing for you.
Cowork can rank your top accounts, draft account briefs, build pitch decks, and email account sponsors, all on a recurring weekly schedule. It can also surface the delta between what sellers say in meetings and what is actually in the CRM. That gap is where deals slip.
- Pipeline visibility without manual CRM digging. Cowork pulls from Dynamics 365, emails, Teams, and calendar to give you a complete picture.
- Meeting prep in seconds. Ask Cowork to prep you for a customer meeting and it gathers email history, deal context, competitive signals, and open action items.
- Recurring automations. Set a prompt to run every Monday morning and wake up to a finished pipeline report in your inbox.
- CRM vs reality checks. Surface discrepancies between what is logged and what is actually happening in communications.
The Dynamics 365 Sales plugin
Cowork gets powerful when you connect it to your CRM. The Dynamics 365 Sales plugin is pre-installed and enabled by default for organizations with Dynamics 365 Sales licenses. It pulls live data from your CRM, opportunities, accounts, leads, activities, and combines it with your Microsoft 365 context.
What the plugin does
- Grounded in live CRM data. Every response pulls from your actual Dynamics 365 records, not a stale snapshot.
- Respects your permissions. You only see data you are authorized to access in Dynamics 365.
- Multi-environment support. If you work across multiple D365 environments, you can select which one Cowork connects to.
- No manual lookups. Cowork automatically pulls relevant records when you mention accounts, opportunities, or contacts.
How to enable it
- Open Microsoft 365 Copilot and switch to the Cowork tab.
- In the chat composer, select the + button, then Customize.
- Turn on the toggle for Dynamics 365 Sales.
- Select the settings icon on the plugin to choose your D365 environment if you have multiple.
You need a Microsoft 365 Copilot license and a Dynamics 365 Sales license. Your admin must have the Dataverse MCP server enabled for your environment. If you do not see the plugin, check with your IT admin.
Sales prompts that work
These prompts are based on what sales teams are actually using. Replace anything in [brackets] with your own details.
Pipeline review and deal risk
The most valuable use case is surfacing what is really happening in your pipeline, not just what is logged.
Prompt
Review my pipeline for this quarter. Cross-reference each opportunity against recent emails, Teams meetings, and chats. Rank by dollar value, flag deals where activity has dropped off, and highlight any gaps between what's in the CRM and what's in communications. Give me a summary table.
Prompt
Which of my deals slipped this week and why? Look at pipeline changes, meeting notes, and email threads to find the real reasons.
Prompt
Summarize everything that changed on my top 10 opportunities since I was on leave. Include new emails, meetings, and any CRM updates.
Meeting prep
Meeting prep is where Cowork saves the most visible time. Instead of digging through emails and CRM records, you get a complete brief.
Prompt
Help me prepare for my meeting with [Account Name] tomorrow. Pull our email history, any open opportunities, recent activity in the CRM, and notes from previous meetings. Give me a one-page brief with talking points and open questions.
Prompt
Prepare me for the [Company] renewal. Surface deal risks, competitive signals, and missing stakeholders. Build a PowerPoint based on the insights.
Prompt
I have a call with [Contact Name] in an hour. What do I need to know? Check our last interactions, their role, any outstanding asks, and recent news about their company.
Lead prioritization and re-engagement
Prompt
Which leads have stopped responding in the last 30 days? For each one, suggest a re-engagement angle based on their last interaction and any company news.
Prompt
Rank my leads by likelihood to close this quarter. Factor in engagement level, deal size, and how recently they've responded to outreach.
Recurring reports and automation
This is where Cowork gets powerful for sales managers. Set a prompt to run on a schedule and wake up to finished work.
Prompt
Every Monday morning at 7am, review my team's pipeline. For each rep, summarize their top opportunities, flag any deals at risk, and note activity gaps. Email me the report before our weekly standup.
Prompt
Every Friday, create a weekly summary of closed deals, new opportunities added, and pipeline changes. Save it as a Word doc and email it to [distribution list].
Prompt
Every week, check for opportunities with no activity in the last 14 days. Draft a follow-up email for each one that matches my writing style, and save them as drafts for my review.
Account briefs and pitch decks
Prompt
Create an account brief for [Company Name]. Include company overview, key contacts, our relationship history, open opportunities, and competitive landscape. Format it as a one-pager I can share with my team.
Prompt
Build a pitch deck for [Account Name]. Pull from our previous proposals, their industry context, and any relevant case studies. Include a slide on their specific challenges based on our meeting notes.
Kickoff emails and outreach
Cowork can draft outreach that actually sounds like you by learning from your sent emails.
Prompt
Draft a kickoff email for [New Customer]. Gather context from the signed contract, implementation notes, and any handoff from sales. Match my email tone from my last 100 sent messages. Save as draft.
Prompt
For each new lead assigned to me this week, research their company and draft a personalized intro email. Pull competitive intel and key themes from recent news. Save all drafts for my review.
The CRM vs reality gap
One of the most valuable things Cowork surfaces is the gap between what is in your CRM and what is actually happening. This is the "CRM vs reality delta." Reps update the CRM with their version of events, but the real signals are in emails, meeting transcripts, and chat messages.
Cowork can cross-reference both sources and flag discrepancies: an opportunity marked as "on track" but with no response to the last three emails, or a deal marked "verbal commit" with no meeting scheduled to close. This kind of visibility used to require hours of manual review.
Tip: Ask Cowork to "show your work" when it flags deal risk. It will cite the specific emails, meetings, or CRM records it used, so you can verify before acting.
Model selection for sales tasks
Cowork lets you pick which AI model to use. For sales tasks, here is what works:
- Auto (default): Cowork picks the best model for the job. Good for most tasks.
- Opus 4.8 / Opus 4.7: Best for complex analysis, multi-source research, and tasks that require nuanced judgment. Use for pipeline reviews and deal risk analysis.
- Sonnet 4.6: Faster and cheaper. Good for routine tasks like drafting emails or simple lookups.
- Cowork 1: Cost-optimized model launching soon. Will be the cheapest option for light tasks.
For recurring prompts that run while you sleep, consider using a lighter model to keep costs down. For high-stakes meeting prep, use Opus.
Tips for sales teams
- Start with pipeline review. It is the highest-value use case and shows Cowork's power immediately.
- Set up recurring prompts. A weekly pipeline report that runs automatically is worth more than ten ad-hoc queries.
- Ask for citations. Tell Cowork to "cite your sources" so you can verify insights before acting on them.
- Connect the D365 plugin. Without it, you are missing half the context. The setup takes two minutes.
- Build a meeting prep skill. If you prep for meetings the same way every time, save it as a custom skill so you can reuse it.
What you need to get started
| Requirement | Details |
|---|---|
| Microsoft 365 Copilot license | Required for Cowork access |
| Dynamics 365 Sales license | Required for the Sales plugin |
| Cowork enabled by admin | Cowork is off by default; admin must enable it |
| Dataverse MCP server enabled | Required for the D365 plugin to access your data |
If you do not have admin access, send your IT team our admin setup guide with the steps to enable Cowork and usage-based billing.
Frequently asked questions
Does Copilot Cowork work with Salesforce?
Not directly. The Dynamics 365 Sales plugin only connects to Dynamics 365. For Salesforce, you would need to use Cowork's general capabilities (email, calendar, Teams) without CRM integration, or wait for a Salesforce connector.
How much does Cowork cost for sales use?
Cowork uses usage-based billing in Copilot Credits ($0.01 per credit) on top of your Microsoft 365 Copilot license. A pipeline review might cost a few cents; a complex multi-source analysis could cost more. See our pricing guide for details.
Can I share Cowork outputs with my team?
Yes. Cowork can save outputs to OneDrive, SharePoint, or email them directly. For recurring reports, you can have it email a distribution list automatically.
Is my CRM data safe?
Cowork operates within your existing Dynamics 365 and Microsoft 365 permissions. You only see data you are authorized to access. All processing stays within the Microsoft 365 trust boundary.
What if I work with multiple Dynamics 365 environments?
The D365 Sales plugin lets you select which environment to connect to. Open the plugin settings in Cowork and choose the environment you want to use.