Mailchimp + PostgreSQL

Add new Mailchimp subscribers for new custom query matches on PostgreSQL

If you're identifying potential newsletter subscribers on PostgreSQL by using custom queries, we recommend you activate this Zap to save yourself some time. Once you do, any new row found to match your custom query on PostgreSQL will automatically trigger this integration, adding a subscriber to Mailchimp so that you can be sure your marketing efforts are supported by the latest customer data at all times.

When this happens...
New Row (Custom Query)
Triggers when new rows are returned from a custom query that you provide. Advanced Users Only.
TriggerScheduled
automatically do this!
Add/Update Subscriber
Add a new subscriber to an audience of your choosing. Can be used to update an existing subscriber too.
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
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

- Audience
- Status
Trigger
Scheduled
Try It
- Audience
- LinkRequired
- Track all links clicks
Trigger
Scheduled
Try It

- StoreRequired
Trigger
Scheduled
Try It
- Store
Trigger
Scheduled
Try It
- AudienceRequired
- Segment or TagRequired
Trigger
Scheduled
Try It
- AudienceRequired
- Email AddressRequired
Action
Write
- CampaignRequired
Action
Write
- AudienceRequired
- Tag nameRequired
Action
Write
- NameRequired
- CompanyRequired
- Address 1Required
- Address 2
- CityRequired
- StateRequired
- ZipRequired
- CountryRequired
- Phone
- Permission ReminderRequired
- Email Type OptionRequired
- From NameRequired
- From EmailRequired
- SubjectRequired
- LanguageRequired
- Notify On Subscribe
- Notify On Unsubscribe
- Double Optin
- Marketing Permissions
- Use Archive Bar
Action
Write
- AudienceRequired
- Email AddressRequired
- Delete Contact
Action
Write
- CampaignRequired
Action
Write
- AudienceRequired
- TagRequired
- Email AddressRequired
Action
Write
- NameRequired
Action
Search
- AudienceRequired
- Tag nameRequired
Action
Search
- NameRequired
- Campaign Name
- AudienceRequired
- Segment or Tag
- Email SubjectRequired
- Preview Text
- From NameRequired
- From Email AddressRequired
- To Name
- Content Type
Action
Search or write
- SearchRequired
- Audience
- AudienceRequired
- Subscriber EmailRequired
- New Email
- StatusRequired
- Double Opt-In
- Update Existing
- Replace Groups
- Groups
- Language Code
- Tag(s)
Action
Search or write

- Table/ViewRequired
- Order By
- Dedupe Key
Trigger
Scheduled
Try It
New Table
Triggers when you add a new table.
Trigger
Scheduled
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- QueryRequired
Action
Search
- Audience
- Trigger each time a subscriber opens an email
Trigger
Scheduled
Try It
New Audience
Triggers when a new audience is added to your MailChimp accounts.
Trigger
Scheduled
Try It
- AudienceRequired
- Note About Samples
Trigger
Instant
Try It
- AudienceRequired
Trigger
Instant
Try It
- AudienceRequired
- Note About Samples
Trigger
Instant
Try It
- Campaign Name
- AudienceRequired
- Segment or Tag
- Email SubjectRequired
- Preview Text
- From NameRequired
- From Email AddressRequired
- To Name
- Content Type
Action
Write
- CampaignRequired
Action
Write
- AudienceRequired
- Email AddressRequired
- Custom Event NameRequired
- Properties
Action
Write
- AudienceRequired
- Subscriber EmailRequired
- New Email
- StatusRequired
- Double Opt-In
- Update Existing
- Replace Groups
- Groups
- Language Code
- Tag(s)
Action
Write
- AudienceRequired
- TagRequired
- Email AddressRequired
Action
Write
- AudienceRequired
- Email AddressRequired
- NoteRequired
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- StoreRequired
- Email AddressRequired
Action
Search
- SearchRequired
- Audience
Action
Search
- AudienceRequired
- Tag nameRequired
Action
Search or write

About Mailchimp

Share your ideas with Mailchimp email newsletters—then use its landing page and form builders to grow your lists and take marketing further with drip and transactional emails.

Learn more

Related categories

Email Newsletters

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