I’d also love creative suggestions for trigger. For now I’m trying to use the app “Timed Actions” but I have no idea whether it will work. (why can’t time/date be a Flow trigger???)
Flow has a Scheduled time trigger in Beta right now. Like this trigger you are using, what you’ll realize is that without an event trigger there is no data to use in the workflow, so you need a way to get the the data. As part of the beta, we are adding a way to query products, for example. The main issue for this use case is that metafields can’t be used in queries yet, so the beta won’t work for you (especially if you have to go through all products).
An alternative way to solve this would be for you to use the Product added to store trigger. And then build your workflow to look for the metafield and do whatever. They go into the admin, select up to 50 products at a time, and click “More Actions > Run Flow Automation” and choose that workflow.
The HTML or Liquid part isn’t the problem. The problem is that you need a way to get all products with that metafield, which right now would require getting all products in your store every time. If you have more than a hundred or so products, that won’t be viable. If the products had some other field that you could filter on, it might be possible.
