PostgreSQL + Slack

Send Slack direct messages for new PostgreSQL rows (custom query).

Keep your team informed and up-to-date with this easy-to-implement workflow. Whenever a new row is added to your PostgreSQL database using a custom query, a direct message will be sent on Slack to the designated recipient. This way, you can quickly share relevant information and ensure that everyone stays on the same page without having to manually monitor database updates.

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 Direct Message
Send a direct message to a user or yourself from the Slackbot. Can also schedule a message for later.
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

New Channel
Triggers whenever a new #channel is created.
Trigger
Instant
Try It
- Include Alias
Trigger
Instant
Try It

- User Name
- Highlight Word
- Trigger for Bot Messages?
Trigger
Instant
Try It
New Pushed Message
Triggers when you click the "Push to Zapier" button from a message in Slack.
Trigger
Instant
Try It
New Saved Message
Triggers when you save a message.
Trigger
Instant
Try It
- TextRequired
- Remind when?Required
- Remind who?
Action
Write
- ChannelRequired
- Message TextRequired
- Send as a bot?
- Bot Name
- Bot Icon
- Include a link to this Zap?
- Attach Image by URL
- Auto-Expand Links?
- Link Usernames and Channel Names?
- Schedule At
- Zap Id
- File
- Thread
- Send Channel Message?
Action
Write
- Channel NameRequired
Action
Write
- ChannelRequired
- TopicRequired
Action
Write
- Status Text
- Status Emoji
- Expiration Time
Action
Write
Delete Message
This action deletes an existing message in a specific channel on Slack. You need to provide the channel ID and the message timestamp as inputs.
Action
Write
- Search QueryRequired
- Sort By
- Sort Direction
Action
Search
- IDRequired
- Return Raw Results?
Action
Search
- UsernameRequired
- Return Raw Results?
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
- Trigger for Bot Messages?
Trigger
Instant
Try It
- ChannelRequired
- Trigger for Bot Messages?
Trigger
Instant
Try It
- Channel
- User Name
- Shared
Trigger
Instant
Try It
- ChannelRequired
- Trigger for Bot Messages?
Trigger
Instant
Try It
- Reaction
- Channel
- User
Trigger
Instant
Try It
New User
Triggers when a new Slack user is created / first joins your org.
Trigger
Instant
Try It
- ChannelRequired
- UsersRequired
Action
Write
- Send Multi Message
- Message TextRequired
- Send as a bot?
- Bot Name
- Bot Icon
- Include a link to this Zap?
- Attach Image by URL
- Auto-Expand Links?
- Link Usernames and Channel Names?
- Schedule At
- Zap Id
Action
Write
- ChannelRequired
- Message TextRequired
- Send as a bot?
- Bot Name
- Bot Icon
- Include a link to this Zap?
- Attach Image by URL
- Auto-Expand Links?
- Link Usernames and Channel Names?
- Schedule At
- Zap Id
- File
- Thread
- Send Channel Message?
Action
Write
- First Name
- Last Name
- Title
- Email
- User
Action
Write
- Raw Request User Info
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
Create Private Channel
This action creates a private channel in Slack.
Action
Write
- EmailRequired
- Return Raw Results?
Action
Search
- Full NameRequired
- Return Raw Results?
Action
Search

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 Help

Related categories

Databases

Similar apps

MySQL

Databases

SQL Server

Databases

Amazon Relational Database Services (RDS)

Amazon, Databases

About Slack

Slack is a platform for team communication: everything in one place, instantly searchable, available wherever you go. Offering instant messaging, document sharing and knowledge search for modern teams.

Learn more Help

Related categories

Team Chat

Similar apps

Chatwork

Team Chat

Microsoft Teams

Microsoft, Team Chat

Twist

Team Chat

PRODUCTS

CAPABILITIES

By team

PostgreSQL + Slack

Send Slack direct messages for new PostgreSQL rows (custom query).

New Column

New Row (Custom Query)

QueryRequired

New or Updated Row

Table/ViewRequired

Primary KeyRequired

Order ByRequired

Trigger Column

Update Row

TableRequired

ID ColumnRequired

Find Row via Custom Query

QueryRequired

New Channel

New Team Custom Emoji

Include Alias

New Mention

User Name

Highlight Word

Trigger for Bot Messages?

New Pushed Message

New Saved Message

Add Reminder

TextRequired

Remind when?Required

Remind who?

Send Channel Message

ChannelRequired

Message TextRequired

Send as a bot?

Bot Name

Bot Icon

Include a link to this Zap?

Attach Image by URL

Auto-Expand Links?

Link Usernames and Channel Names?

Schedule At

Zap Id

File

Thread

Send Channel Message?

Create Channel

Channel NameRequired

Set Channel Topic

ChannelRequired

TopicRequired

Set Status

Status Text

Status Emoji

Expiration Time

Delete Message

Find Message

Search QueryRequired

Sort By

Sort Direction

Find User by ID

IDRequired

Return Raw Results?

Find User by Username

UsernameRequired

Return Raw Results?

New Row

Table/ViewRequired

Order By

Dedupe Key

New Table

New Row

TableRequired

Find Row

TableRequired

Lookup ColumnRequired

Lookup ValueRequired

New Public Message Posted Anywhere

Trigger for Bot Messages?

New Message Posted to Channel