Microsoft Dynamics 365 CRM + SQL Server

Create leads in Microsoft Dynamics 365 CRM for new or updated rows in SQL Server

Stay on top of your SQL Server database changes and convert them instantly into new leads in Microsoft Dynamics 365 CRM. This workflow activates the moment a new or updated row appears in SQL Server, creating an immediate actionable lead within your CRM. With this automation, you can ensure you never miss an opportunity to grow your business, save time and maintain efficient processes.

When this happens...
New or Updated Row
Triggers when a new row is added or modified.
TriggerPolling
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

- Table/ViewRequired
Trigger
Polling
Try It
- QueryRequired
Trigger
Polling
Try It
- Table/ViewRequired
- Primary KeyRequired
- Order ByRequired
- Trigger Column
Trigger
Polling
Try It
- Disclaimer Copy
- QueryRequired
Action
Write
- TableRequired
- ID ColumnRequired
Action
Write

- QueryRequired
Action
Search
New Account
Triggers when a new account is created.
Trigger
Polling
Try It

New Contact
Triggers when a new contact is created.
Trigger
Polling
Try It
- Custom EntityRequired
Trigger
Polling
Try It
- Info
Trigger
Polling
Try It
- Info
Trigger
Polling
Try It
- Info
Trigger
Polling
Try It
- Info
Trigger
Polling
Try It
- Info
Trigger
Polling
Try It
- Info
- Owner
Action
Write
- Info
- Owner
Action
Write
- Info
- Customer typeRequired
- Owner
- Status
Action
Write
- Info
- Owner
Action
Write
- Info
- Owner
Action
Write
- Info
- AccountRequired
Action
Write
- Info
- ContactRequired
Action
Write
- Info
- Case/IncidentRequired
- State
Action
Write
- Info
- LeadRequired
Action
Write
- Info
- OrderRequired
Action
Write
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
Action
Search
- Info
- Info Field Enable
- Custom EntityRequired
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
Action
Search
- State Code
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Info
- Info Field Enable
- Contact ID
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
- Owner
Action
Search or write
- Info
- Info Field Enable
- Custom EntityRequired
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
Action
Search or write
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Owner
Action
Search or write
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Owner
Action
Search or write

- Table/ViewRequired
- Order By
- Dedupe Key
Trigger
Polling
Try It
New Table
Triggers when you add a new table.
Trigger
Polling
Try It
- QueryRequired
Trigger
Polling
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- QueryRequired
Action
Search
- Info
Trigger
Polling
Try It
- Info
Trigger
Polling
Try It
New Case/Incident
Triggers when a new case/incident is created.
Trigger
Polling
Try It
New Invoice
Triggers when a new invoice is created.
Trigger
Polling
Try It
New Lead
Triggers when a new lead is created.
Trigger
Polling
Try It
New Opportunity
Triggers when a new opportunity is created.
Trigger
Polling
Try It
New Order
Triggers when a new order is created.
Trigger
Polling
Try It
- Info
Trigger
Polling
Try It
- Owner
Action
Write
- Owner
Action
Write
- Custom EntityRequired
Action
Write
- Info
- Owner
Action
Write
- Info
- Owner
Action
Write
- Owner
Action
Write
- Info
- Custom Entity ActionRequired
Action
Write
- Info
- InvoiceRequired
Action
Write
- Info
- OpportunityRequired
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Info
- Info Field Enable
- Company Name
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
Action
Search
- Campaign NameRequired
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Info
- Info Field Enable
- Company Name
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
- Owner
Action
Search or write
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Owner
Action
Search or write
- Info
- Info Field Enable
- Contact ID
- Match if any of the fields match (otherwise only match if all the fields match)
- Owner
Action
Search or write