Salesforce + SQL Server

Create new Salesforce records from new custom query rows in SQL Server

Easily maintain your Salesforce records with the latest data updates from your SQL Server. This workflow activates when a new row is added to your SQL Server based on a custom query, and immediately creates a record in Salesforce, ensuring your CRM is always up-to-date with the most pertinent information. Streamline your data management process and improve the accuracy of your Salesforce information with this seamless integration.

When this happens...
New Row (Custom Query)
Triggers when new rows are returned from a custom query that you provide. Advanced Users Only.
TriggerPolling
automatically do this!
Create Record (UTC)
Creates a new record of a specified Salesforce object. Dates use the UTC format.
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 Case Attachment
Triggers when a new Attachment is added to a case.
Trigger
Polling
Try It

- History ObjectRequired
Trigger
Polling
Try It
New Lead
Triggers when a new Lead is created.
Trigger
Polling
Try It
- Salesforce ObjectsRequired
Trigger
Polling
Try It
- Salesforce ObjectRequired
Trigger
Polling
Try It
- Salesforce ObjectRequired
- RecordRequired
- FileRequired
- VisibilityRequired
Action
Write
- Path after /services/apexrest/Required
- HTTP methodRequired
- Query parameters
- Extra headers
- Request body
- Timeout
Action
Write
- FileRequired
- Salesforce ObjectRequired
- Description
- Attachment visibility
Action
Write
Create Contact
Creates a new contact.
Action
Write
- FileRequired
- Title
- Description
- Salesforce Object
Action
Write
- Note TitleRequired
- Note
- Salesforce ObjectRequired
- Note Visibility
- Use Assignment Rules
Action
Write
- Salesforce ObjectRequired
- Use Assignment Rules
- Allow Duplicates
Action
Write
- ReportRequired
- Include details
- Number of custom filters
- Row groupings
- Column groupings
- Summary calculations
- Detail columns
- Sort order
- Report format
- Advanced report options
Action
Write
- Contact to UpdateRequired
Action
Write
- Salesforce ObjectRequired
- Record to UpdateRequired
- Use Assignment Rules
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Salesforce ObjectRequired
- Search ValueRequired
- Second Field to Search By
- Second Search Value
- Search Operator
Action
Search
- Salesforce ObjectRequired
Action
Search
- Salesforce ObjectRequired
- Record IDRequired
Action
Search
- Salesforce ObjectRequired
- SOQL WHERE ClauseRequired
- Sort by
- Sort Order
- Maximum Number of Records
- Use Assignment Rules
- Allow Duplicates
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
New Contact
Triggers when a new Contact is created.
Trigger
Polling
Try It
- Salesforce ObjectRequired
- Record (Optional)
Trigger
Polling
Try It
New Outbound Message
Triggers when a new outbound message is received in Salesforce.
Trigger
Instant
Try It
- Disclaimer
- Salesforce ObjectRequired
Trigger
Polling
Try It
- CampaignRequired
- ContactRequired
Action
Write
- CampaignRequired
- LeadRequired
Action
Write
- LeadRequired
- AccountRequired
- Opportunity
- Create new opportunity?
- Converted StatusRequired
Action
Write
- Parent ObjectRequired
- Use Assignment Rules
Action
Write
- Note TitleRequired
- Note ContentRequired
- Salesforce Object
Action
Write
- Use Assignment Rules
Action
Write
- Salesforce ObjectRequired
- Use Assignment Rules
- Allow Duplicates
Action
Write
- Warning
- Salesforce ObjectRequired
- Record IDRequired
Action
Write
- ToRequired
- CC
- BCC
- SubjectRequired
- Email FormatRequired
- Sender TypeRequired
Action
Write
- Lead to UpdateRequired
- Use Assignment Rules
Action
Write
- Salesforce ObjectRequired
- Record to UpdateRequired
- Use Assignment Rules
Action
Write
- Parent ObjectRequired
Action
Search
- Salesforce ObjectRequired
- SOQL WHERE clauseRequired
Action
Search
- Salesforce ObjectRequired
- SOQL WHERE ClauseRequired
- Sort by
- Sort Order
- Maximum Number of Records
Action
Search
- Salesforce ObjectRequired
- Search ValueRequired
- Second Field to Search By
- Second Search Value
- Search Operator
- Use Assignment Rules
- Allow Duplicates
Action
Search or write

About Salesforce

Salesforce is a leading enterprise customer relationship manager (CRM) application.

Learn more

Related categories

CRM (Customer Relationship Management)

Similar apps

Zapier Interfaces

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

About SQL Server

SQL server (or MS SQL) is a top of the line database geared for the cloud

Learn more

Related categories

Databases

Similar apps

Salesforce + SQL Server

Create new Salesforce records from new custom query rows in SQL Server

New Column

New Row (Custom Query)

New or Updated Row

Create Custom Query

Update Row

Find Multiple Rows via Custom Query

New Case Attachment

New Field History Tracking Event

New Lead

New Record

Updated Record

Add File to Record

Call Apex REST

Create Attachment

Create Contact

Create File

Create Note

Create Record (UTC)

Run Report

Update Contact

Update Record

API Request (Beta)

Find Record

Find Records

Get Record Attachments

Find or Create Record by Query

New Row

New Table

New or Updated Row (Custom Query)

New Row

Find Row

Find Row via Custom Query

New Contact

New or Updated File on Record

New Outbound Message

Updated Field on Record

Add Contact to Campaign

Add Lead to Campaign

Convert Lead to Contact

Create Child Records (with line item support)

Create Enhanced Note

Create Lead

Create Record

Delete Record

Send Email

Update Lead

Update Record (UTC)

Find Child Records

Find Records by Query

Find Record by Query

Find or Create Record

About Salesforce

Related categories

Similar apps

Zapier Interfaces

About SQL Server

Related categories

Similar apps

MySQL

PostgreSQL

Firebase / Firestore

Related Zap Templates

Related Zap Templates