Hello! I am looking to create a workflow for a Monday board with a status column with 10 or so options. Each status will be aligned with an email template in Mailchimp. So:
- a Monday form is filled out
- which creates an item on the Monday board
- Status X is automatically assigned to the item (from Monday automation)
- when Status X is assigned it triggers Mailchimp Email X to send
- the email statistics (sent, opened, etc.) are logged for that item in Monday (on the same board, preferable in a new column) to confirm the email has sent and if it was opened.
- if Monday item status changes from X to Y (manually) it triggers Mailchimp Email Y to send
- repeat step 5 (email stats)
- if Monday Status changes from Y to Z (manually) it triggers Mailchimp Email Z to send
- repeat step 5 (email stats)
- and so on
I’ve tried a few different Zaps, -- specifically, if item is created in Monday, add name to “list” or “tag” in Mailchimp, then send it on a “journey,” but have not figured out how to make the connection when the status changes to a specific selection from the dropdown trigger a specific email to send.
Any help is much appreciated!