Slack + SQL Server

Send channel messages in Slack for new or updated rows from SQL Server custom query

Stay up-to-date with your SQL Server data by instantly sharing new or modified row information in your desired Slack channel. This workflow comes into action whenever there's a new or updated row based on your custom query in SQL Server, promptly posting a channel message in Slack. Not only does this help keep your team informed about database changes, but also enhances communication and prompt action on data updates.

When this happens...
New or Updated Row (Custom Query)
Triggers when new or updated rows are returned from a custom query that you provide. Uses row contents for deduplication. Advanced Users Only.
TriggerPolling
automatically do this!
Send Channel Message
Triggers when a new message is posted to a specific #channel you choose.
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
Polling
Try It
- QueryRequired
Trigger
Polling
Try It
- Table/ViewRequired
- Primary KeyRequired
- Order ByRequired
- Trigger Column
Trigger
Polling
Try It
- Disclaimer Copy
- QueryRequired
Action
Write
- TableRequired
- ID ColumnRequired
Action
Write

- QueryRequired
Action
Search
- Trigger for Bot Messages?
- Optimized data
Trigger
Instant
Try It

- ChannelRequired
- Trigger for Bot Messages?
- Optimized data
Trigger
Instant
Try It
- Channel
- User Name
- Shared
Trigger
Instant
Try It
- Search QueryRequired
- Optimized data
Trigger
Polling
Try It
- Channel ID
- Reaction
- Member ID
- Message Author ID
Trigger
Instant
Try It
- Zap Identifier
- Access type
Trigger
Instant
Try It
New User
Triggers when a new Slack user is created / first joins your org.
Trigger
Instant
Try It
- TextRequired
- Remind when?Required
- Remind who?
Action
Write
- Conversation IDRequired
- Scheduled AsRequired
- Scheduled Message IDRequired
Action
Write
- ChannelRequired
- Add Zapier app to channel automatically?
- 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
- File
- Thread
- Send Channel Message?
- Zap Id
Action
Write
- Allowed Delete Copy
- Conversation IDRequired
- Message TS (ID)Required
- Posted By
Action
Write
- Canvas IDRequired
- OperationRequired
Action
Write
- Channel NameRequired
Action
Write
- Status Copy
- Approval request messageRequired
- Send message asRequired
- Approval typeRequired
- Zap Id
- Include a link to this Zap?
- Approve button URL
- Approve button label
- Add decline button
- Add details button
- Require confirmation
Action
Write
- First Name
- Last Name
- Title
- Email
- Display Name
- User
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
Get Message by Timestamp
This action retrieves a specific message from a conversation history in Slack using the message's timestamp.
Action
Write
Retrieve Thread Messages
This action retrieves all the messages sent to a specific thread in a selected channel.
Action
Write
Create Private Channel
This action creates a private channel in Slack.
Action
Write
- Conversation IDRequired
Action
Search
- Conversation IDRequired
- Message ID (ts)Required
Action
Search
- Conversation IDRequired
- Message TS (ID)Required
Action
Search
- EmailRequired
- Return Raw Results?
Action
Search
- Full NameRequired
- Return Raw Results?
Action
Search

- Table/ViewRequired
- Order By
- Dedupe Key
Trigger
Polling
Try It
New Table
Triggers when you add a new table.
Trigger
Polling
Try It
- QueryRequired
Trigger
Polling
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- QueryRequired
Action
Search
New Channel
Triggers when a new #channel is created.
Trigger
Instant
Try It
- Include Alias
Trigger
Instant
Try It
- Username
- Highlight Word
- Trigger for Bot Messages?
- Only Public Channels?
Trigger
Instant
Try It
- ChannelRequired
Trigger
Instant
Try It
- ChannelRequired
- Trigger for Bot Messages?
Trigger
Instant
Try It
New Saved Message
Triggers when you save a message.
Trigger
Instant
Try It
- ChannelRequired
- MessageRequired
- ReactionRequired
Action
Write
- Conversation IDRequired
Action
Write
- ChannelRequired
- UsersRequired
Action
Write
- Title
- Content
- Channel ID
Action
Write
- Send Multi Message
- Message TextRequired
- Send as a bot?
- Include a link to this Zap?
- Attach Image by URL
- Auto-Expand Links?
- Link Usernames and Channel Names?
- Schedule At
- Zap Id
Action
Write
- Allowed Edit Copy
- Conversation IDRequired
- Message TS (ID)Required
- Posted By
- Content Type
- Reply Broadcast
Action
Write
- ChannelRequired
- Add Zapier app to channel automatically?
- 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
- ChannelRequired
- TopicRequired
- Topic set by
Action
Write
- Status Text
- Status Emoji
- Expiration Time
Action
Write
Remove User from Channel
This action removes a specified user from a specified channel in Slack.
Action
Write
Edit Message
This action updates a specific message sent by the same Authenticated user on Slack. You need to provide the Channel ID, the Timestamp of the message to be edited, and the new text for the message.
Action
Write
Find Public Channel
This action will find a public channel in Slack using either the channel's ID or name.
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
- Conversation IDRequired
Action
Search
- Conversation IDRequired
- Message ID (ts)Required
Action
Search
- Search QueryRequired
- Sort By
- Sort Direction
- Include Bot Messages in Search Results?
Action
Search
- IDRequired
- Return Raw Results?
Action
Search
- UsernameRequired
- Return Raw Results?
Action
Search

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