Keap + SQL Server

Handle SQL Server new or updated rows by creating or updating contacts in Keap

Keep your Keap contacts up-to-date as changes occur in your SQL Server app. With this workflow, any new or updated row in your SQL Server immediately translates into the creation or update of a contact in Keap. Reduce the hassle of manual data transfer, ensuring your contacts are always accurate and readily accessible. This seamless integration empowers you to focus more on building relationships with contacts rather than managing them.

When this happens...
New or Updated Row
Triggered when a new row is added or modified.
TriggerScheduled
automatically do this!
Create or Update Contact
Creates a new contact or updates an existing contact.
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?

- Table/ViewRequired
Trigger
Scheduled
Try It
- QueryRequired
Trigger
Scheduled
Try It
- Table/ViewRequired
- Primary KeyRequired
- Order ByRequired
- Trigger Column
Trigger
Scheduled
Try It
- TableRequired
- ID ColumnRequired
Action
Write
- QueryRequired
Action
Search

New Action Sequence
Triggers when a new Action Sequence is added.
Trigger
Scheduled
Try It
- Appointment events this trigger will listen to:Required
Trigger
Instant
Try It

New Contact
Triggers when a new contact is created.
Trigger
Instant
Try It
- Note events this trigger will listen to:Required
Trigger
Instant
Try It
- Product events this trigger will listen to:Required
Trigger
Instant
Try It
New Subscription Plan
Triggers when a new Subscription Plan is added.
Trigger
Scheduled
Try It
- Task events this trigger will listen to:Required
Trigger
Instant
Try It
New Invoice
Triggers when a new invoice is created. This will trigger the moment the invoice is created, before any details are added.
Trigger
Instant
Try It
New Payment (All Payment Type)
Triggers when any payment is made regardless of the payment type. Credit Card Payments, Cash Payments, and Check Payments.
Trigger
Instant
Try It
New Assigned Task
Triggers when a new task is created. Please note: only tasks assigned to the authenticated user may be retrieved through this trigger. Use the New Task Event trigger to retrieve all tasks.
Trigger
Instant
Try It
Opportunity Stage Moved
Triggers when an opportunity stage is moved.
Trigger
Instant
Try It
- Company NameRequired
- Country Code (e.g., "USA")
- Address Line 1
- Address Line 2
- Locality
- Region (e.g., "US-CA")
- Zip Code
- Zip Four
- Phone Number
- Phone Ext
- Notes
- Email Address
- Fax Number
- Website
Action
Write
- Contact IdRequired
- BodyRequired
- Title
- Type
- User Id
Action
Write
- Invoice IDRequired
- Product
- Product QuanityRequired
- Price Override
Action
Write
- UserRequired
- ContactsRequired
- SubjectRequired
- HTML Content
- Plain Text Content
- Email Address Field
- Attachments
Action
Write
- Company IDRequired
- Company Name
- Email AddressRequired
- Website
- Notes
- Opt-In
- Address Country Code
- Address Street (Line 1)
- Address Street (Line 2)
- Address City
- Address State
- Address Zip Code
- Address Zip Four
- Phone Number
- Phone Extension
- Phone Type
- Phone Number
- Phone Extension
- Phone Type
Action
Write
- FieldRequired
- ValueRequired
Action
Search
- Invoice IDRequired
Action
Search
- Company NameRequired
- Country Code (e.g., "USA")
- Address Line 1
- Address Line 2
- Locality
- Region (e.g., "US-CA")
- Zip Code
- Zip Four
- Phone Number
- Phone Ext
- Notes
- Email Address
- Fax Number
- Website
Action
Search or write

