Hi, I'm using SendInBlue to manage my Leads mailing list (and some other lists not related to the Leads module). There is an extension for Zoho CRM to integrate SendInBlue; unfortunately this extension works properly only for Bulk Sync (that is all the lists in Sendinblue get synced with the Leads module) and it's not my case since I have several lists, so I cannot use it.

I'm trying to figure out if there is a way to automate the sync between the CRM and a specific SendInBlue list (Sync oneway form CRM to SendInBlue). In he list I have the email and some other fields: First Name, Last Name, Address, City, Zip, Phone and a couple of others. These fields must be kept up to date.

If a new Lead is created, and has an email, then a new subscriber must be created in SendInBlue (this can be easily done, for example, using flow).

If one of the fields in the list (but email) is updated then the subscriber must be updated (this should be possible using flow or with a workflow). But, if the email field gets updated it's a problem: if the email was previously empty (not all the leads have the email set) I need to add a subscriber, but if it was not I will need to remove the old address from the subscribers and add the new one. No problem adding, updating or removing a subscriber using SendInBlue API, but how to properly get the correct values? A workflow rule might be used to trigger the email field update, but how do I fetch the old email value? Moreover, if the lead is converted, the subscriber must be removed from the list. How to fire such event?