Download KSeF (Poland’s e-invoicing system) invoices to an Excel spreadsheet

TL;DR; Download invoices from Poland's KSeF (Krajowy System e-Faktur) and export them as an XLSX spreadsheet. Handles the full v2 authentication flow automatically. --- Download KSeF invoices through n8n What it does This workflow connects to Poland's KSeF (Krajowy System e-Faktur) API v2, downloads invoice metadata for a configurable date range, and exports everything as a clean Excel spreadsheet (.xlsx). The spreadsheet includes: KSeF number, invoice number, issue date, seller/buyer NIP and name, net/VAT/gross amounts, currency, invoice type, and more. Who is it for Polish companies and accountants who need to bulk-download invoice data from KSeF for bookkeeping, reconciliation, or tax reporting. How to set up 1. Get your KSeF authorization token — log in at ksef.mf.gov.pl, go to token management, and generate a token. It looks like: YYYYMMDD-XX-XXXXXXXXXX-XXXXXXXXXX-XX|nip-XXXXXXXXXX|hash 2. Open the ⚙️ Config node and fill in: - nip — your 10-digit NIP - authToken — the KSeF token from step 1 - startDate / endDate — the date range in ISO 8601 format (e.g. 2026-01-01T00:00:00Z) - subjectType — use Subject2 for invoices you received (as buyer), Subject1 for invoices you issued (as seller) 3. Click "Test workflow" — the spreadsheet will appear as binary output in the Write XLSX node How it works (under the hood) KSeF API v2 requires a 6-step authentication flow: 1. Fetch the RSA public key certificate from KSeF 2. Request a challenge (nonce + timestamp) 3. RSA-OAEP encrypt your token with the challenge timestamp 4. Initialize authentication — returns a temporary JWT 5. Poll the auth status until it's ready 6. Redeem the temporary JWT for a real access token Only after step 6 can you query invoices. This workflow handles all of that automatically — you just provide your token and NIP. Extending the workflow Some ideas for what you can add after the Write XLSX node: - Write Binary File — save the spreadsheet to disk - Send Email (Gmail / SMTP) — email the spreadsheet as an attachment - Google Drive — upload the spreadsheet to Drive - Postgres / MySQL — write invoice data to a database for querying - Download Invoice XML — add an HTTP Request node to GET /invoices/{ksefNumber} with the access token to download the full invoice XML Requirements - A KSeF authorization token (generated at ksef.mf.gov.pl) - No external credentials or API keys needed in n8n — everything goes through the Config node - Works with n8n self-hosted and cloud API reference - KSeF API v2: https://api.ksef.mf.gov.pl/v2 - KSeF test environment: https://api-test.ksef.mf.gov.pl/v2 - Official docs: https://www.gov.pl/web/kas/krajowy-system-e-faktur Made with ❤️ by Greg Brzezinka([email protected]) Need help? Reach out to me! --- Tags ksef, poland, invoices, tax, e-invoicing, spreadsheet, xlsx, accounting Categories Finance & Accounting, Data Transformation