Microsoft Dynamics 365 CRM + Smartsheet Integration

Integrate Microsoft Dynamics 365 CRM to Smartsheet in one click, or tell Integrately AI how you want each lead handled. Capture leads, update your sheets and CRM, alert your team, and trigger follow-ups automatically.

Free foreverFree forever.
Use premium features free for 14 daysUse premium features free for 14 days.
1.
  • Microsoft Dynamics 365 CRM
    Member is added to marketing list in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Sales order is created in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Contact is updated in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Contact is created in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Account is created in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Account is updated in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Opportunity is created in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Opportunity is updated in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Case is created in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Case is updated in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Lead is created in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Lead is updated in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Quote is updated in Microsoft Dynamics 365 CRM
  • Smartsheet
    Row is added in Smartsheet
  • Smartsheet
    Row is updated in Smartsheet
  • Smartsheet
    Attachment is added in Smartsheet
  • Smartsheet
    Comment is added in Smartsheet
Arrow Right
2.
  • Microsoft Dynamics 365 CRM
    Search marketing list by name in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Get contact by Id in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Get marketing list members in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Create lead in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Update lead in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Search lead in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Create contact in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Update contact in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Create account in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Search account in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Update account in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Search contact in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Search Currency in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Create case in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Update case in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Search case in Microsoft Dynamics 365 CRM
  • Microsoft Dynamics 365 CRM
    Get account by ID in Microsoft Dynamics 365 CRM
  • Smartsheet
    Search row in Smartsheet
  • Smartsheet
    Add attachment to row in Smartsheet
  • Smartsheet
    Update row in Smartsheet
  • Smartsheet
    Add row in Smartsheet
  • Smartsheet
    Send row in Smartsheet
  • Smartsheet
    Copy row in Smartsheet
  • Smartsheet
    Move row in Smartsheet
  • Smartsheet
    Add discussion to row in Smartsheet
  • Smartsheet
    Create sheet from a template in Smartsheet
  • Smartsheet
    Share sheet in Smartsheet
  • Smartsheet
    Create sheet from existing sheet in Smartsheet
  • Smartsheet
    Send sheet in Smartsheet
  • Smartsheet
    Create workspace in Smartsheet
  • Smartsheet
    Copy workspace in Smartsheet
  • Smartsheet
    Share workspace in Smartsheet
  • Smartsheet
    Copy folder in Smartsheet

Trusted by experts at...

indeed-logoIntuit-logonvidia-logosalesforce-logottc-logoWalmart-logoaccenture-logoadobe-logoatlassian-logocisco-logodeloitte-logohp-logo
indeed-logoIntuit-logonvidia-logosalesforce-logottc-logoWalmart-logoaccenture-logoadobe-logoatlassian-logocisco-logodeloitte-logohp-logo

Ready Workflows Ready Workflows for Microsoft Dynamics 365 CRM + Smartsheet Integration

Capture leads, organise responses, keep sheets updated, alert your team, and send follow-ups, all in just one click.

Most popular automationsmost-popular-automations
Microsoft Dynamics 365 CRM + Smartsheet Integration

Create Smartsheet row for new Microsoft Dynamics 365 CRM contact

When a new contact is created in your Microsoft Dynamics 365 CRM, you can automatically create a row for them in your Smartsheet. This way, you'll always have up-to-date information on your contacts and can easily track their progress. Plus, you won't have to manually enter data into multiple systems - it will all be taken care of automatically.

So go ahead and set up this integration - it will make your life much easier!
See more
Smartsheet + Microsoft Dynamics 365 CRM Integration

Create Microsoft Dynamics 365 CRM contact for new Smartsheet row

Automatically creating Microsoft Dynamics 365 CRM contact records for new Smartsheet row entries is a huge time-saver! This way, you can be sure that your data is always accurate and complete. Plus, it saves you time and effort by eliminating the need to manually enter data into both systems.

Also, it's one less thing for you to have to remember to do manually. Win-win!
See more
  • 1of1
Got a different task in mind? Describe it

Got a different automation in mind? Describe it and let Integrately AI build it for you.

Connect more apps to your Microsoft Dynamics 365 CRM + Smartsheet flow

Connect your CRM and spreadsheet workflows with messaging, support, and email tools to keep your entire team aligned. Pick a combination and activate it in one click.

Microsoft Dynamics 365 CRM
Smartsheet
+
Microsoft OutlookMicrosoft Outlook (8)
+
SalesforceSalesforce (8)
+
SlackSlack (8)
+
GmailGmail (8)
+
Microsoft TeamsMicrosoft Teams (8)
+
ZoomZoom (8)
M
S
M
Add every new Microsoft Dynamics 365 CRM lead to your Smartsheet project, and send a welcome email in Microsoft Outlook
New Microsoft Dynamics 365 CRM leads appear in your Smartsheet project within seconds and a welcome email goes out via Microsoft Outlook, so your team never misses an initial outreach.
M
S
M
When a Microsoft Dynamics 365 CRM account is updated, add a Smartsheet row, and send a summary email in Microsoft Outlook
Account changes in Microsoft Dynamics 365 CRM instantly create Smartsheet tracking rows while Microsoft Outlook notifies management.
S
M
M
When a Smartsheet row is updated, update the lead in Microsoft Dynamics 365 CRM, and send an update email in Microsoft Outlook
Smartsheet progress updates automatically refresh Microsoft Dynamics 365 CRM leads and notify stakeholders in Microsoft Outlook.
S
M
M
Create a Microsoft Outlook task for every new Smartsheet row, and update the lead in Microsoft Dynamics 365 CRM
New Smartsheet entries generate actionable Microsoft Outlook tasks while keeping Microsoft Dynamics 365 CRM leads current.
M
S
M
If a new Microsoft Dynamics 365 CRM lead is high value, add a priority row in Smartsheet and send a review email in Microsoft Outlook
High-value Microsoft Dynamics 365 CRM leads generate priority Smartsheet entries and instant Microsoft Outlook review alerts.
M
S
M
When a Microsoft Dynamics 365 CRM case is updated, update the Smartsheet row, and email the manager in Microsoft Outlook
Case updates in Microsoft Dynamics 365 CRM refresh Smartsheet tracking rows and notify supervisors via Microsoft Outlook.
M
S
M
Use Claude to summarise every new Microsoft Dynamics 365 CRM opportunity, add the summary to Smartsheet, and email the brief via Microsoft Outlook
Claude summarises new Microsoft Dynamics 365 CRM opportunities before adding them to Smartsheet and emailing briefs via Microsoft Outlook.
M
S
S
M
Turn every won Microsoft Dynamics 365 CRM opportunity into a Smartsheet workspace, create a follow-up task in Salesforce, and email the client via Microsoft Outlook
Won Microsoft Dynamics 365 CRM opportunities spawn Smartsheet workspaces, Salesforce tasks, and Microsoft Outlook client emails.

Supported triggers and actions for Microsoft Dynamics 365 CRM and Smartsheet

Mix and match to build the exact automation you need

Microsoft Dynamics 365 CRM
Microsoft Dynamics 365 CRM Triggers & Actions
Member is added to marketing list in Microsoft Dynamics 365 CRM
Try it →
Sales order is created in Microsoft Dynamics 365 CRM
Try it →
Contact is updated in Microsoft Dynamics 365 CRM
Triggers the automation when a contact is updated
Try it →
Contact is created in Microsoft Dynamics 365 CRM
Triggers the automation when a new contact is created
Try it →
Account is created in Microsoft Dynamics 365 CRM
Triggers the automation when a new account is created
Try it →
Account is updated in Microsoft Dynamics 365 CRM
Triggers the automation when an account is updated
Try it →
Opportunity is created in Microsoft Dynamics 365 CRM
Triggers the automation when any opportunity is updated
Try it →
Opportunity is updated in Microsoft Dynamics 365 CRM
Triggers the automation when any opportunity is updated
Try it →
Case is created in Microsoft Dynamics 365 CRM
Triggers the automation when a new case is created
Try it →
Case is updated in Microsoft Dynamics 365 CRM
Triggers the automation when any case is updated
Try it →
Lead is created in Microsoft Dynamics 365 CRM
Triggers the automation when a new lead is created
Try it →
Lead is updated in Microsoft Dynamics 365 CRM
Triggers the automation when the lead information is updated
Try it →
Quote is updated in Microsoft Dynamics 365 CRM
Triggers the automation when any quote is updated
Try it →
Search marketing list by name in Microsoft Dynamics 365 CRM
Try it →
Get contact by Id in Microsoft Dynamics 365 CRM
Try it →
Get marketing list members in Microsoft Dynamics 365 CRM
Try it →
Create lead in Microsoft Dynamics 365 CRM
Generates new leads for potential customers
Try it →
Update lead in Microsoft Dynamics 365 CRM
Updates the lead information
Try it →
Search lead in Microsoft Dynamics 365 CRM
Retrieves information for a particular lead
Try it →
Create contact in Microsoft Dynamics 365 CRM
Adds a new contact to the database
Try it →
Update contact in Microsoft Dynamics 365 CRM
Updates contact information with new details
Try it →
Create account in Microsoft Dynamics 365 CRM
Generates a new account
Try it →
Search account in Microsoft Dynamics 365 CRM
Searches for account information
Try it →
Update account in Microsoft Dynamics 365 CRM
Updates account information
Try it →
Search contact in Microsoft Dynamics 365 CRM
Finds and retrieves contact information
Try it →
Search Currency in Microsoft Dynamics 365 CRM
Searches for a currency
Try it →
Create case in Microsoft Dynamics 365 CRM
Generates a new case entry
Try it →
Update case in Microsoft Dynamics 365 CRM
Updates case details based on new information received
Try it →
Search case in Microsoft Dynamics 365 CRM
Searches for a case record
Try it →
Get account by ID in Microsoft Dynamics 365 CRM
Try it →
Smartsheet
Smartsheet Triggers & Actions
Row is added in Smartsheet
Triggers the automation when a new row is added to a spreadsheet
Try it →
Row is updated in Smartsheet
Triggers the automation when a row is updated
Try it →
Attachment is added in Smartsheet
Triggers the automation when a new attachment is added
Try it →
Comment is added in Smartsheet
Triggers the automation when a comment is added
Try it →
Search row in Smartsheet
Searches and retrieve a row of data within a dataset
Try it →
Add attachment to row in Smartsheet
Attaches a file to a row
Try it →
Update row in Smartsheet
Updates a specified row in a spreadsheet or database
Try it →
Add row in Smartsheet
Adds a new row to the particular spreadsheet
Try it →
Send row in Smartsheet
Sends a row
Try it →
Copy row in Smartsheet
Duplicates a row of data within a spreadsheet
Try it →
Move row in Smartsheet
Relocates a selected row of data to a new position within the spreadsheet
Try it →
Add discussion to row in Smartsheet
Adds a discussion thread to a row
Try it →
Create sheet from a template in Smartsheet
Creates a new sheet from a template
Try it →
Share sheet in Smartsheet
Shares a sheet
Try it →
Create sheet from existing sheet in Smartsheet
Creates a new sheet based on an existing one
Try it →
Send sheet in Smartsheet
Sends a sheet
Try it →
Create workspace in Smartsheet
Creates a new workspace
Try it →
Copy workspace in Smartsheet
Duplicates a workspace to create a new identical workspace
Try it →
Share workspace in Smartsheet
Shares a workspace
Try it →
Copy folder in Smartsheet
Duplicate a folder and all its contents
Try it →

