Connect Microsoft Dynamics 365 to AI, Sheets, Databases & BI Tools
Windsor.ai's Microsoft Dynamics 365 connector extracts your Microsoft Dynamics 365 data and syncs it to AI assistants like ChatGPT, Claude and Gemini, spreadsheets like Google Sheets and Excel, data warehouses like BigQuery, Snowflake and PostgreSQL, and BI tools like Looker Studio, Power BI and Tableau. Setup takes a few minutes in the browser, no coding required, and you can start for free, no credit card required.
How to connect Microsoft Dynamics 365 to Windsor.ai
- Create your free Windsor.ai account or log in.
- Select Microsoft Dynamics 365 and grant Windsor.ai access to your Microsoft Dynamics 365 data.
- Pick the fields and date range you need and preview the data.
- Choose a destination and start syncing your Microsoft Dynamics 365 data.
Microsoft Dynamics 365 fields
Windsor.ai's Microsoft Dynamics 365 connector offers 2,167 fields, organized in 66 tables such as accounts, bulkoperations, campaigns, campaignactivities, campaignresponses, competitors, contacts, discounts, discounttypes, dynamicpropertyinstances, goalrollupqueries, goals. Here are 30 of them:
-
Account - Accountid (
accounts_accountid): Account - Accountid -
Date (
date): The Date -
Account Name (
account_name): The account name -
Campaign (
campaign): The Campaign Name -
Account ID (
account_id): The account ID -
Account - Accountcategorycode (
accounts_accountcategorycode): Account - Accountcategorycode -
Bulkoperation - Bulkoperationnumber (
bulkoperations_bulkoperationnumber): Bulkoperation - Bulkoperationnumber -
Campaignactivity - Actualcost (
campaignactivities_actualcost): Campaignactivity - Actualcost -
Campaignresponse - Category (
campaignresponses_category): Campaignresponse - Category -
Campaign - Actualend (
campaigns_actualend): Campaign - Actualend -
Competitor - Address1_addressid (
competitors_address1_addressid): Competitor - Address1_addressid -
Contact - Accountrolecode (
contacts_accountrolecode): Contact - Accountrolecode -
Discount - Amount (
discounts_amount): Discount - Amount -
Discounttype - Createdon (
discounttypes_createdon): Discounttype - Createdon -
Dynamicpropertyinstance - Createdon (
dynamicpropertyinstances_createdon): Dynamicpropertyinstance - Createdon -
Goalrollupquery - Createdon (
goalrollupqueries_createdon): Goalrollupquery - Createdon -
Goal - Actualdecimal (
goals_actualdecimal): Goal - Actualdecimal -
Invoicedetail - Actualdeliveryon (
invoicedetails_actualdeliveryon): Invoicedetail - Actualdeliveryon -
Invoice - Billto_city (
invoices_billto_city): Invoice - Billto_city -
Leadaddress - Addressnumber (
leadaddresses_addressnumber): Leadaddress - Addressnumber -
Lead - Address1_addressid (
leads_address1_addressid): Lead - Address1_addressid -
Leadtoopportunitysalesprocess - Activestagestartedon (
leadtoopportunitysalesprocesses_activestagestartedon): Leadtoopportunitysalesprocess - Activestagestartedon -
List - Cost (
lists_cost): List - Cost -
Metric - Amountdatatype (
metrics_amountdatatype): Metric - Amountdatatype -
Msdyn_assignmentmap - Createdon (
msdyn_assignmentmaps_createdon): Msdyn_assignmentmap - Createdon -
Msdyn_assignmentrule - Createdon (
msdyn_assignmentrules_createdon): Msdyn_assignmentrule - Createdon -
Msdyn_attribute - Createdon (
msdyn_attribute_createdon): Msdyn_attribute - Createdon -
Msdyn_attributevalue - Createdon (
msdyn_attributevalues_createdon): Msdyn_attributevalue - Createdon -
Msdyn_callablecontext - Createdon (
msdyn_callablecontexts_createdon): Msdyn_callablecontext - Createdon -
Msdyn_conversationactionitem - Createdon (
msdyn_conversationactionitems_createdon): Msdyn_conversationactionitem - Createdon
Use Microsoft Dynamics 365 data in ChatGPT and Claude
Windsor.ai is available as a plugin in ChatGPT and as a connector in Claude. Once Microsoft Dynamics 365 is connected to Windsor.ai, you can ask questions about your Microsoft Dynamics 365 data in plain language. Other MCP clients can add the Windsor MCP server at https://mcp.windsor.ai/.
- How to connect your data to ChatGPT
- How to connect your data to Claude
- How to connect Windsor MCP to any MCP client
Available destinations for your Microsoft Dynamics 365 data
AI assistants
ChatGPT, Claude, Copilot, Manus, Gemini, Gemini Enterprise, Perplexity, Cursor, Grok, Google Antigravity, Lovable, n8n, Base44, Mistral, Kimi, DeepSeek, AI Insights (any MCP client)
Spreadsheets
Google Sheets, Excel, Airtable
Databases & warehouses
BigQuery, Snowflake, MySQL, PostgreSQL, Supabase, Azure SQL, Redshift, Databricks, Microsoft Fabric, Windsor.ai Cloud Database, Cache Data Store
BI & dashboards
Data Studio, Power BI Desktop: Native, Power BI Desktop: Web, Tableau
File storage
Amazon S3 Storage, Azure Blob Storage
Code
Python/R Code