How to automate my workflow using data in metabase with shopify?

I have a table that is being updated every hour. The table contains the prices of my competitors and the status of their stocks. If a product goes out of stock, I need to be able to increase the prices of my comparable product on Shopify. What is the best way to do it? With the setup I have, I can see the statistics, but I need to take a custom action on Shopify. Any advice will be appreciated.

Metabase won't serve for this purpose, you need some platform to run code when a certain event happens. Metabase is a product to consume information, not react to events and run code