Track True Profit Per Dropshipping Order Automatically in Google Sheets
An n8n workflow that captures every new order, subtracts product cost, payment fees and an allocated ad spend, and logs the real net profit per order to Google Sheets — so you finally know which products and orders actually make money instead of guessing from top-line revenue.
- 1
Catch every new order
Add a
Webhooknode and subscribe your store'sorders/createevent to it. The payload gives you the order total, currency, line items (SKU + quantity + price) and any campaign/UTM data. This fires the instant a customer checks out, so your profit ledger is always current. - 2
Look up costs and CAC
A
Google Sheetsread pulls your cost table (SKU → supplier cost) and your CAC table (product/campaign → blended acquisition cost). ACodenode joins these to the order's line items so every unit sold knows what it cost to buy and to acquire. - 3
Compute the true net profit
A
Codenode calculates it end to end:revenue - COGS - payment_fees - shipping - allocated_ad_spend. Payment fees use your processor's rate (e.g. 2.9% + $0.30). The result is the number that actually matters — what you keep after every cost, per order. - 4
Log the order to the ledger
A
Google Sheetsappend writes a rich row: date, order ID, product(s), revenue, COGS, fees, ad spend, net profit and margin %. Structured columns make the sheet immediately pivotable by product, day or campaign. - 5
Flag loss-making orders
An
IFnode checks for negative net profit and posts those toSlack. A single losing order can be noise, but a pattern of them on one product is an early, actionable signal to pause or re-source it before the losses compound.
Frequently asked questions
Why isn't Shopify's revenue number enough?
Revenue is vanity; profit is sanity. A product doing $10,000 in sales can be losing money once you subtract the AliExpress cost, the 2.9%+30c payment fee, and the ad spend it took to acquire those customers. Most dropshippers only discover this at tax time. Tracking net profit per order in real time means you cut losers and scale winners weeks earlier — which is the entire game in a thin-margin business.
How does it allocate ad spend to an order?
Two practical options. The simple one: store a blended CAC (customer acquisition cost) per product or per campaign and subtract it from each order. The precise one: if your orders carry UTM/campaign data, look up that day's ad spend for the campaign and divide by its orders. Start with blended CAC in a config sheet — it's 90% of the value for 10% of the effort — and refine later.
Where do product costs come from?
A cost lookup: a Google Sheet mapping each SKU to its supplier cost, or your fulfillment provider's cost field on the order. The workflow multiplies cost by quantity for each line item. Keeping costs in a maintained sheet also means this same source can feed your repricing and reporting workflows.
Can I see profit by product, not just per order?
Yes — because every order row carries the product, a pivot table or a GROUPBY in the sheet instantly rolls profit up by SKU, by day, or by campaign. That view is where the decisions live: pause the SKU that's net-negative, pour budget into the one clearing 40% margin after all costs.
Generate Facebook and TikTok Ad Creatives for New Dropshipping Products with AI
An n8n workflow that turns each new product you add into a full set of ad angles — hooks, primary texts, headlines and a script outline for a UGC video — written by Claude for Facebook and TikTok, so you can launch tests the same day instead of staring at a blank ads manager.
Free recipe
Proactively Offer a Discount When a Dropshipping Shipment Is Delayed
An n8n workflow that watches tracking for shipments stuck in transit beyond your promised window, and proactively emails the customer an apology with a small discount code before they get frustrated — turning slow supplier delivery, the number-one dropshipping complaint, into a loyalty moment instead of a chargeback.
Free recipeValidate Shipping Addresses Before Fulfillment to Stop Failed Deliveries
An n8n workflow that checks every new order's shipping address against a validation API, auto-corrects minor errors, and holds plus flags orders with undeliverable addresses before they're sent to your supplier — so you stop paying to ship parcels that bounce back or vanish.