Skip to main content
Version: Streamsheets 3.0

SMS77.SEND

Premium

Sends an SMS message to specified contact. In its simplest form only text and recipient number are required. But for more advanced settings it is also possible to pass a JSON object containing additional parameters. Please refer to [SMS77 API] (https://www.sms77.io/en/docs/gateway/http-api) for more information about available and supported options (as of 2021-05-17).

Syntax

=SMS77.SEND(TextOrJSON, [ToContact], [ResponseTarget])

Arguments

NameTypeDescription
TextOrJSONString or JSONThe text to send or a JSON which contains the text and additional required or optional parameters
ToContact (optional)StringThe recipient number or name to send message to. Not required if specified within passed JSON
ResponseTarget (optional)TargetSpecify inbox, outbox, cell or cell-range to write any response to

Return

TypeDescription
Boolean,Result,ErrorRequest result if no target is specified or TRUE. In case of an error the corresponding error-code is returned.

Examples

AB
1toMr. Doe
2texthello
3ttl60
FormulaResultComment
=SMS77.SEND("hello","Mr. Doe")
Sends "hello" to Mr. Doe
=SMS77.SEND(JSON(A1:B3))
Same as before but using JSON to specify required information and set optional ttl value to 1h