Hi @Olifer88, welcome to the Community!
 

Ah, the Tag field in the Add/Update Subscriber (Mailchimp) action would only add new tags to a subscriber, it doesn’t replace the existing tags.

I think what you’d need to do here is have an additional column in the spreadsheet that stores the previous stage tags the user had. And you overwrite that with the previous stage tags each time you update the other stage column. Then you could use a Remove Subscriber from Tag (Mailchimp) action to remove any existing tags, followed by a Add/Update Subscriber action to add the necessary tags again.

So the Zap would look like this:

• Trigger: New or Updated Spreadsheet Row (Google Sheets) - triggers when a specific column is updated. It will also run when a new row is added so I’d recommend adding a filter to ensure it doesn’t continue to run for new rows.
• Action: Only Continue If... (Filter by Zapier) - uses the Exists rule to check whether there’s a value in the “previous stage” column. This ensures the Zap only runs for existing subscribers that have had their stage updated.
• Action: Remove Subscriber from Tag (Mailchimp) - removes the existing tags using the tags listed in the “previous stage” column in Google Sheets.
• Action: Add/Update Subscriber (Mailchimp) - adds the new tags using the tags present in the “current stage” column in Google Sheets.  

Do you think that approach could work? If I've misunderstood what you're looking to do or you run into any issues in setting that up just let us know. Always happy to help further! 

It worked! 

Thank you.