Google BigQuery + Slack

Run a query in Google BigQuery for each new message posted to a private channel in Slack

When a new message is posted to a private channel in Slack, this workflow swiftly carries out a designated query in Google BigQuery. It streamlines information retrieval from massive datasets, transforming a potentially laborious task into an effortless process. This eliminates time wasted manually running queries every time new information surfaces in your Slack channels, ensuring valuable insights are always readily available.

When this happens...
New Message Posted to Private Channel
Triggers when a new message is posted to a specific #private-channel or multi-dm.
TriggerInstant
automatically do this!
Run a Query
Runs a SQL query against a table in BigQuery.
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

- 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
- ChannelRequired
- Trigger for Bot Messages?
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
- 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
- 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
Remove User from Channel
This action removes a specified user from a specified channel in Slack.
Action
Write
Create Private Channel
This action creates a private 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
- Conversation IDRequired
Action
Search
- Conversation IDRequired
- Message ID (ts)Required
Action
Search
- EmailRequired
- Return Raw Results?
Action
Search
- Full NameRequired
- Return Raw Results?
Action
Search
- ProjectRequired
- Dataset
- Table
Trigger
Polling
Try It
- Project IDRequired
- Job IDRequired
- LocationRequired
Trigger
Polling
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
Action
Write
- Project IDRequired
- SQL QueryRequired
- Location
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project IDRequired
- Job IDRequired
- LocationRequired
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?
Trigger
Instant
Try It
- Conversation
- Reaction
- Member
- Message author
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
- ChannelRequired
- UsersRequired
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
- 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
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
Retrieve Thread Messages
This action retrieves all the messages sent to a specific thread in a selected channel.
Action
Write
Find Public Channel
This action will find a public channel in Slack using either the channel's ID or name.
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
- Conversation IDRequired
- Message ID (ts)Required
Action
Search
- Search QueryRequired
- Sort By
- Sort Direction
Action
Search
- IDRequired
- Return Raw Results?
Action
Search
- UsernameRequired
- Return Raw Results?
Action
Search
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By ColumnRequired
- Unique ColumnRequired
Trigger
Polling
Try It
- Project IDRequired
- DatasetRequired
- TableRequired
- Unique ColumnRequired
- IS Operator
Trigger
Polling
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- RowsRequired
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
- Update ColumnsRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search
- ProjectRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search or write

About Google BigQuery

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Learn more

Related categories

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

Related categories

Team Chat

Google BigQuery + Slack

Run a query in Google BigQuery for each new message posted to a private channel in Slack

Supported triggers and actions

New Public Message Posted Anywhere

New Message Posted to Channel

New File

New Message From Query

New Message Posted to Private Channel

New Saved Message

Add Reminder

Send Channel Message

Create Channel

Request Approval

Update Profile

API Request (Beta)

Remove User from Channel

Create Private Channel

Edit Message

Get Conversation

Get Message Permalink

Find User by Email

Find User by Name

Query Job Completed (With Row Data)

New Job Completed

Create Row

Delete Rows

Run a Query

API Request (Beta)

Get Rows for Job Completed

New Channel

New Team Custom Emoji

New Mention

New Reaction Added

New Pushed Message

New User

Invite User to Channel

Send Direct Message

Send Private Channel Message

Set Channel Topic

Set Status

Delete Message

Retrieve Thread Messages

Find Public Channel

Get Message by Timestamp

Get Message

Find Message

Find User by ID

Find User by Username

New Row

Updated Row

Create Rows

Import Data

Update Row(s)

Find One Row

Find or Create Record

About Google BigQuery

Related categories

About Slack

Related categories

Similar apps

Chatwork

Microsoft Teams

Twist

Related Zap Templates

Related Zap Templates