Google Sheetsspreadsheet~10 mins

Sending emails from Sheets in Google Sheets - Cell-by-Cell Formula Trace

Choose your learning style9 modes available

Learn Why Deep Sheet Try Challenge Scenario Recall Dash

Sample Data

This sheet contains names, their email addresses, and personalized messages to send.

Cell	Value
A1	Name
B1	Email
C1	Message
A2	Alice
B2	alice@example.com
C2	Hello Alice, your order is ready.
A3	Bob
B3	bob@example.com
C3	Hi Bob, your appointment is confirmed.

Formula Trace

sendEmail(B2, "Order Update", C2)

Step 1: B2

Step 2: "Order Update"

Step 3: C2

Step 4: sendEmail("alice@example.com", "Order Update", "Hello Alice, your order is ready.")

Cell Reference Map

    A          B                   C
1 | Name     | Email             | Message
2 | Alice    | alice@example.com | Hello Alice, your order is ready.
3 | Bob      | bob@example.com   | Hi Bob, your appointment is confirmed.

The formula uses the email address from column B and the message from column C of the same row.

Result

    A          B                   C                   D
1 | Name     | Email             | Message             | Status
2 | Alice    | alice@example.com | Hello Alice, your order is ready. | Email sent
3 | Bob      | bob@example.com   | Hi Bob, your appointment is confirmed. | Email sent

After running the script, a status column can show 'Email sent' to confirm the email was sent for each row.

Sheet Trace Quiz - 3 Questions

Test your understanding

What does the formula sendEmail(B2, "Subject: Order Update", C2) use from the sheet?

AEmail from B2 and name from A2

BName from A2 and message from C2

CEmail from B2 and message from C2

DOnly the message from C2

Key Result

sendEmail(email_address, subject_text, message_text) sends an email using values from specified cells.