- Table/ViewRequired
- Order By
- Dedupe Key
Trigger
Scheduled
Try It
New Table
Triggered when you add a new table.
Trigger
Scheduled
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- QueryRequired
Action
Search
New Affiliate
For Ulimate users, triggers when a new affiliate is added.
Trigger
Scheduled
Try It
- Company events this trigger will listen to:Required
Trigger
Instant
Try It
- Invoice events this trigger will listen to:Required
Trigger
Instant
Try It
- Opportunity events this trigger will listen to:Required
- RandomRequired
Trigger
Instant
Try It
- Subscription events this trigger will listen to:Required
Trigger
Instant
Try It
- Tag events this trigger will listen to:Required
- Tag (for use with "Tag Applied to Contact" event only)
Trigger
Instant
Try It
New Credit Card Charge - Merchant Only
Triggers when a new credit card charge is made. (Merchant Only).
Trigger
Instant
Try It
New Manual Payment – (Cash, Check)
Triggers when a New Manual Payment is added. (Cash or Check).
Trigger
Instant
Try It
- Tag
Trigger
Instant
Try It
Updated Contact
Triggers when an existing contact is updated.
Trigger
Instant
Try It
- Product NameRequired
- Active
- Product Description
- Product Price
- Product Short Description
- SKU
- Subscription Only
Action
Write
- Contact IDRequired
- Lead Affiliate Id
- Order DateRequired
- Product IdRequired
- Product QuantityRequired
- Price Override
- Order TitleRequired
- Order TypeRequired
- Promo Codes
- Sales Affiliate Id
- Company
- Country Code (e.g., USA)
- First Name
- Is Invoice to Company
- Last Name
- Address Line 1
- Address Line 2
- Locality
- Middle Name
- Phone
- Region (e.g., US-CA)
- Zip Code
- Zip Four
Action
Write
- Contact Id
- Due DateRequired
- TitleRequired
- User Id
- Description
Action
Write
- ContactRequired
- TagsRequired
Action
Write
- ContactRequired
- TagsRequired
Action
Write
- Check for Duplicates UsingRequired
- Email Address 1
- Opt In
- Last Name
- First Name
- Tag IDs
- Anniversary Date (format: YYYY-MM-DD)
- Birth Date (format: YYYY-MM-DD)
- Company Name
- Company ID
- Contact Type
- Job Title
- Lead Source ID
- Middle Name
- Origin IP Address
- Owner ID
- Preferred Locale
- Preferred Name
- Prefix
- Source Type
- Spouse Name
- Suffix
- Time Zone
- Website
- Keap Source ID
- UTM Campaign
- UTM Content
- UTM Medium
- UTM Source
- UTM Term
- Billing Address Country Code (e.g., USA)
- Billing Address Line 1
- Billing Address Line 2
- Billing Address City
- Billing Address Postal Code
- Billing Address Region (e.g., US-CA)
- Billing Address Zip Code
- Billing Address Zip Four
- Shipping Address Country Code (e.g., USA)
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address Postal Code
- Shipping Address Region (e.g., US-CA)
- Shipping Address Zip Code
- Shipping Address Zip Four
- Other Address Country Code (e.g., USA)
- Other Address Line 1
- Other Address Line 2
- Other Address City
- Other Address Postal Code
- Other Address Region (e.g., US-CA)
- Other Address Zip Code
- Other Address Zip Four
- Email Address 2
- Email Address 3
- Phone 1 Number
- Phone 1 Type
- Phone 1 Extension
- Phone 2 Number
- Phone 2 Type
- Phone 2 Extension
- Phone 3 Number
- Phone 3 Type
- Phone 3 Extension
- Phone 4 Number
- Phone 4 Type
- Phone 4 Extension
- Phone 5 Number
- Phone 5 Type
- Phone 5 Extension
- Fax 1 Number
- Fax 1 Type
- Fax 2 Number
- Fax 2 Type
- Facebook Account
- LinkedIn Account
- Twitter Account
- Instagram Account
- Snapchat Account
- YouTube Account
- Pinterest Account
Action
Write
- Company NameRequired
Action
Search
- FieldRequired
- ValueRequired
- Check for Duplicates UsingRequired
- Email Address 1
- Opt In
- Last Name
- First Name
- Tag IDs
- Anniversary Date (format: YYYY-MM-DD)
- Birth Date (format: YYYY-MM-DD)
- Company Name
- Company ID
- Contact Type
- Job Title
- Lead Source ID
- Middle Name
- Origin IP Address
- Owner ID
- Preferred Locale
- Preferred Name
- Prefix
- Source Type
- Spouse Name
- Suffix
- Time Zone
- Website
- Keap Source ID
- UTM Campaign
- UTM Content
- UTM Medium
- UTM Source
- UTM Term
- Billing Address Country Code (e.g., USA)
- Billing Address Line 1
- Billing Address Line 2
- Billing Address City
- Billing Address Postal Code
- Billing Address Region (e.g., US-CA)
- Billing Address Zip Code
- Billing Address Zip Four
- Shipping Address Country Code (e.g., USA)
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address Postal Code
- Shipping Address Region (e.g., US-CA)
- Shipping Address Zip Code
- Shipping Address Zip Four
- Other Address Country Code (e.g., USA)
- Other Address Line 1
- Other Address Line 2
- Other Address City
- Other Address Postal Code
- Other Address Region (e.g., US-CA)
- Other Address Zip Code
- Other Address Zip Four
- Email Address 2
- Email Address 3
- Phone 1 Number
- Phone 1 Type
- Phone 1 Extension
- Phone 2 Number
- Phone 2 Type
- Phone 2 Extension
- Phone 3 Number
- Phone 3 Type
- Phone 3 Extension
- Phone 4 Number
- Phone 4 Type
- Phone 4 Extension
- Phone 5 Number
- Phone 5 Type
- Phone 5 Extension
- Fax 1 Number
- Fax 1 Type
- Fax 2 Number
- Fax 2 Type
- Facebook Account
- LinkedIn Account
- Twitter Account
- Instagram Account
- Snapchat Account
- YouTube Account
- Pinterest Account
Action
Search or write

