Automation Email

Doren Sorell

I'm creating a automation for a sheet. When someone fills out the form associated to that sheet, we'd like it to automatically send an email to them. I created a automation workflow, and I set the Trigger to be "When rows are added," and then set the Action to "Alert Someone," and then set it to "Send to contacts in a cell" -- and I was thinking it would give me the option to choose a column that has the new email of the person who filled out the form. Yet when I want to use the dropdown of "Select a contact field," thinking that I'd choose the email column, it doesn't give me any option at all. What am I doing wrong?

Paul Newcome

Make sure the email column is set as a contact type column.

Mike Wilday

Set a column as a contact type column by:

1. right-clicking on the column header
2. Choose edit / column type (Its usually the last item on the popup menu.)
3. Select contact type column.
4. Select OK

ç