ActiveCampaign + PostgreSQL

Create or update ActiveCampaign contacts from new PostgreSQL rows

Effortlessly keep your contact database updated with this convenient PostgreSQL to ActiveCampaign workflow. Whenever a new row is added to your PostgreSQL database, the corresponding contact will be created or updated within ActiveCampaign. This efficient automation helps maintain an accurate contact list, saving you valuable time for more important tasks.

When this happens...
New Row
Triggered when you add a new row.
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 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
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- 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
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
- 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.

Related categories

Marketing Automation

Similar apps

About PostgreSQL

PostgreSQL is a powerful, open-source database engine with a uniquely advanced query optimizer and dozens of built in features, making it an easy choice for production databases.

Learn more

Related categories

Databases

ActiveCampaign + PostgreSQL

Create or update ActiveCampaign contacts from new PostgreSQL rows

New Column

New Row (Custom Query)

New or Updated Row

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

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

Related categories

Similar apps

MySQL

SQL Server

Amazon Relational Database Services (RDS)

Related Zap Templates

Related Zap Templates