Send an email to the list of people from the cell

Hi guys. How can I set up an automation so it can send an email within the page’s content to the list of people included to the cell of particular row. Any suggestions?

something with =user().email. formula?

thx for your help!

1 Like

Give this a try!

FormulaMap(
  [Array],
  Gmail::SendEmail(
    account,
    CurrentValue.Email,
    subject,
    content,
    cc,
    bcc,
    from,
    replyTo,
    hideSignature
  )
)
1 Like

where should I put this? :sweat_smile: could you GIF this for me? :pray:

appreciate your time in advance.

this is the formula that will send multiple emails to everyone in the people cell, we call a cell with multiple disparate pieces of data an array. Have you gotten the Gmail::SendEmail() formula working yet?