SLACK.CHANNEL.MESSAGE
This is a premium feature.
Sends a message to specified Slack channel. This functions takes an optional JSON parameter to define more advanced settings and additional options. Please refer to https://api.slack.com/methods/chat.postMessage for more information about available and supported options (as of 2021-05-17).
Syntax
=SLACK.CHANNEL.MESSAGE(Token, TextOrJSON, [ChannelID], [ResponseTarget])
Arguments
| Name | Description |
|---|---|
| Token | A token which is registered to a workspace and has required access rights |
| TextOrJSON | The text to send or a JSON which contains the text and additional required or optional parameters |
| ChannelID (optional) | The name or ID of the channel to post the message to. Not required if specified within passed JSON |
| ResponseTarget (optional) | Specify inbox, outbox, cell or cell-range to write any response to |
Return
A unique random request ID which can be used with REQUESTINFO to check the state of the request. In case of an error the corresponding error-code is returned.
Examples
| A | B | |
|---|---|---|
| 1 | text | Hello |
| 2 | channel | DB1234567890 |
| Formula | Result | Comment |
|---|---|---|
| Sends the message "Hello" to the #test channel and adds server response to the inbox | |
| Same as before but uses a JSON parameter and pass channel ID instead of its name |