ActiveCampaign + SQL Server

Create new SQL Server rows for new or updated ActiveCampaign contacts

Activate this workflow to keep your SQL Server database updated with the latest contact information from ActiveCampaign. Whenever a new or updated contact surfaces in ActiveCampaign, this automation inserts a new row in your SQL Server database, ensuring your customer details are always current. This workflow is useful for maintaining a consistent record across platforms, especially for businesses that rely heavily on accurate contact information.

When this happens...
New or Updated Contact
Triggers when a new contact is created or an existing contact's details are updated.
TriggerInstant
automatically do this!
New Row
Triggers when you add a new row.
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

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

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