Automation to email entered in form not in a contact list

dbussiere

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.

THANKS!

bisaacs

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!