Microsoft Dynamics 365 CRM + Smartsheet

Create new Smartsheet sheets from existing ones for new Microsoft Dynamics 365 CRM contacts

Keep your Smartsheet updated with contact information from Microsoft Dynamics 365 CRM effortlessly. Once set up, this workflow will create a new entry in your existing Smartsheet sheet every time a new contact is added in Microsoft Dynamics 365 CRM. This ensures that your contact data remains current and easy to access, maximizing efficiency and saving time.

When this happens...
New Contact
Triggers when a new contact is created.
TriggerScheduled
automatically do this!
New Sheet From Existing Sheet
Create a new sheet from an existing sheet.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

New Account
Triggers when a new account is created.
Trigger
Scheduled
Try It
Contact Updated
Triggers when a contact has been updated.
Trigger
Scheduled
Try It
New Case/Incident
Triggers when a new case/incident is created.
Trigger
Scheduled
Try It
New Lead
Triggers when a new lead is created.
Trigger
Scheduled
Try It
New Opportunity
Triggers when a new opportunity is created.
Trigger
Scheduled
Try It

Updated Quote
Triggers when a quote is updated.
Trigger
Scheduled
Try It
Create Campaign
Creates a new campaign.
Action
Write

Create Campaign Response
Creates a new campaign response.
Action
Write
- Info
Action
Write
Update Campaign Response
Updates an existing campaign response.
Action
Write
- Info
- Case/IncidentRequired
- State
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Info
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
Find Campaign Response
Finds a campaign response.
Action
Search
- Info
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Info
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search or write
- Info
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search or write
- Choose a SheetRequired
Trigger
Scheduled
Try It
- Choose a SheetRequired
Trigger
Scheduled
Try It
- SheetRequired
- RowRequired
- File AttachmentRequired
Action
Write
- Choose a SheetRequired
- Add Row to Top or Bottom
Action
Write
- Choose Source SheetRequired
- Choose a Destination SheetRequired
- Choose RowRequired
Action
Write
- Choose Source SheetRequired
- Choose a Destination SheetRequired
- Choose RowRequired
Action
Write
- DestinationRequired
- TemplateRequired
- Copy Cells?Required
- Copy Attachments?Required
- Copy Discussions?Required
- Sheet NameRequired
Action
Write
- Choose a SheetRequired
- Email Address(es)Required
- Choose RowRequired
- Email Subject
- Message
- CC Me?
- Include Attachments ?
- Include Discussions ?
Action
Write
- Choose a SheetRequired
- Email Address(es) to Share ToRequired
- Access LevelRequired
- Notify via Email?Required
- Email Subject
- Message
- CC Me?
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write

New Contact
Triggers when a new contact is created.
Trigger
Scheduled
Try It
- Custom EntityRequired
Trigger
Scheduled
Try It
Case/Incident Updated
Triggers when a case/incident has been updated.
Trigger
Scheduled
Try It
Lead Updated
Triggers when a lead has been updated.
Trigger
Scheduled
Try It
Opportunity Updated
Triggers when an opportunity has been updated.
Trigger
Scheduled
Try It
- Info
Action
Write
- Info
Action
Write
- Info
- Customer typeRequired
- Status
Action
Write
- Info
- AccountRequired
Action
Write
- Info
- ContactRequired
Action
Write
- Info
- LeadRequired
Action
Write
- Info
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Campaign NameRequired
Action
Search
- Info
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Info
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search or write
- Info
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search or write
- Choose a SheetRequired
Trigger
Scheduled
Try It
- Choose a SheetRequired
Trigger
Scheduled
Try It
- Workspace NameRequired
Action
Write
- Choose a SheetRequired
- RowRequired
- TitleRequired
- CommentRequired
Action
Write
- Source FolderRequired
- Destination FolderRequired
- New Folder NameRequired
Action
Write
- WorkspaceRequired
- New NameRequired
- What to Include?
- Skip Remap
Action
Write
- DestinationRequired
- Sheet to CopyRequired
- Copy Cells?Required
- Copy Attachments?Required
- Copy Discussions?Required
- Sheet NameRequired
Action
Write
- Choose a SheetRequired
- Row IDRequired
Action
Write
- Choose a SheetRequired
- Email Address(es)Required
- FormatRequired
- Email Subject
- Message
- CC Me?
- Paper Size
Action
Write
- Choose a WorkspaceRequired
- Email Address(es) to Share ToRequired
- Access LevelRequired
- Notify via Email?Required
- Email Subject
- Message
- CC Me?
Action
Write
Find sheet Row
Find a row in a specified sheet using a query.
Action
Write

About Microsoft Dynamics 365 CRM

Microsoft Dynamics is built for any device, anywhere. Built for you. For Dynamics Version 9 and Dynamics 365.

Learn more Help

Related categories

Similar apps

Pipedrive

CRM (Customer Relationship Management)

Insightly

CRM (Customer Relationship Management)

Zapier Interfaces

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier

About Smartsheet

Smartsheet is a leading cloud-based platform for work execution, enabling teams and organizations to plan, capture, manage, automate, and report on work at scale, resulting in more efficient processes and better business outcomes.

Help

Related categories

Spreadsheets

Similar apps

MySQL

Databases

Zoho Creator

App Builder, Zoho

Knack

Databases

PRODUCTS

CAPABILITIES

By team

Microsoft Dynamics 365 CRM + Smartsheet

Create new Smartsheet sheets from existing ones for new Microsoft Dynamics 365 CRM contacts

New Account

Contact Updated

New Case/Incident

New Lead

New Opportunity

Updated Quote

Create Campaign

Create Campaign Response

Create Lead

Info

Update Campaign Response

Update Case/Incident

Info

State

API Request (Beta)

HTTP MethodRequired

URLRequired

Query String Parameters

Headers

Additional Request Headers

Body

Find Contact

Info

Match if any of the fields match (otherwise only match if all the fields match)

Find Campaign Response

Find Opportunity

Info

Match if any of the fields match (otherwise only match if all the fields match)

Find or Create Contact

Info

Match if any of the fields match (otherwise only match if all the fields match)

Find or Create Opportunity

Info

Match if any of the fields match (otherwise only match if all the fields match)

New Attachment

Choose a SheetRequired

New Row

Choose a SheetRequired

Add Attachment to Row

SheetRequired

RowRequired

File AttachmentRequired

Add Row to Sheet

Choose a SheetRequired

Add Row to Top or Bottom

Copy Row

Choose Source SheetRequired

Choose a Destination SheetRequired

Choose RowRequired

Move Row

Choose Source SheetRequired

Choose a Destination SheetRequired

Choose RowRequired

New Sheet From Template

DestinationRequired

TemplateRequired

Copy Cells?Required

Copy Attachments?Required

Copy Discussions?Required

Sheet NameRequired

Send Row

Choose a SheetRequired

Email Address(es)Required

Choose RowRequired

Email Subject

Message

CC Me?

Include Attachments ?

Include Discussions ?

Share Sheet

Choose a SheetRequired

Email Address(es) to Share ToRequired

Access LevelRequired

Notify via Email?Required

Email Subject