Loops + PostgreSQL

Update contacts in Loops when new rows are added in PostgreSQL through a custom query

Keep your Loops contacts updated conveniently with this efficient, time-saving workflow. When a new row appears in your PostgreSQL database according to your tailored query, this setup promptly revises the relevant entry in Loops. This workflow boosts your data management productivity and minimises the likelihood of errors.

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!
Update Contact
Updates the properties of a contact in your audience.
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

- EmailRequired
- First Name
- Last Name
- Source
- Subscribed
- User Group
- User ID
- Mailing Lists
Action
Write
- Email
- User ID
- Event NameRequired
- Event Properties
- Mailing Lists
Action
Write

- EmailRequired
- First Name
- Last Name
- Source
- Subscribed
- User Group
- User ID
- Mailing lists
Action
Write
- EmailRequired
- First Name
- Last Name
- Source
- Subscribed
- User Group
- User ID
- Mailing Lists
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
- EmailRequired
Action
Write
- Transactional IdRequired
- EmailRequired
- Add contact to your audience
- Data Variables
Action
Write
- Contact EmailRequired
Action
Search

About Loops

Loops is a platform for SaaS companies to send marketing and transactional email.

Learn more

Related categories

Email Newsletters

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