Integration spotlight: Slack

Overview

Did you know that you can send message to your Slack workspace straight from a spreadsheet? Well, if you didn’t - you’ll know exactly how to after having a look at our Slack integration.

Functions

Function Description
LIST_CHANNELS_SLACK Get a list of your Slack channels.
LIST_USERS_SLACK Get a list of your Slack users.
MESSAGE_CHANNEL_SLACK Send a message to Slack channel.
MESSAGE_USER_SLACK Send a message to a Slack user.

LIST_CHANNELS_SLACK

Use LIST_CHANNELS_SLACK to get all the channels in your Slack workspace. You can use these recommended tables to quickly get some data:

  • Slack channels to just get the channel names and the number of members
  • Channel properties to get the channel names, topics, and purposes
  • Channel settings to see your membership status for a given channel and whether it is general, shared, or private.

Syntax

LIST_CHANNELS_SLACK()

And that’s it :wink:

Examples

=LIST_CHANNELS_SLACK()

List channels example

LIST_USERS_SLACK

Use LIST_USERS_SLACK to get all the users in your Slack workspace. You can use these recommended tables to quickly get some data:

  • Slack users to just get the user names and real names of your Slack users
  • User properties to get real and display names, titles, phone numbers, Skype IDs, and statuses
  • User settings to get whether or not the users are admins, owners, restricted, bots, or app users.

Syntax

LIST_USERS_SLACK()

Yep - it’s that easy.

Examples

To get the users connected to you Slack workspace:

=LIST_USERS_SLACK()

List users example

MESSAGE_CHANNEL_SLACK

Use MESSAGE_CHANNEL_SLACK when you want to message a whole Slack channel straight from your spreadsheet (great for automated announcements). And if you want to get the status of your message after you’ve sent it, just use the Message status recommended row.

BTW, you can apply some formatting to your messages.

Syntax

MESSAGE_CHANNEL_SLACK(channel, message)

Parameter Mandatory Description
channel Yes Channel name or ID. Use LIST_CHANNELS_SLACK() to find the correct channel name of ID.
message Yes The message to send. For example: "Hey there! This was sent from dashdash". Supports basic Markdown styling.

Examples

If you want to send a message to a channel by the name of ******* with an uplifting Morning _cell_ mates! message:

=MESSAGE_CHANNEL_SLACK("*******","Morning _cell_ mates!")

Message channel example

MESSAGE_USER_SLACK

Use MESSAGE_USER_SLACK when you want to message your Slack users straight from your spreadsheet - really handy if you want to send an automatic birthday message (and more). And if you want to get the status of your message after you’ve sent it, just use the Message status recommended row.

BTW, you can apply some formatting to your messages.

Syntax

MESSAGE_USER_SLACK(user, message)

Parameter Mandatory Description
user Yes The username of the Slack person. For example: "john.doe". Use LIST_USERS_SLACK() to find the correct username.
message Yes The message to send. For example: "Hey there! This was sent from dashdash". Supports basic Markdown styling.

Examples

If you want to send a message to ************ with the classy pun If I make any more jokes about spreadsheets, I'll be locked in a cell 🤣:

=MESSAGE_USER_SLACK("************","If I make any more jokes about spreadsheets, I'll be locked in a cell 🤣")

Message user example

Summary

Right - so now you’ve got the tools, and the only limit is your mind’s creation :slight_smile: But to give it a bit of a quick start, have a look at these templates we’ve made:

Now, quit slacking off and build :rocket:!

1 Like