ActiveCampaign + SQL Server

ActiveCampaign + SQL Server integrations

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 ContactCreates a new contact, or updates an existing contact.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with SQL Server and ActiveCampaign

Discover other triggers and actions you can use with SQL Server and ActiveCampaign

- Table/View
  Required
Trigger
Polling
Try It
- Query
  Required
Trigger
Polling
Try It
- Table/View
  Required
- Primary_key
  Required
- Order_by
  Required
- Trigger_column
Trigger
Polling
Try It
- DisclaimerCopy
- Query
  Required
Action
Write
- Table
  Required
- ID Column
  Required
Action
Write

- Query
  Required
Action
Search
- Custom Object
  Required
- Trigger Events
  Required
Trigger
Instant
Try It

- Task Type (Optional)
Trigger
Instant
Try It
Contact Joined Inbound WhatsApp Messaging Flow
Triggers when a contact sends a message that starts an inbound WhatsApp messaging flow.
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
- List
  Required
Trigger
Instant
Try It
- List
  Required
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
- List
  Required
- Importer_note
Trigger
Instant
Try It
- List
- Skip Unsubscribe Events
- Importer_note
Trigger
Instant
Try It
- Name
  Required
- Website
- Owner
Action
Write
- Account ID
- Name
  Required
- Update Only
  Required
- Account Owner
- Website
Action
Write
- Title
  Required
- Value
  Required
- Owner
- Currency
  Required
- Pipeline
  Required
- Stage
  Required
- Account
- Contact Email Address
Action
Write
- Automation
  Required
- Automation Run
  Required
- Contact ID
  Required
Action
Write
- Contact ID
  Required
- Account ID
  Required
- Job Title
Action
Write
- Contact ID
- Contact Email
- Action
  Required
- Existing Tags
- Tags
Action
Write
- Custom Object
  Required
- Record ID
- External ID
Action
Write
- Title
  Required
- Value
  Required
- Owner
- Currency
  Required
- Pipeline
  Required
- Stage
  Required
- Account ID
- Contact ID
- Description
Action
Write
- Task ID
- Title
- Deal ID
  Required
- Note
- Due Date
  Required
- End Date
- Task Type
  Required
- Assignee
Action
Write
- WhatsApp Phone Number
  Required
- Flow to start
  Required
- First Name
- Last Name
- Email
- External URL
- Custom properties
Action
Write
- Event Key
  Required
- Event Account ID
  Required
- Event Name
  Required
- Event Value
- Contact Email Address
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- ID
- Email Address
- Phone Number
Action
Search
- Deal Title
- Contact Email
Action
Search
- Deal Task Title
  Required
- Deal ID
Action
Search
- Template Name
Action
Search

- Table/View
  Required
- Order_by
- Dedupe_key
Trigger
Polling
Try It
New Table
Triggers when you add a new table.
Trigger
Polling
Try It
- Query
  Required
Trigger
Polling
Try It
- Table
  Required
Action
Write
- Table
  Required
- Lookup Column
  Required
- Lookup_value
  Required
Action
Search
- Query
  Required
Action
Search
- Custom Object
  Required
Trigger
Instant
Try It
Contact Completed WhatsApp Messaging Flow
Triggers when a contact completes a WhatsApp messaging flow.
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
- List
  Required
Trigger
Instant
Try It
- List
  Required
Trigger
Instant
Try It
- List
  Required
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
- List
  Required
Trigger
Instant
Try It
- Event
  Required
- Tag
Trigger
Instant
Try It
- Account ID
  Required
- Name
- Website
Action
Write
- List
- ID
- Email Address
- First Name
- Last Name
- Full Name
- Phone Number
- Tags
- Organization Name
- Job Title
Action
Write
- Automation
  Required
- Subscriber Email
  Required
Action
Write
- Email Message
  Required
- List
  Required
- Campaign Name
  Required
Action
Write
- Contact ID
  Required
- List ID
  Required
- Note
  Required
Action
Write
- Task ID
- Title
- Contact ID
  Required
- Note
- Due Date
  Required
- End Date
- Task Type
  Required
- Assignee
Action
Write
- Contact ID
  Required
- Deal ID
  Required
- Role
Action
Write
- Deal
  Required
- Note
  Required
Action
Write
- Deal
  Required
- Title
- Value
- Currency
- Owner
- Pipeline
- Stage
- Account ID
- Contact ID
- Status
- Description
Action
Write
- Action
  Required
- List ID
  Required
- Contact ID
- Email Address
Action
Write
- WhatsApp Phone Number
  Required
- WhatsApp Template to send
  Required
Action
Write
- Name
  Required
Action
Search
- Contact Task Title
  Required
- Contact ID
Action
Search
- Title
- Contact Email
Action
Search
- Email
  Required
Action
Search

About ActiveCampaign

ActiveCampaign is an autonomous marketing platform built to transform how marketers, agencies, and business owners work.

Learn moreLearn moreHelpHelp

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 moreLearn moreHelpHelp

Related categories

Databases

Premium

Similar apps

MySQL

Databases

PostgreSQL

Databases

Firebase / Firestore

Databases

Related Zap Templates

Create new SQL Server rows for new or updated ActiveCampaign contacts