Lido's =SENDGMAIL() formula lets you send emails from your Gmail account directly from Lido.
=SENDGMAIL(sender, recipient, subject, body, [cc], [bcc], [attachments])
You'll be prompted to oAuth into your Gmail account the first time that you run a SENDGMAIL action in Lido from a new email account.
You can send emails from multiple accounts in the same Lido file / account. Simply change the
sender argument in your SENDGMAIL formula, then oAuth into the new account. You can send emails from any email account that you've authenticated.
You can send emails to multiple recipients by passing your recipient list as an array in the second argument of your SENDGMAIL formula.
=SENDGMAIL(sender, ARRAY(email1, email2, email3), subject, body)
Make sure that each email is passed through as a string. Valid syntaxes include:
ARRAY(A1, A2, A3) if your recipient emails are in different spreadsheet cells.
Alternatively, you can do
ARRAY("email1", "email2", "email3")
Attachments need to be passed through as statically hosted URLs. The URL needs to be the direct download link for a file, and not a preview or share link. We only support attachments less than 25MB at this time.
Here are instructions for how to find this link from common places.
You can use this direct link generator for files that have been uploaded directly to Google Drive:
This link generator does NOT work for Google docs / sheets / slides.
If you want to send a Google doc / sheet / slide, we recommend putting the share link directly in the email body instead.
- Find the normal sharing link from Dropbox. Go to Dropbox.com, find your file, and click the Copy link button that appears when you hover over it. Or, on your desktop, right-click on the file, and select Copy Dropbox Link.
- You should have a link like: https://www.dropbox.com/s/hriinb9w3a2107m/iPad%20intro.pdf
- Replace the
dl.dropboxusercontent.com, which will give you a link like: https://dl.dropboxusercontent.com/s/hriinb9w3a2107m/iPad%20intro.pdf
- Pass the link from step 2 into your SENDGMAIL formula
You can send multiple attachments using two methods:
=SENDGMAIL(sender, recipient, subject, body, [cc], [bcc], array(url1, url2))
=SENDGMAIL(sender, recipient, subject, body, [cc], [bcc], "url1, url2, url3")
You can pass HTML through the body argument of your SENDGMAIL formula, as long as everything is wrapped in quotes.
CSS styles are supported as well but must be passed through inline.
It is important to be confident of the results of any SENDMAIL actions that have been run and see any errors that occur. In Lido, ACTIONS return results which include errors.
To store the status of SENDGMAIL in a cell:
If you right click on the UPDATECELL action, the action will run, and the result will populate Cell B5.
This example tries to use an outgoing email account that is not authenticated.
Updated about 1 month ago