SLACK.CHANNEL.MESSAGE

Premium

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 post message API for more information about available and supported options (as of 2021-05-17).

Syntax

=SLACK.CHANNEL.MESSAGE(TextOrJSON, [ChannelID], [ResponseTarget])

Arguments

Name	Type	Description
TextOrJSON	String or JSON	The text to send or a JSON which contains the text and additional required or optional parameters
ChannelID (optional)	Number	The name or ID of the channel to post the message to. Not required if specified within passed JSON
ResponseTarget (optional)	Target	Specify inbox, outbox, cell or cell-range to write any response to

Return

Type	Description
Boolean,Result,Error	Request result if no target is specified or TRUE. In case of an error the corresponding error-code is returned.

Examples

	A	B
1	text	Hello
2	channel	DB1234567890

Formula	Result	Comment
=SLACK.CHANNEL.MESSAGE("Hello","#test",INBOX())		Sends the message "Hello" to the #test channel and adds server response to the inbox
=SLACK.CHANNEL.MESSAGE(JSON(A1:B2),,INBOX())		Same as before but uses a JSON parameter and pass channel ID instead of its name