Automation to email entered in form not in a contact list


This response was posted to the same question I have. What I can't figure out is what formula to do I use to get the email into a new column.

If you don't want to use a Contact List field on the form, but want the automation once the row gets to the sheet, create a text field to receive the email address on the form and then a column formula in a Contact List field that references the value in the text field. Then run your automation on the Contact List field.



  • bisaacs
    bisaacs ✭✭✭✭✭
    edited 05/24/24

    Hey @dbussiere,

    If you're asking how to make the field on the form a required email address, you would do it here when building out the form:

    Then when you're doing the automation, the column this field is tied to will be an option as an email to send it to.

    Hope this helps!

    If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!

    I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!