Tag products that are on sale
Tag products where any of the variant have "price" that is lesser that its "compare at price". The workflow will automatically remove the tag when no variant has price less than its compare at price