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

=SENDSLACK(workspace, channel, message)

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("Lido", channel, message)

Authenticating into your Slack workspace

You'll be directed to Slack to authenticate the first time you use the SENDSLACK formula for any given workspace.

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. You'll want to pass through the name of the channel without the #. So, for example, if I want to send a message to Lido's #random channel, my formula will look like this:

=SENDSLACK("Lido", "random", message)

Sending a direct message

You can send a direct message to an individual or group by passing in your channel ID instead of a channel name. Go to the existing direct message in Slack that you want to send a message to, click on the person's name in the upper left corner, then scroll all the way down in the modal that pops up to find your channel ID.

So to send a direct message to my conversation with Val, my formula needs to look like this:

=SENDSLACK("Lido", "D03P27QSWCQ", message)

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("Lido", "random", "Hi <@U03DF7G50TA>"