How to Connect Microsoft Dynamics 365 to ChatGPT

You connect Microsoft Dynamics 365 to ChatGPT by installing Windsor’s native ChatGPT app, then linking your Dynamics 365 account through Windsor.ai using the Dynamics 365 connector. Once connected, ChatGPT can read your live account data directly, no CSV exports or custom code required.

Pulling Dynamics 365 data into a report usually means exporting Account views to Excel or building a dashboard, then repeating that work every time you need an update. Connecting through Windsor’s native app skips that step: ChatGPT queries your Dynamics 365 account data on demand, so you can ask questions in plain language instead of manually exporting records.

2 steps to connect Microsoft Dynamics 365 to ChatGPT

Takes under a minute, no code or manual CSV work required.

See the full walkthrough in Windsor’s documentation on integrating data into ChatGPT.

Prerequisites

• A Windsor.ai account (free forever plan, or paid from $19/month)
• A Microsoft Dynamics 365 account with at least one Account record set up
• A ChatGPT account with access to apps and connectors

Step 1. Connect Microsoft Dynamics 365 to Windsor.ai

• Create a free Windsor.ai account, or sign in, at onboard.windsor.ai/app/dynamics365
• Select Microsoft Dynamics 365 from the list of data sources
• Sign in to your Microsoft account and authorize Windsor.ai to access your Dynamics 365 data
• Connect additional Dynamics 365 environments the same way if you manage more than one

Step 2. Connect the Windsor.ai app in ChatGPT

In ChatGPT, open the apps and connectors settings, search for Windsor.ai, and install it. This is a native one-click install, there is no URL to paste and no custom connector setup.

Approve the permissions request so ChatGPT can read the data flowing through your Windsor.ai account.

Once approved, the Windsor.ai app shows up as a connected app inside ChatGPT.

Confirm the connection works by asking ChatGPT:

List the data sources connected to my Windsor account. Do you see Dynamics 365 there?

If Dynamics 365 shows up in the list, you’re set. You can now ask ChatGPT about your Dynamics 365 data in plain language.

The metrics that matter for Microsoft Dynamics 365

Metric	What it tells you
Opportunity – Estimatedvalue	The projected value of an open deal before it closes, the number sales forecasts are usually built on.
Opportunity – Actualvalue	The confirmed revenue amount once a deal is marked won, your real bookings figure.
Opportunity – Salesstage	Which stage of your sales process a deal currently sits in, from qualify through close.
Opportunity – Closeprobability	The likelihood, as a percentage, that an open deal will close successfully.
Opportunity – Estimatedclosedate	When a rep expects a deal to close, the date forecasts and pipeline reviews get built around.
Lead – Leadsourcecode	Which channel or campaign originally generated a given lead, the starting point for source attribution.
Lead – Estimatedvalue	The projected deal value tied to a lead, before it’s even qualified into a full opportunity.
Lead – Statuscode	A lead’s current qualification status: open, qualified, or disqualified.
Campaign – Expectedrevenue	The revenue a marketing campaign was projected to generate when it was planned.
Campaign – Totalactualcost	What a campaign actually cost to run, the number you weigh against expected revenue to judge ROI.
Account – Aging90	How much of an account’s balance is more than 90 days overdue, a key signal of collection risk.
Account – Accountratingcode	The internal rating your team has assigned an account, e.g. how strategically important it is.

What to ask ChatGPT: prompt ideas

Pipeline and opportunity performance

Show me all open opportunities by sales stage, with estimated value and close probability, sorted by estimated close date.

Which opportunities have a close probability above 70% and an estimated close date in the next 30 days?

Campaign activity tracking

Compare actual cost against budgeted cost for each campaign and flag any campaign that ran over budget.

Account and lead conversion

Break down my leads by lead source code and status code, and show the total estimated value tied to each source.

List accounts with an aging90 balance above zero alongside their account rating code, so I can see which top-rated accounts have overdue balances.

The Dynamics 365 connection through Windsor is read-only, verified live: Windsor’s write actions currently cover Meta Ads, Google Ads, TikTok Ads, LinkedIn Ads, Microsoft Ads, Instagram, Google Business Profile, Klaviyo, and Amazon Seller Central, and Dynamics 365 isn’t on that list, so use it to analyze and report on your CRM data rather than to edit records.

Bonus: analyze Microsoft Dynamics 365 alongside your full stack

Windsor connects 350+ sources, so Microsoft Dynamics 365 doesn’t have to live in its own silo. A few realistic blends:

• True sales-qualified CAC. Blend closed-won opportunity value from Dynamics 365 with spend from Google Ads and Facebook Ads to see what you’re really paying to acquire an account that turns into revenue, not just a click or a lead.
• Lead-source-to-close attribution. Pair Dynamics 365 lead source and opportunity stage data with GA4 session data to trace which marketing channels actually produce leads that turn into closed deals, not just traffic.
• Full-funnel marketing view. Combine Dynamics 365 campaign and lead data with your email marketing or marketing automation platform to see the whole funnel, from first touch to qualified lead to closed opportunity, in one conversation.

Other ways to connect Microsoft Dynamics 365 to ChatGPT

Manual CSV export

You can export Account views from Dynamics 365 to CSV or Excel and upload the file into a ChatGPT conversation. That works for a one-off question, but it’s a static snapshot the moment you download it, so every follow-up question needs a fresh export.

Zapier or Make

Zapier and Make can move Dynamics 365 records into another tool as part of a still-maintained workflow, which works if you already have automations built around them. Neither gives ChatGPT a live view of your Dynamics 365 data the way the direct Windsor connector does.

Conclusion

Connecting Microsoft Dynamics 365 to ChatGPT through Windsor’s native app takes two steps and no code: link Dynamics 365 to Windsor.ai, then install the Windsor.ai app in ChatGPT. From there you can ask about your account data in plain language and blend it with any of Windsor’s other 350+ connected sources.

🚀 Ready to connect Microsoft Dynamics 365 to ChatGPT? Connect Microsoft Dynamics 365 to Windsor.ai now and start asking ChatGPT about your account data today.