AutomationFlowsFinance › Generate Daily Etsy Sales and Ledger Reports via Shop Operations API

Generate Daily Etsy Sales and Ledger Reports via Shop Operations API

ByPawel Jurczyk @pavvel on n8n.io

This workflow runs daily to pull recent Etsy receipts and payment-account ledger entries via a linked sub-workflow, then aggregates sales metrics by currency and fee totals by ledger type and outputs a consolidated report object for downstream accounting or BI tools. Runs every…

Cron / scheduled trigger★★★★☆ complexity11 nodes
Finance Trigger: Cron / scheduled Nodes: 11 Complexity: ★★★★☆ Added:

This workflow corresponds to n8n.io template #16655 — we link there as the canonical source.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "name": "Generate Etsy sales and ledger reports (PRO)",
  "nodes": [
    {
      "id": "sales-schedule",
      "name": "Generate report every day",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        0,
        420
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "sales-config",
      "name": "Configuration (EDIT ME)",
      "type": "n8n-nodes-base.set",
      "position": [
        280,
        420
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "sales-receipts-request",
      "name": "Request receipts",
      "type": "n8n-nodes-base.set",
      "position": [
        560,
        420
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "sales-receipts",
      "name": "Get Etsy receipts",
      "type": "n8n-nodes-base.executeWorkflow",
      "position": [
        840,
        420
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "sales-ledger-request",
      "name": "Request ledger entries",
      "type": "n8n-nodes-base.set",
      "position": [
        1120,
        420
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "sales-ledger",
      "name": "Get Etsy ledger entries",
      "type": "n8n-nodes-base.executeWorkflow",
      "position": [
        1400,
        420
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "sales-aggregate",
      "name": "Build sales and fee report",
      "type": "n8n-nodes-base.code",
      "position": [
        1680,
        420
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "sales-output",
      "name": "Sales report output",
      "type": "n8n-nodes-base.set",
      "position": [
        1960,
        420
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "sales-overview",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -40,
        -420
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "sales-section-1",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -60,
        300
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "sales-section-2",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1460,
        300
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "settings": {
    "executionOrder": "v1"
  },
  "connections": {
    "Request receipts": {
      "main": [
        [
          {
            "node": "Get Etsy receipts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Etsy receipts": {
      "main": [
        [
          {
            "node": "Request ledger entries",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Request ledger entries": {
      "main": [
        [
          {
            "node": "Get Etsy ledger entries",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Configuration (EDIT ME)": {
      "main": [
        [
          {
            "node": "Request receipts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Etsy ledger entries": {
      "main": [
        [
          {
            "node": "Build sales and fee report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate report every day": {
      "main": [
        [
          {
            "node": "Configuration (EDIT ME)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build sales and fee report": {
      "main": [
        [
          {
            "node": "Sales report output",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

This workflow runs daily to pull recent Etsy receipts and payment-account ledger entries via a linked sub-workflow, then aggregates sales metrics by currency and fee totals by ledger type and outputs a consolidated report object for downstream accounting or BI tools. Runs every…

Source: https://n8n.io/workflows/16655/ — original creator credit. Request a take-down →

More Finance workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Finance

EVEZ Groq Engine — llama-3.3-70b — FREE 24/7. Uses errorTrigger. Scheduled trigger; 9 nodes.

Error Trigger
Finance

This template sets up a weekly ETL (Extract, Transform, Load) pipeline that pulls financial data from QuickBooks Online into Google BigQuery. It not only transfers data, but also cleans, classifies, a

QuickBooks, Google BigQuery
Finance

This workflow automates the process of recording successful payments from Stripe into QuickBooks by creating corresponding Sales Receipts. It ensures payment data is captured accurately, checks whethe

QuickBooks, Stripe
Finance

This automation manages Stripe disputes by fetching dispute data, formatting it, logging it into Google Sheets, updating related payment records, and notifying the customer via email. It ensures finan

HTTP Request, Google Sheets, Gmail
Finance

This n8n workflow automates the integration between Xero and FileMaker, allowing for seamless data transfer between the two platforms. By listening for webhooks from Xero (e.g., new invoices, payments

Crypto, Move Binary Data, Filemaker