Microsoft Excel + Microsoft Dynamics 365 CRM

Create leads in Microsoft Dynamics 365 CRM from new rows in Microsoft Excel

Easily stay on top of new leads from Microsoft Excel by adding them directly to Microsoft Dynamics 365 CRM with this seamless workflow. When a new row is created in your Excel sheet, a lead will be generated in Dynamics 365 CRM, making sure you never miss out on crucial business opportunities. Save time and streamline your lead tracking process with this efficient solution.

When this happens...
New Row
Triggers when a new row is added to a worksheet in a spreadsheet.
TriggerScheduled
automatically do this!
Create Lead
Creates a new lead.
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?

- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search

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
- Api Docs Info
- 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

- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or 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

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Help

Related categories

Similar apps

OneDrive

File Management & Storage, Microsoft

Smartsheet

Spreadsheets

Quip

Documents

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

PRODUCTS

CAPABILITIES

By team

Microsoft Excel + Microsoft Dynamics 365 CRM

Create leads in Microsoft Dynamics 365 CRM from new rows in Microsoft Excel

New Row

Storage Source

SpreadsheetRequired

WorksheetRequired

New Worksheet

Storage Source

Folder

SpreadsheetRequired

Add Row

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired

Create Spreadsheet

Storage Source

Folder

TitleRequired

Column Headers

Zap Step Id

Find Row

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired

Lookup ColumnRequired

Lookup ValueRequired

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

Case/IncidentRequired

State

API Request (Beta)

Api Docs Info

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 Row in Table

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired

TableRequired

Updated Row

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired

Trigger Column

Add Row to Table