What can you automate with Microsoft Dynamics 365 CRM + Smartsheet?

Streamline your customer data and project tracking by connecting Microsoft Dynamics 365 CRM and Smartsheet for real-time synchronization.

What you can automate?
🔄
Sync Microsoft Dynamics 365 CRM leads to Smartsheet
Create a Smartsheet row automatically whenever a new lead, contact, or account is created in Microsoft Dynamics 365 CRM, removing manual data entry across your systems.
📋
Capture every submitted CRM field in one row
Map detailed Microsoft Dynamics 365 CRM lead and contact answers into separate Smartsheet columns instead of just a name and email, creating a comprehensive source for review.
🔔
Alert your team the moment an update happens
Send automated notifications to your team in Slack or Microsoft Teams whenever a new Microsoft Dynamics 365 CRM case or opportunity is updated in Smartsheet.
🔀
Route records based on submitted criteria
Apply conditional rules to send enterprise leads to specific Smartsheet workspaces while standard leads populate your general tracking sheet automatically.
🔄
Keep your project sheets up to date
Update existing Smartsheet rows automatically whenever contact details, account names, or case statuses change in Microsoft Dynamics 365 CRM.
🛡️
Prevent duplicate entries in your sheets
Search existing Smartsheet rows before adding new records to ensure your project sheets remain clean, organized, and free from duplicate entries.
📊
Handle later status changes and closures
Update Smartsheet rows automatically when Microsoft Dynamics 365 CRM opportunities are marked won or lost, keeping your financial and project boards accurate.
💬
Extend workflows to your favorite apps
Connect Microsoft Dynamics 365 CRM and Smartsheet with Slack, Gmail, or Microsoft Teams to trigger follow-up emails, channel alerts, and team tasks instantly.
And much more...

Who is Microsoft Dynamics 365 CRM + Smartsheet integration for?

Connecting Microsoft Dynamics 365 CRM and Smartsheet eliminates manual data entry, keeping project tracking sheets updated instantly and giving every department reliable visibility.

