How can I use Flow to update sold out product titles?

Hey! So I have a request for a site we are working on. We would like to use flow to solve this does any one have any ideas how this could work:

When a product is sold out (all variants have 0 inventory and overselling is not enabled), it should be removed from all collections and have ‘Sold out’ added to the end of the title.

Ensure that products with the tag “Coming Soon” are not updated by this flow.

TIA

Laura