Verify Polish VAT taxpayers from Google Sheets with the Biała Lista API
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 7 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Set API and Columns (Edit Fields (Set)): sets 4 fields: whiteListApi, nipColumn, nameColumn…
- Read Contractors from Sheets (Google Sheets): uses Google Sheets
- Normalize and Validate NIPs (Code): runs custom JavaScript code
- Fetch VAT White List Status (HTTP Request): calls an HTTP API
- Determine VAT Compliance Status (Code): runs custom JavaScript code
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 (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest
From the author
Quick overview This workflow reads contractor NIP numbers from Google Sheets and checks each one against Poland’s Ministry of Finance VAT “white list” API to verify VAT active status and (optionally) whether a provided bank account is registered, returning a…