I don't know which orders actually make money.
Writes one row per paid Shopify order into a Google Sheet you own, with revenue, an estimated processing fee, the cost of goods from your own cost table, and gross profit. P&L Auto is the finished Make.com file: import it, add your own credentials, and test it with one order. $9.99 once, no subscription.
30-day money-back guarantee — email within 30 days for a full refund. Refund policy
Build it yourself free →Quoted on server-side vs. app-based checkout tracking in MAKERSPACE, August 2026
Which one is right for you
You know your unit costs, most of your orders are for a single item, and you want per-order gross profit in a Sheet rather than in a monthly app.
You want two or more of the four automations. The kit is one scenario instead of four, so it fits inside Make’s free plan with a slot to spare and uses about a third fewer credits per order.
What the kit includes ↓You want to change the maths (cost every line item, or use your own fee model) and would rather build the scenario knowing how each step works.
Open the free guide →2 files, yours to keep
- Blueprint 04_P_and_L_Auto.json JSON
- SA_Template_2_PnL_Auto.xlsx XLSX
Before you start
- A unit cost for every SKU you sell. This is the only real work; the workbook cannot work out profit on a product it has no cost for.
- The variant ID of every product you sell. COGS_Table is keyed on Shopify’s variant ID, not the SKU; it is in the variant’s admin URL.
- A Google account with Drive, and a Make.com account.
- Shopify admin access that reaches Settings → Notifications.
- Your payment processing rate, so you can check the fee column against a real payout.
Set up in 3 steps
No developer, no agency, no configuration screens. Three steps.
In Make.com: Create a new scenario → Import Blueprint → upload Blueprint 04_P_and_L_Auto.json. The revenue, fee and COGS lookups are already wired to the template’s tabs.
Make.com · one clickCopy SA_Template_2 into your Drive. It has four tabs: Order_Data, COGS_Table, a Dashboard that totals itself, and a setup tab. The only real work is putting your own unit costs into COGS_Table.
Google Sheets · your product costsConnect your Google account in Make.com, add an Order payment webhook in Shopify Admin, and place a test order. One row per order appears with revenue, fees, COGS and gross profit calculated, and the Dashboard totals move.
Shopify Admin · test orderSetup, click by click
-
Import the file into a new scenario
Save Blueprint 04_P_and_L_Auto.json from the Drive folder and import it into a fresh Make scenario from the three-dot menu in the editor.
-
Turn the workbook into a Google Sheet
Upload SA_Template_2 to Drive and open it with Google Sheets so it converts. Leave the tab names as they are: the scenario addresses Order_Data and COGS_Table by name.
-
Fill COGS_Table before anything else
One row per variant ID with its landed unit cost: what you paid the supplier plus inbound freight and duty, if you want gross profit to mean what it says. Do this before the first live order: an order whose variant is missing from the table is not written at all.
-
Connect Google in every Sheets step
The scenario reads COGS_Table and writes Order_Data, so it touches the workbook more than once per order. Connect your Google account and select the converted workbook in each Sheets step.
-
Point Shopify at the webhook and switch on
Copy the address from the webhook step. In Shopify Admin, under Settings → Notifications → Webhooks, create a webhook on Order payment in JSON with that address, save it, and turn the scenario on.
-
Reconcile one order by hand
Place a test order, then check its row against Shopify: revenue should match the order total, COGS should match your table’s unit cost for the first item, and the fee should sit close to what your processor actually charged. If any figure is off, fix it now: every later row follows the same logic.
What it replaces, and what it does not do
TrueProfit, BeProfit and Glew.io pull ad spend from Meta, Google and TikTok automatically, break profit down by product and channel, and present it on a hosted dashboard. P&L Auto does the per-order arithmetic (revenue, fees, cost of goods, gross profit) and writes it into a workbook you own. Ad spend you enter yourself, weekly or monthly. If your margin questions are about individual orders and SKUs, that trade is worth the subscription you stop paying. If you run spend across many campaigns and want it attributed order by order, the paid tools earn their price.
When it breaks, and how you will know
Every automation fails sometimes. These are the ways this one does, what causes each, and where to look.
A paid order never appears in Order_Data.
WhyThe scenario looks up the order’s cost in COGS_Table by variant ID before it writes the row. When that variant has no row in the table, the lookup returns nothing and the write step never runs, so the whole order is skipped rather than written with a blank cost.
CheckCompare Order_Data with Shopify’s order list for the day. For each missing order, add its variant IDs to COGS_Table, then enter the order by hand; the scenario does not go back for it.
Gross profit looks too good on multi-item orders.
WhyCost is taken from the first line item’s variant, once. Further lines, and quantities above one, add revenue but no cost.
CheckFilter Order_Data for orders with more than one unit and recalculate their COGS from COGS_Table by hand. A healthy-looking month built on large baskets is the one to check first.
Refunded orders still count as revenue.
WhyThe scenario runs on payment, so it writes when money comes in. A refund issued later does not remove the row.
CheckOnce a month, take the refund total from Shopify’s reports and enter it as a negative row, so the Dashboard nets it off.
The fee column does not match your payouts.
WhyProcessing fees vary with card type, country and plan, and a third-party gateway bills its fee outside Shopify altogether.
CheckCompare a week of rows with the fee lines in Shopify’s payouts report. If another gateway takes a cut, its charges will not appear on the order.
Same 30-day money-back guarantee. See everything in the kit
P&L Auto, in detail
Where do the product costs come from?
Does it include Shopify payment fees?
Does it work in my currency?
Is this a live dashboard or a report I have to run?
Can it include ad spend?
What about orders from before I switched it on?
P&L Auto — Per-order revenue, fees, COGS and gross profit into Google Sheets.
Blueprint 04, import-ready. $9.99 once, no subscription, files yours to keep.