Hi!
Here is what I am trying to do, and failing every time:
TLDR - Want to send an email to the people selected in a dropdown column on monday.com in a specific board, once it has been assigned to a person (marketing employee) to let the person that is selected know who has been assigned their project.
Want to send an email on my connected outlook account to the people selected in a dropdown column on monday.com (this is from a workform submission where the user selects their name).
Once it has been assigned to a person (marketing employee) I want it to let the person that filled out the form know basically that it has been received and know who has been assigned their project.
I have a google sheet that has the list of names in the drop down selection as well as the corresponding emails for each. I did not use a status for this, because sometimes there are multiple people (form submitters, not assignees) on these projects that i want to get the email.
Hopefully this makes sense, thx!