Daily Profit Dashboard Setup — Shopify

Hi,
I'm running a Shopify store  and I need a simple automated daily profit dashboard. I don't need a fancy UI, a Google Sheet updated automatically every morning is enough.
What I need each day, automatically pulled for the previous day:
Total revenue (TTC, including tax) from Shopify
Number of orders
COGS (already filled in Shopify "Cost per item" field, just needs to be pulled and summed per order)
Meta Ads spend ( i dont need roas meta)
Google Ads spend ( i dont need roas google)
A fixed shipping cost per order (I'll provide the average value)
A VAT provision (fixed % I'll provide)
Output (Google Sheet, one row per day):Date / Revenue / Orders / COGS / Shipping / Meta spend / Google spend / VAT / Net margin / ROAS / POAS
 ... Show more