Operations Managers
Operations Managers
Sales Executives
Sales Executives
Account Managers
Account Managers
Revenue Operations Leads
Revenue Operations Leads
Project Coordinators
Project Coordinators
Business Analysts
Business Analysts
📈
Operations Managers
You're tracking sales orders and pipeline stages in Microsoft Dynamics 365 CRM, but your project planning sheets only update when someone manually exports records, so your operational reports are always outdated — automating both apps means every order lands in Smartsheet instantly and your metrics stay current.
Sales Executives
You're managing new leads and opportunities in Microsoft Dynamics 365 CRM, but reps find out about project updates too late because sheet handoffs happen manually — with this integration, every account change triggers an immediate Smartsheet update so your team acts without delay.
🤝
Account Managers
You're logging client cases and service requests in Microsoft Dynamics 365 CRM, but clients want to see live status reports that require constant manual spreadsheet updates — integrating these apps means client sheets update automatically and stakeholders always see accurate progress.
📊
Revenue Operations Leads
You're processing high volumes of quotes and contacts in Microsoft Dynamics 365 CRM, but manual spreadsheet entry cannot keep pace with transaction spikes, leaving gaps in your project tracking — automating both apps means every record logs seamlessly and your master sheet never falls behind.
📋
Project Coordinators
You're waiting for upstream teams to finish deals in Microsoft Dynamics 365 CRM before you can set up project sheets by hand, leading to handover bottlenecks — connecting these apps means won opportunities create Smartsheet workspaces instantly and your project kickoff happens on time.
🔍
Business Analysts
You're auditing customer histories and case records in Microsoft Dynamics 365 CRM, but manual tracking leaves missing rows and discrepancies across your audit sheets — this integration means every transaction records reliably and your historical archives stay complete.
Our team

Ready Workflows Did you know?

Our team can create automations for you... At no extra cost!

Tell us what type of automation you want to make?

Why choose Integrately to automate Microsoft Dynamics 365 CRM + Smartsheet

Build and manage your Microsoft Dynamics 365 CRM + Smartsheet automations with ready-made flows, AI assistance, 24x5 reliable human support, and enterprise-grade security.

1,500+ apps connected
1,500+ apps connected
Connect Microsoft Dynamics 365 CRM + Smartsheet with email, CRM, messaging, finance, support, and other tools whenever your process needs another step.
20M+ Ready Automations
20M+ Ready Automations
Start with 20 million+ proven automation templates instead of building everything from scratch. Pick the closest flow, connect your accounts, and automate in minutes.
AI that builds your automations
AI that builds your automations
Describe your workflow in plain English. Integrately AI builds it, maps fields, adds conditions, and even lets you edit it through chat.
24x5 Live Chat Support
24x5 Live Chat Support
Chat with a real person and get reply within 2-5 minutes. No bots, no tickets, no waiting — just real help, right when you need it.
Free done-for-you setup
Free done-for-you setup
Tell our team what you need and we will help set up the automation in your account at no extra cost on any plan.
Secure by design
Secure by design
SOC 2 Type II and ISO 27001:2022 certified, with GDPR-compliant data practices. Your data and credentials are handled using recognised security and privacy standards.
How Integrately Works?

How Integrately Works?

1
Select Automation
Select a trigger from Google Sheets
2
Connect Accounts
Connect Accounts
That’s it! You just connected Google Sheets to Trello
3
Automation is ready
Setup an action from Trello
Price Comparison with Popular Alternatives
Popular Alternative
😐
750 Tasks
in $19.99
Integrately
😍
2,000 Tasks
in $19.99

Trusted by 42,000+ Customers

Highest Rated Integration Platform on G2
P
ProductHunt

Most upvoted product of the month

2000+
leader
most-implementable
easiest-to-do-business
best-support

Frequently Asked Questions

How do I connect Microsoft Dynamics 365 CRM to Smartsheet?
Frequently Asked Questions
You can connect Microsoft Dynamics 365 CRM to Smartsheet in 1-click using ready-made templates on Integrately, or ask Integrately AI to build the automation and map the fields for your team.
Can I automatically add Microsoft Dynamics 365 CRM leads to Smartsheet?
Frequently Asked Questions
Can I connect Microsoft Dynamics 365 CRM, Smartsheet, and Slack?
Frequently Asked Questions
What is a good Zapier alternative for Microsoft Dynamics 365 CRM and Smartsheet?
Frequently Asked Questions
How does Microsoft Dynamics 365 CRM handle contact updates in Smartsheet?
Frequently Asked Questions
Can Smartsheet row additions trigger Microsoft Dynamics 365 CRM updates?
Frequently Asked Questions
How do I automate Microsoft Dynamics 365 CRM and Smartsheet without coding?
Frequently Asked Questions
Is the Microsoft Dynamics 365 CRM and Smartsheet integration free?
Frequently Asked Questions
Didn't find the answer you were looking for?
Didn't find the answer you were looking for?
No worries — just send us a message and we’ll get back to you as soon as possible.

Want to automate something else in your workflow?

You Can Also Connect Microsoft Dynamics 365 CRM or Smartsheet With 1500+ Other Apps

Microsoft Dynamics 365 CRM
Popular Microsoft Dynamics 365 CRM Integrations
Connect Microsoft Dynamics 365 CRM with CRMs, email tools, and marketing platforms to manage and follow up on your leads.
Smartsheet
Popular Smartsheet Integrations
Sync Smartsheet with project management, accounting, and reporting tools to keep data working across your stack.