About Keap

Keap is your all-in-one CRM, sales and marketing automation software that helps organize leads, land the job, get paid, and keep growing.

Help

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 Help

Related categories

Databases

Similar apps

MySQL

Databases

PostgreSQL

Databases

Firebase / Firestore

Databases

PRODUCTS

CAPABILITIES

By team

Keap + SQL Server

Handle SQL Server new or updated rows by creating or updating contacts in Keap

New Column

New Row (Custom Query)

QueryRequired

New or Updated Row

Table/ViewRequired

Primary KeyRequired

Order ByRequired

Trigger Column

Update Row

TableRequired

ID ColumnRequired

Find Multiple Rows via Custom Query

QueryRequired

New Action Sequence

New Appointment Event

Appointment events this trigger will listen to:Required

New Contact

New Note Event

Note events this trigger will listen to:Required

New Product Event

Product events this trigger will listen to:Required

New Subscription Plan

New Task (All Tasks)

Task events this trigger will listen to:Required

New Invoice

New Payment (All Payment Type)

New Assigned Task

Opportunity Stage Moved

Create Company

Company NameRequired

Country Code (e.g., "USA")

Address Line 1

Address Line 2

Locality

Region (e.g., "US-CA")

Zip Code

Zip Four

Phone Number

Phone Ext

Notes

Email Address

Fax Number

Website

Create Note

Contact IdRequired

BodyRequired

Title

Type

User Id

Add a Product to an Invoice

Invoice IDRequired

Product

Product QuanityRequired

Price Override

Send Email

UserRequired

ContactsRequired

SubjectRequired

HTML Content

Plain Text Content

Email Address Field

Attachments

Update Company

Company IDRequired

Company Name

Email AddressRequired

Website

Notes

Opt-In

Address Country Code

Address Street (Line 1)

Address Street (Line 2)

Address City

Address State

Address Zip Code