Your Shopify P&L should write itself. Now it does. Free.

Yes. Using Make.com's free tier, every Shopify order automatically writes revenue, fees, and order data to a Google Sheet. SUMIF formulas in a summary tab calculate live gross margin and net profit without any manual entry. Make.com's free plan covers 1,000 credits/month (formerly called operations): enough for stores processing up to 500 orders per month.

The Shopify order webhook payload includes order ID, date, channel, total revenue, subtotal, discounts, shipping revenue, tax collected, payment gateway, line item quantities, variant IDs, and customer details. For P&L purposes you use total revenue, discounts, shipping, Shopify transaction fees, and variant IDs that map to your COGS table via VLOOKUP.

Shopify's built-in reports show revenue, units sold, and average order value. They do not calculate net profit: they have no concept of COGS, Shopify subscription fee, ad spend, or operating expenses. The automated P&L in Google Sheets adds all of these in a single live view you own and customise, with zero monthly fees.

Store your unit cost per variant in a COGS Table tab, keyed on Shopify's variant ID. When an order is paid, Make.com looks up the variant of the order's first line item in that table and writes its cost into the row. Further line items, and quantities above one, add revenue but no cost, so on multi-item orders treat gross profit as indicative. A cost you change later applies to new orders, not rows already written.

A second Make.com scenario monitors the Shopify Refund created webhook. When a refund occurs, it writes a negative revenue row to the same Order Data tab. SUMIF formulas in your P&L Summary automatically net refunds against gross revenue with no manual adjustment needed.

Ad spend is not in Shopify order data: it lives in Meta Ads, Google Ads, and TikTok. Add a manual Expenses tab to your Google Sheet and enter monthly spend figures there. Reference this tab in your P&L Summary to calculate true net profit after advertising. For automated Google Ads spend pulling, Google Workspace with a Google Apps Script can connect to the Google Ads API directly.

Yes. The Shopify webhook payload includes source_name which identifies the sales channel: online store, Point of Sale, Amazon, TikTok Shop, and more. Add a channel column to your Order Data tab and use SUMIF formulas to break P&L metrics down by channel in your summary.

This is management accounting: live profit visibility for operational decisions. It is not a replacement for double-entry accounting, VAT returns, or statutory accounts. Use it alongside Xero or QuickBooks for compliance. The benefit is live margin data for daily decisions without waiting for monthly reports.

Free Gmail works for stores processing up to 500 orders per month. At higher volumes, Gmail API limits may throttle Make.com's Google Sheets write operations during peak periods. Google Workspace removes all limits and adds shared workspaces: recommended for high-volume stores or teams.

Historical data stays in your Google Sheet permanently: it belongs to your Google account. Make.com only writes new rows as orders come in. Stop the scenario and existing rows stay intact with all formulas working. You simply stop receiving new order rows until you reconnect.

We have not timed it on a fresh account, so we do not quote a time. There are three parts: importing the Make.com scenario and adding the Shopify webhook, setting up the Google Sheet with its SUMIF formulas, and entering your cost of goods per product. The last one depends on how many products you sell.