Messaging & Communication

Lido provides action formulas for sending emails, Slack messages, and SMS directly from your spreadsheet.

---

SENDGMAIL

Sends an email via a connected Gmail account.

Syntax:

=SENDGMAIL(credential, recipient, subject, body)
=SENDGMAIL(credential, recipient, subject, body, status_ref, cc, bcc, file_url, sender, tracking_pixel_ref, reply_to, signature_id, in_reply_to, attachment_files)

Parameters:

Parameter	Description	Required
credential	Gmail credential ID	Yes
recipient	Email address(es) of the recipient	Yes
subject	Email subject line	Yes
body	Email body (supports HTML)	Yes
status_ref	Cell reference to write send status	No
cc	CC recipient(s)	No
bcc	BCC recipient(s)	No
file_url	URL of a file to attach	No
sender	Sender name/address override	No
tracking_pixel_ref	Cell reference for open tracking	No
reply_to	Reply-to address	No
signature_id	Email signature to use	No
in_reply_to	Message ID to reply to (for threading)	No
attachment_files	Additional files to attach	No

---

SENDOUTLOOK

Sends an email via a connected Outlook account. Parameters mirror SENDGMAIL (without sender).

Syntax:

=SENDOUTLOOK(credential, recipient, subject, body)
=SENDOUTLOOK(credential, recipient, subject, body, status_ref, cc, bcc, file_url, tracking_pixel_ref, reply_to, signature_id, attachment_files)

---

FORWARDOUTLOOK

Forwards an Outlook email message to another recipient.

Syntax:

=FORWARDOUTLOOK(credential, recipient, message_id)
=FORWARDOUTLOOK(credential, recipient, message_id, comment, status_ref)

Parameters:

Parameter	Description	Required
credential	Outlook credential ID	Yes
recipient	Email address to forward to	Yes
message_id	ID of the message to forward	Yes
comment	Optional comment to include	No
status_ref	Cell reference to write status	No

---

MOVEOUTLOOKMESSAGE

Moves an Outlook message to a different folder.

Syntax:

=MOVEOUTLOOKMESSAGE(credential, message_id, folder_url)
=MOVEOUTLOOKMESSAGE(credential, message_id, folder_url, status_ref)

Parameters:

Parameter	Description	Required
credential	Outlook credential ID	Yes
message_id	ID of the message to move	Yes
folder_url	Destination folder URL	Yes
status_ref	Cell reference to write status	No

---

SENDSLACK

Sends a message to a Slack channel.

Syntax:

=SENDSLACK(credential, channel, message)
=SENDSLACK(credential, channel, message, status_ref)

Parameters:

Parameter	Description	Required
credential	Slack credential ID	Yes
channel	Channel name or ID	Yes
message	Message text	Yes
status_ref	Cell reference to write status	No

---

ADDSLACKCHANNEL

Creates a new Slack channel.

Syntax:

=ADDSLACKCHANNEL(credential, channel_name)
=ADDSLACKCHANNEL(credential, channel_name, is_private, topic, members, status_ref)

Parameters:

Parameter	Description	Required
credential	Slack credential ID	Yes
channel_name	Name for the new channel	Yes
is_private	Whether the channel is private	No
topic	Channel topic	No
members	Members to invite	No
status_ref	Cell reference to write status	No

---

SENDSMS

Sends an SMS message via Twilio.

Syntax:

=SENDSMS(credential, from, to, body)
=SENDSMS(credential, from, to, body, status_ref, in_reply_to)

Parameters:

Parameter	Description	Required
credential	Twilio credential ID	Yes
from	Sender phone number	Yes
to	Recipient phone number	Yes
body	Message text	Yes
status_ref	Cell reference to write status	No
in_reply_to	Message SID to reply to	No

---

SENDEMAIL

Sends an email using Lido's built-in email service (no credential required).

Syntax:

=SENDEMAIL(recipient, subject, body)
=SENDEMAIL(recipient, subject, body, file_url)

Parameters:

Parameter	Description	Required
recipient	Recipient email address	Yes
subject	Email subject line	Yes
body	Email body	Yes
file_url	URL of a file to attach	No