ActiveCampaign + SQL Server

Create or update ActiveCampaign contacts from new SQL Server rows (custom query)

Make your marketing efforts more efficient with this automation. As soon as new data is entered into your SQL Server via a custom query, a contact is created or updated in ActiveCampaign. This workflow allows for consistent data transfer between your database and marketing tools, saving time and ensuring accurate, up-to-date marketing campaigns.

When this happens...
New Row (Custom Query)
Triggered when new rows are returned from a custom query that you provide. Advanced Users Only
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

- Custom ObjectRequired
Trigger
Instant
Try It
New or Updated Account
Triggers when a new account is added or an existing account's details are updated.
Trigger
Instant
Try It

- ListRequired
Trigger
Instant
Try It
- ListRequired
Trigger
Instant
Try It
- ListRequired
Trigger
Instant
Try It
- Task type
Trigger
Instant
Try It
New Deal Task
Triggers when a new deal task is created.
Trigger
Instant
Try It
- ListRequired
- Importer Note
Trigger
Instant
Try It
- List
- Skip Unsubscribe Events
- Importer Note
Trigger
Instant
Try It
- NameRequired
- Website
Action
Write
- List
- ID
- Email Address
- First Name
- Last Name
- Full Name
- Phone Number
- Tags
- Organization Name
- Job Title
Action
Write
- AutomationRequired
- Subscriber EmailRequired
Action
Write
- Email MessageRequired
- ListRequired
- Campaign NameRequired
Action
Write
- Contact IDRequired
- List IDRequired
- NoteRequired
Action
Write
- Task ID
- Title
- Contact IDRequired
- Note
- Due DateRequired
- End Date
- Task TypeRequired
- Assignee
Action
Write
- Contact IDRequired
- Deal IDRequired
- Role
Action
Write
- DealRequired
- NoteRequired
Action
Write
- DealRequired
- Title
- Value
- Currency
- Owner
- Pipeline
- Stage
- Account ID
- Contact ID
- Status
- Description
Action
Write
- Event KeyRequired
- Event Account IDRequired
- Event NameRequired
- Event Value
- Contact Email Address
Action
Write
- NameRequired
Action
Search
- Contact Task TitleRequired
- Contact ID
Action
Search
- Title
- Contact Email
Action
Search
- EmailRequired
Action
Search

- 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
- Custom ObjectRequired
- Trigger EventsRequired
Trigger
Instant
Try It
- Task Type (Optional)
Trigger
Instant
Try It
New Automation Webhook
Triggers when an automation sends out webhook data. To add a webhook in ActiveCampaign, navigate to your Automations section, add or edit an automation, and create a new "Webhook" action.
Trigger
Instant
Try It
- ListRequired
Trigger
Instant
Try It
- ListRequired
Trigger
Instant
Try It
- List (Deprecated)
Trigger
Instant
Try It
New Deal Note
Triggers when a new deal note is created.
Trigger
Instant
Try It
New Deal Added or Updated
Triggers when a new deal is created or existing deal is updated.
Trigger
Instant
Try It
- ListRequired
Trigger
Instant
Try It
- EventRequired
- Tag
Trigger
Instant
Try It
- Account IDRequired
- Name
- Website
Action
Write
- TitleRequired
- ValueRequired
- Owner
- CurrencyRequired
- PipelineRequired
- StageRequired
- Account
- Contact Email Address
Action
Write
- AutomationRequired
- Automation RunRequired
- Contact IDRequired
Action
Write
- Contact IDRequired
- Account IDRequired
- Job Title
Action
Write
- Contact IDRequired
- ActionRequired
- Existing Tags
- Tags
Action
Write
- Custom ObjectRequired
- Record ID
- External ID
Action
Write
- TitleRequired
- ValueRequired
- Owner
- CurrencyRequired
- PipelineRequired
- StageRequired
- Account ID
- Contact ID
- Description
Action
Write
- Task ID
- Title
- Deal IDRequired
- Note
- Due DateRequired
- End Date
- Task TypeRequired
- Assignee
Action
Write
- ActionRequired
- List IDRequired
- Contact ID
- Email Address
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- ID
- Email Address
Action
Search
- Deal Title
- Contact Email
Action
Search
- Deal Task TitleRequired
- Deal ID
Action
Search

About ActiveCampaign

ActiveCampaign is a customer experience automation (CXA) platform that helps businesses meaningfully engage customers. Access pre-built automations that combine transactional email and email marketing, marketing automation, ecommerce marketing, and CRM for powerful segmentation and personalization across social, email, messaging, chat, and text.

Help

Related categories

Marketing Automation

Similar apps

AWeber

Email Newsletters

HubSpot

Marketing Automation

Constant Contact

Email Newsletters

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

ActiveCampaign + SQL Server

Create or update ActiveCampaign contacts from new SQL Server rows (custom query)

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 Row via Custom Query

QueryRequired

Custom Object Record Deleted

Custom ObjectRequired

New or Updated Account

New Campaign Bounce

ListRequired

New Campaign Open

ListRequired

New Campaign Unsubscribe

ListRequired

New Contact Task

Task type

New Deal Task

New Contact Added to List

ListRequired

Importer Note

New or Updated Contact

List

Skip Unsubscribe Events

Importer Note

Create Account

NameRequired

Website

Create or Update Contact

List

ID

Email Address

First Name

Last Name

Full Name

Phone Number

Tags

Organization Name

Job Title

Add Existing Contact to Automation

AutomationRequired

Subscriber EmailRequired

Create Campaign

Email MessageRequired

ListRequired

Campaign NameRequired

Add Contact Note

Contact IDRequired

List IDRequired

NoteRequired

Create or Update Contact Task

Task ID

Title

Contact IDRequired

Note

Due DateRequired

End Date

Task TypeRequired

Assignee

Add Secondary Contact to Deal

Contact IDRequired

Deal IDRequired

Role

Add Note to Deal

DealRequired

NoteRequired

Update Deal

DealRequired