Update contact in Active campaign when deal stage changes in Pipedrive

I’m trying to update a custom field in Active Campaign whenever a deal stage changes in Pipedrive. The problem is that there Is no way to get contact ID from Active Campaign nor look it up by email value.
I can get all the contacts from Active Campaign and then lookup the needed one, but this seems a little extreme as I have thousands of contacts

Hi @Artego, welcome to the community :tada:

I am not using these nodes regularly (so don’t have any out-of the box idea for this), but I shall take a closer look into this and get back to you as soon as I can :slight_smile:

1 Like

Hey @Artego, it looks like the Active Campaign node allows searching by email when using the Get All operation:

With an expression of {{$json["Contact person"]["email"][0]["value"]}} you should be able to read the email coming from Pipedrive:

Would this work for you?

Yes, it would. Awesome. Thank you

1 Like