Have you ever wanted to send a bunch of people the same message at the same time on Slack? But you didn’t want to just send it to a channel because then some of those people might ignore it? And a huge group DM is basically the worst kind of thing to do in Slack-etiquette?
Yeah, we’ve all been there before.
You have two options to do this:
Copy and paste the same message into a bunch of Slack windows and hit enter each time.
Use this doc and press a single button with a cool logo, which sends all the messages at once. (Bonus - it can even be automated).
This doc explains how to do the second option. You can see and use the template on the second page, called
How to set it up
(1) Connect your doc to Slack so you can send messages from it
In order to use Slack from your Coda doc, first you’ll have to connect your doc to Slack. Simply type “/” and start typing “Slack” and you’ll see some options appear. Choose the
option, which will prompt you to login to your Slack account through an authentication process (
). A security-related tl;dr - Coda doesn’t access your Slack data when you make this connection, but merely allows you to post messages to Slack.
More tips on setting up slack
If you haven’t already,
and when prompted, connect your Slack account using the Slack pack. You should see a dialog box prompting you to connect your account.
If for some reason that didn’t work, no worries! You can connect your Slack account by clicking
Explore > Packs > Import > Slack > Settings
. Then, add a new private account and sign in to your Slack account. To learn more, see
(1a) Optional - sync in your Slack directory for ease of accessing Slack users
If you want to bring in everyone in your company who uses Slack, you can select the
option above. It will sync in a table of all the people at your company who are in the Slack directory.
This will include metadata associated with each contact, such as Slack Handle, avatar, and email address (this is a good hack if you need a company directly quickly in Coda). You can choose to ignore deleted users - people who were at the company but who have left.
Not for the faint of heart (or really, for companies larger than a few hundred people).
(2) Add a People table - for who you want to ping, and the messages to send
Hit “/” again and add
and add a "people” column type. Be sure to turn off the "notify when added” and “subscribe to comments when added” so they don’t “hear” from you in the doc (though they wouldn’t anyway if they haven’t been invited to the doc yet). If you’ve done step 1a above, you can use that table for this instead, and add a column to filter out people you don’t want to include, as well as the additional columns outlined below.
Include the following columns
The people column itself
Slack Handle -
A text column of their Slack Handle. You can also direct the Slack button to send it to them via their email address (which you can pull from the email column using [person].[email].)
- What you want to send to them. You can get creative by using custom attributes in additional columns, and the
formula to combine attributes, to customize the message for people.
Slack Button -
The button that does the ping
- A column that will automatically populate when you send a message. You can use the
feature of the Button configuration to ensure you don’t send the same message twice, by excluding any row for which the results column has any data. This will gray out the button and make it un-pressable, including by other buttons (see below).
For more info on how to configure Slack buttons to send messages, check out
(3) Add the button that pushes buttons
Now for the fun part - add a button (use that
again) that pushes other buttons. (Select the action
from the options in the button configuration menu). Add a color, make it a big button (because big buttons are more important), and add an icon.
Now when you push that button, it’ll push all the other ones at once. 💣’s away!
3(a) Add an automation to push that button whenever you want
If you don’t want to send the message now, but want to send it in the future,
to push the button at a particular frequency. If you’ve set up the results column correctly above, even if you push the “big” button repeatedly, it won’t re-send the message since the smaller buttons are disabled.