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)
Triggers when new rows are returned from a custom query that you provide. Advanced Users Only.
TriggerPolling
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

- 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
- 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
- Importer Note
Trigger
Instant
Try It
- List
- Skip Unsubscribe Events
- Importer Note
Trigger
Instant
Try It
- NameRequired
- Website
- Owner
Action
Write
- Account ID
- NameRequired
- Update OnlyRequired
- Account Owner
- 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 ID
- Contact Email
- 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
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- ID
- Email Address
- Phone Number
Action
Search
- Deal Title
- Contact Email
Action
Search
- Deal Task TitleRequired
- Deal ID
Action
Search

- 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
- 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
- Importer Note
Trigger
Instant
Try It
- ListRequired
Trigger
Instant
Try It
- EventRequired
- Tag
Trigger
Instant
Try It
- Account IDRequired
- Name
- 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

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.

Learn more

Related categories

Marketing Automation

Similar apps

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

Related Zap Templates

Create new SQL Server rows for new or updated ActiveCampaign contacts

ActiveCampaign + SQL Server

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

Supported triggers and actions

New Column

New Row (Custom Query)

New or Updated Row

Create Custom Query

Update Row

Find Multiple Rows via Custom Query

New or Updated Custom Object Record

Deal Task Completed

New Automation Webhook

New Campaign Link Click

New Campaign Starts Sending

New Contact Note

New Deal Note

New Deal Added or Updated

Contact Added to List

New or Updated Contact

Create Account

Create or Update Account

Create Deal (Deprecated)

Remove Contact From Automation

Add Contact to Account

Add/Remove Tag From Contact

Create or Update a Custom Object Record

Create Deal

Create or Update Deal Task

Subscribe or Unsubscribe Contact From List

API Request (Beta)

Find Contact

Find Deal

Find Deal Task

New Row

New Table

New or Updated Row (Custom Query)

New Row

Find Row

Find Row via Custom Query

Custom Object Record Deleted

New or Updated Account

New Campaign Bounce

New Campaign Open

New Campaign Unsubscribe

New Contact Task

New Deal Task

New Contact

Updated Contact

Tag Added or Removed From Contact

Update Account

Create or Update Contact

Add Existing Contact to Automation

Create Campaign

Add Contact Note

Create or Update Contact Task

Add Secondary Contact to Deal

Add Note to Deal

Update Deal

Create Tracked Event

Find Account

Find Contact Task

Find Deal Owner

Find User

About ActiveCampaign

Related categories

Similar apps

AWeber

HubSpot

Constant Contact

About SQL Server

Related categories

Similar apps

MySQL

PostgreSQL

Firebase / Firestore

Related Zap Templates

Related Zap Templates