SENDSLACK formula

Lido's SENDSLACK formula allows you to send messages directly from Lido to Slack.

Lido's SENDSLACK formula allows you to send messages directly from Lido to Slack.

=SENDSLACK(<your Slack credential>, channel, message, [status])

Let's walk through a quick example to illustrate all three parts of this formula. You can also click here for a video tutorial.

Workspace

You can find your workspace name in the upper left corner in Slack.

For my SENDSLACK formula, we'll want to pass "Lido" through as our workspace argument.

=SENDSLACK(<your Slack credential>, channel, message)

Note that workspace should be the name of the workspace, and NOT the Slack URL (e.g. lido.slack.com)

Authenticating into your Slack workspace

When you add your Slack credential for the first time, you'll be directed to Slack to authenticate.

If you're a member of multiple workspaces, you may need to switch to the correct workspace on this screen:

Click here for a video showing you the quick authentication process that you only need to complete once.

Channel

This is the name of the channel where you want to send your message. So, for example, if I want to send a message to Lido's #random channel, my formula will look like this:

=SENDSLACK(<your Slack credential>, "#random", message)

Sending a direct message

You can send a direct message to an individual via their @ mention name. This is the same @Name that you would use to mention them in Slack.

=SENDSLACK(<your Slack credential>, "@RecipientName", message)

Sending a message to a group

To send a message to a private conversation with two or more individuals, you will need to locate the Channel ID.

=SENDSLACK(<your Slack credential>, "C151H6JFLTO", message)

Right click on the conversation in Slack and select View conversation details.

Then, click About.

And at the bottom of the window you should see the Channel ID. Copy this and use it in your formula.

Message

Your message can be anything you want! You can pass through the contents of another cell, directly write a string, or concatenate together a combination of the two.

Currently Lido support's Slack text only. You can learn more about ways to format Slack test from Slack's documentation: https://api.slack.com/reference/surfaces/formatting

@ Mentioning users in your message

To create an @ mention in your message, you need to pass through their member ID in this syntax:

"Hi <@USER_ID>, how are you?"

Note that USER_ID is different from someone's display name. You can locate someone's USER ID in Slack by going to their profile.

So to send a message @Ben, our formula will look like:

=SENDSLACK(<your Slack credential>, "random", "Hi <@U03DF7G50TA>"