Logic Sheet Help Center
Go to WebsiteSubmit a Ticket
  • Home
  • How to install Logic Sheet
  • 🤖Automation
    • Automation overview
    • Trigger
    • Conditions
    • Actions
      • Conditional actions
      • Update Airtable
      • Recalculate the current sheet
      • Send a Slack message
      • Send an email
      • Make HTTP request
    • Add connections
      • Slack connection
      • Airtable connection
      • Webhook
    • Merge tags
  • Utilities
    • Work with APIs
      • The LogicSheetAPI formula
    • Database connector
      • MySQL
    • Get data
    • Clean and format data
    • Calculate
    • Finance
    • Data analysis
  • Appendix
    • Supported currencies
  • Additions
    • Page 1
Powered by GitBook
On this page
  • To (required)
  • Subject (required)
  • Email body (required)
  • Optional fields
  1. Automation
  2. Actions

Send an email

PreviousSend a Slack messageNextMake HTTP request

Last updated 2 years ago

This action will send an email from your Gmail account.

To (required)

The recipient(s) of the email. It should be the email address or email addresses that will receive this email. You can set up multiple email addresses separated by a comma in this field.

Multiple fixed emails

email1@example.com, mail2@example.com

Multiple emails using merge tag

Suppose that the value in cell B5 and F4 are email addresses, you can do this for the recipients:

email@example.com, {{range B5}}

OR

{{range B5}}, {{range F4}}

Subject (required)

The subject of the email.

Email body (required)

The email content.

Merge tag available

  • {{range A1}}: The value of cell A1(dynamic), or other cells of your choice.

  • {{old value}}: The value of the cell prior to editing.

  • {{new value}}: The new value of the cell after being edited.

  • {{editor}}: The email address of the user who made the edit.

  • {{edited range}}: The notation (string) of the cell being edited.

  • {{column A}}: All values in column A(dynamic).

  • {{row 1}}: All values in row 1(dynamic).

  • {{sheet}}: The name of the sheet that was edited or set in the trigger step.

  • {{spreadsheet url}}: The URL of the spreadsheet that this automation belongs to.

  • {{automation name}}: The name of the automation workflow you have set.

  • {{form values}}: All values of the form submission that was received.

  • {{form values 1}}: The first value (or the nth value if you set the number as n) of the form submission that was received.

Optional fields

You can optionally fill in these fields.

  • Sender name: The name that will be shown in the receiver's inbox as the sender name.

  • CC: A list of email addresses that this email will copy to.

  • BCC: A list of email addresses that this email will blind carbon copy to.

  • Reply to: An email address to use as the default reply-to address (default: the user's email address).

You can use the following merge tags in the Value field here. See .

🤖
how merge tags work
Email sent by Logic Sheet