Email by Zapier + PostgreSQL

Send outbound emails in Email by Zapier for new rows from custom queries in PostgreSQL

Stay on top of your database changes with this handy workflow. Whenever a new row is added to your PostgreSQL database through a custom query, an email will be sent to your chosen recipient via Email by Zapier. This seamless automation ensures you never miss important updates, keeping you informed and in control of your data.

When this happens...
New Row (Custom Query)
Triggered when new rows are returned from a custom query that you provide. Advanced Users Only
TriggerScheduled
automatically do this!
Send Outbound Email
Send up to 5 emails per day on Free or Trial Zapier plans, or up to 10 emails per hour on paid Zapier plans from a custom zapiermail.com address.
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

- Email AddressRequired
Trigger
Instant
Try It
- Free Test Limitation
- ToRequired
- SubjectRequired
- Body (HTML or Plain)Required
- Attachment
- From Name
- Reply To
- Cc
- Bcc
- Force Linebreaks?
- Enable read receipts?
Action
Write

- 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
- Setup Directions
Trigger
Instant
Try It

About Email by Zapier

Send and receive email via a custom Zapier email address at "zapiermail.com". This is great for triggering off of emails and sending custom emails. (Max of 10 email sends per hour.) Have direct access to your own email servers? Check out our IMAP and SMTP services!

Learn more

Related categories

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