If you want to run bulk updates manually, you could start with a Scheduled time trigger and a Get product data action. Then you’d want to define conditions that evaluate the returned products for the desired metafield value and start a For each loop that executes an Add product to collections action for each product and adds it to the relevant collection.
Here’s an illustrative example:
