I want to create an automation where
On Moday.com board called marketing Plan, change the status from anything to schedule + and the date is today
Action of filter the contact list from a contact board (it is another board on monday.com) with the marketing email column saying YES.
Find a Tag (name of the marketing name (form the first trigger) and check if there is a campaign in Mailchimp with the same name
Find a campaign and send to the emails I have filtered from Monday.com
After sending it, update the marketing Plan status to “sent campaign or done”.
Could you please give me an idea of the best approach for creating the scenario?