This post has been split from
Hey
That sounds like it should be possible. My first thought here is that you would need to set up a Zap with the following trigger and action steps:
- Trigger: Updated Contact (ActiveCampaign) - triggers when the updates take place each night.
- Action: Get Item by Column Value (Monday.com) - searches for the relevant lead by searching a specific column for a value that’s unique to the lead, their email address perhaps? As the following action will be dependant on the ID from this action, the Zap will halt if an existing lead isn’t found.
- Action: Change Multiple Columns Value (Monday.com) - this would then update the item that’s found by the previous action to with the necessary information.
One thing to note on that is, in order for the Change Multiple Columns Value action to know which item it needs to update, in the Item ID field you’d need to select the Item’s ID (use the Custom value option) from the Get Item by Column Value action.
Hopefully that helps to get you started. Please keep us in the loop on how you get on! 
I have a related scenario and I tried this process. But the problem is Get Item by Column value doesn’t return item id when no columns selected( field is there but value is null) as Columns to return or item id is not their when I tried to add it from the drop down. Item id is necessary in order to perform either Change multiple column value or Create update actions.
