Yes, this is 100% possible with Make’s MailChimp modules and Make’s Airtable modules.
Ironically, I just spent the last few days setting this EXACT thing up for one of my clients that has 15 different MailChimp accounts (each account represents one of their nationwide branches), and all 15 MailChimp accounts are managed from one unified Airtable base.
It would take me too long to outline the entire step-by-step here, because it takes a while to setup, but the biggest learning curve for most people is figuring out how to use Make.
If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable.
I also give live demonstrations of how to use Make in many of my Airtable podcast appearances. For example, in this video, I show how to work with Airtable arrays in Make.
Hope this helps!
If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Thank you for the solution! Highly appreciate sharing the modules and the basics video!