E-commerce · n8n

Build a Daily Shopify Profit-and-Margin Dashboard Automatically

See true daily profit, not just revenue — combine Shopify sales with your cost of goods and ad spend into an automated margin dashboard every morning.

difficulty Advancedsetup 45 minresult Each morning you get a clear view of yesterday's real profit and margin, so decisions are grounded in truth.—
—
  1. 1

    Schedule the Report

    Add a Schedule Trigger running early each morning for the prior day.

  2. 2

    Pull Orders and Costs

    Add a Shopify node for yesterday's orders and a Google Sheets lookup for each SKU's cost of goods.

  3. 3

    Add Ad Spend

    Add an HTTP Request to the Facebook Ads API for yesterday's spend to subtract from profit.

  4. 4

    Compute and Write Margin

    Add a Code node calculating revenue, COGS, ad spend, net profit and margin, then a Sheets node writing the row.

  5. 5

    Activate and Test

    Activate the workflow and run it for a past day. Confirm the profit math matches your books.

Frequently asked questions

What about shipping and fees?

Add columns for shipping cost and payment fees so the margin reflects all variable costs, not just COGS.

Can I chart the trend?

Point a Sheets chart at the daily rows to visualize profit and margin over time automatically.

Related recipes
Free recipe
Google SheetsGmailn8n
Google SheetsGmailn8n
—

Auto-Email Suppliers a Reorder When WooCommerce Stock Runs Out

When a WooCommerce product hits zero stock, automatically email the assigned supplier a purchase request with the SKU and reorder quantity.

Intermediate · 40 min setup
Free recipe
Gmailn8n
Gmailn8n
—

Send a Perfectly Timed Review Request After a WooCommerce Delivery

Wait until an order is actually delivered, then email the customer a friendly review request with a direct link, maximizing your review rate.

Beginner · 25 min setup
Free recipe
HubSpotn8n
HubSpotn8n
—

Capture Warranty Registrations and Enrich Customer Profiles

Know your buyers — turn warranty registrations into enriched CRM profiles so you can support and market to product owners effectively.

Beginner · 30 min setup
About this recipe. Recipes on FlowRecipesHub are written for business owners, not developers, and are tested before publishing — how recipes get made. Some ingredient links are affiliate links that cost you nothing — full disclosure.