{"product_id":"etsy-profit-listing-margin-tracker-in-google-sheets-n8n","title":"Etsy Profit \u0026 Listing Margin Tracker in Google Sheets + n8n","description":"\u003ch3\u003eTurn Etsy CSVs into a Monthly Profit \u0026amp; Listing Margin Report—automatically in n8n + Google Sheets\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003ePaste your Etsy Monthly statement and Order Items CSVs\u003c\/strong\u003e, add a simple cost sheet, and this workflow builds a monthly P\u0026amp;L, calculates margin per listing, flags potential losses (and missing COGS), and generates a plain-language summary—\u003cstrong\u003ewithout using the Etsy API\u003c\/strong\u003e. Optional Gemini can rewrite the summary with your key.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your CSV exports\u003c\/strong\u003e: imports your Etsy Monthly statement CSV, your Order Items CSV, and your own cost sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a monthly P\u0026amp;L\u003c\/strong\u003e: totals sales, refunds, every fee line Etsy shows, calculates \u003cstrong\u003eCOGS\u003c\/strong\u003e, \u003cstrong\u003enet profit\u003c\/strong\u003e, and \u003cstrong\u003emargin\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBreaks profit down by listing\u003c\/strong\u003e and flags listings as:\n    \u003cul\u003e\n      \u003cli\u003e\u003cstrong\u003eLOSS\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eLOW_MARGIN\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eMISSING_COGS\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eREFUNDED\u003c\/strong\u003e\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a short summary\u003c\/strong\u003e in plain language:\n    \u003cul\u003e\n      \u003cli\u003eDefault: a \u003cstrong\u003erule-based\u003c\/strong\u003e summary that works with \u003cstrong\u003eno API key\u003c\/strong\u003e.\u003c\/li\u003e\n      \u003cli\u003eOptional: add a \u003cstrong\u003eGemini API key\u003c\/strong\u003e to rewrite the summary using Gemini.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDemo mode\u003c\/strong\u003e includes built-in sample CSVs so you can test installation before connecting real files.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonthly Etsy bookkeeping: transform statement + order exports into a P\u0026amp;L in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eProfit-by-listing reviews: quickly spot which Etsy listings are losing money or missing COGS.\u003c\/li\u003e\n  \u003cli\u003eRefund visibility: identify listings impacted by refunded orders.\u003c\/li\u003e\n  \u003cli\u003eSaaS\/ops reporting: standardize margin reporting without a live Etsy API integration.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow\u003c\/strong\u003e using nodes such as: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, \u003cstrong\u003ehttp request\u003c\/strong\u003e, \u003cstrong\u003egoogle sheets\u003c\/strong\u003e, and \u003cstrong\u003econvert to file\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNo Etsy API\u003c\/strong\u003e—it processes your CSV exports.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGemini rewrite is optional\u003c\/strong\u003e; without a key, the rule-based summary is used.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eNote:\u003c\/strong\u003e tested with sample data in Etsy export format; Google Sheets live-sheet integration has not been validated by the authors. Always check numbers before tax or bookkeeping use.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46206053449907,"sku":"N8N-20780","price":23.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/QkK9szvMo_NC_ij1Awfgb_59VC7Alw.png?v=1791796154","url":"https:\/\/buyflowscripts.com\/products\/etsy-profit-listing-margin-tracker-in-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}