Bibliothek / Finanzen, Rechnungen & Buchhaltung
Finanzen, Rechnungen & Buchhaltung
Etsy-Gewinn und Angebotsmargen in Google Sheets mit Gemini-Zusammenfassungen verfolgen
Läuft auf Abruf und wandelt Etsy-Abrechnungs- und Bestell-CSVs sowie eine Kostentabelle in eine monatliche GuV, Gewinn pro Angebot, Abgleichprüfungen und eine Gemini-Zusammenfassung in Google Sheets um.
Was sie bewirkt
## Profit Tracker for Etsy Shops v0.2 (free) · by Stallkit Studio Etsy monthly statement CSV + Order Items CSV + your cost table → monthly P&L, profit per listing per month, reconciliation checks, and a short summary of which listings lost money. Try it first (no keys, no accounts): click Test workflow. It runs on built-in FAKE data and writes 3 CSVs to /home/node/.n8n-files/ (self-hosted). On n8n Cloud, look at the output of the Rows: nodes instead. Your own data 1. Etsy Shop Manager → Finances → Payment account → *Monthly statements* → CSV (one per month) and Settings → Options → Download Data → Orders → *Order Items* CSV (same months). 2. Make a cost table with columns sku, listing_id, item_name, unit_cost, extra_cost_per_unit (fill sku OR listing_id OR item_name). 3. Files (self-hosted): put them in filesFolder as etsy_statement*.csv, EtsySoldOrderItems*.csv, cogs.csv, set source: "files". Google Sheet: tabs Statement, OrderItems, COGS (File → Import → each CSV), plus empty tabs P&L, By Listing, Summary. Paste the sheet URL into all 6 Google Sheets nodes, set source and output to "sheet". 4. Optional AI summary: Header Auth credential, name x-goog-api-key, value = your Gemini key; pick it in Gemini summary; set mode: "gemini". Only totals and listing titles are sent, never buyer names or addresses. n8n Cloud is a paid n8n subscription; self-hosting needs your own computer or server. Gemini API costs, if any, are billed to you by Google. Not tax or accounting advice. Check numbers against your Etsy statement. Etsy and n8n are trademarks of their respective owners. Stallkit Studio is not affiliated with or endorsed by them.
Die Schritte
- Run
- Config
- Source = sample?
- Sample Etsy exports (fake data)
- Source = sheet?
- Read Statement tab
- Read OrderItems tab
- Read COGS tab
- Read statement CSVs
- Parse statement CSV
- Read Order Items CSVs
- Parse Order Items CSV
- Read COGS CSV
- Parse COGS CSV
Insgesamt 35 Schritte.
Ähnliche Automatisierungen
Web Scraping & RechercheEtsy-Angebote mit Bright Data und Gemini scrapen15 SchritteBerichte, Analysen & DashboardsEtsy-Bewertungsthemen mit Gemini zusammenfassen und eine Korrektur-Warteschlange in Sheets priorisieren36 SchritteWeb Scraping & RechercheEtsy-Produktdaten mit Bright Data und Gemini auswerten47 SchritteRAG & WissensdatenbankenEtsy-Bewertungen mit OpenAI RAG in Slack posten11 Schritte