Reply To: Send email when connection is added, edited or removed

Yes, the connections table is the primary table. I would however not recommend unserializing the email column sinc that is primary used as a cache to speed up entry queries and display. Instead, use a join and join the email table.

Another method you could use is navigate to the Connections : Tools admin page and click the Export tab. Scroll down to the Email export. You should be able to use that CSV file to import into MailChimp. Of course you’ll have to do this once and a while to ensure both Connections and the MailChimp list stay in sync.

Hope this helps!

If you have a moment, I would truly appreciate a review as they really do make a difference.

https://wordpress.org/support/plugin/connections/reviews/

Thanks in advance for your time!