Track Etsy profit and listing margins in Google Sheets with Gemini summaries
Ready for 3.0What this workflow does
This workflow has 35 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Config (Code): runs custom JavaScript code
- Source = sample? (If): checks a condition and branches into true / false
- Sample Etsy exports (fake data) (Code): runs custom JavaScript code
- Source = sheet? (If): checks a condition and branches into true / false
- Compute P&L (Code): runs custom JavaScript code
- Read Statement tab (Google Sheets): uses Google Sheets
- Read statement CSVs (Read/Write Files from Disk): reads a file from disk
- Mode = gemini? (If): checks a condition and branches into true / false
- Read OrderItems tab (Google Sheets): uses Google Sheets
- Parse statement CSV (Extract from File): extracts data from a file (csv)
…plus 24 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Read/Write Files from Disk
n8n-nodes-base.readWriteFile - Extract from File
n8n-nodes-base.extractFromFile - HTTP Request
n8n-nodes-base.httpRequest - Convert to File
n8n-nodes-base.convertToFile
From the author
Quick overview Turn your Etsy monthly statement and Order Items CSVs plus a simple cost sheet into a monthly P&L, profit-by-listing flags, and a plain-language summary — without the Etsy API. Optional Gemini rewrite for the summary; otherwise a rule-based…