Hi, I am trying to get my head around something here.
I have set up a ‘Mailchimp Status’ column in Airtable to automatically provides the ‘Status’ i.e. “Subscribed”, “Cleaned”, “Unsubscribed” of an email address in Mailchimp. This way I can easily keep track of who in our database is currently receiving our mailouts, who has opted out, and which emails are bouncing.
I have a Zap set up which triggers when a subscriber is created or updated on Mailchimp. This in turn finds the corresponding record on my Airtable base and updates the ‘Mailchimp Status’ field with the ‘Status’ output data from Mailchimp.
So far so good, I have data appearing in my Airtable column. My issue however is that for some reason, instead of showing “subscribed” it is showing “subscribe”, and I can’t figure out why. When I am testing the steps in Zapier, the status output from Mailchimp shows as ‘subscribed’, but when it’s hitting my database in reality it is showing ‘subscribe’.
This is obviously a minor issue and one that doesn’t affect the overall function of the Zap, but i’m keen to figure out why it’s happening. If anyone has any ideas or pointers on how to fix this please let me know.
Thanks
Tom