{"product_id":"enrich-polish-company-data-by-nip-with-vat-whitelist-krs-n8n","title":"Enrich Polish Company Data by NIP with VAT Whitelist \u0026 KRS (n8n)","description":"\u003ch3\u003eEnrich Polish company records from NIP using the VAT White List and KRS (n8n)\u003c\/h3\u003e\n\u003cp\u003eStop manually verifying Polish businesses. This n8n workflow reads \u003cstrong\u003eNIP\u003c\/strong\u003e tax numbers from your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, checks each company against the \u003cstrong\u003ePolish VAT White List\u003c\/strong\u003e, pulls available \u003cstrong\u003eKRS\u003c\/strong\u003e court-register data, and writes enriched details back to the same sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on demand\u003c\/strong\u003e (Manual Trigger) whenever you start the workflow.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads NIP rows\u003c\/strong\u003e from a Google Sheets spreadsheet—expects a column containing a NIP header (you can align it to your sheet).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and validates each NIP\u003c\/strong\u003e: it cleans the number, performs a checksum validation, and keeps the corrected NIP for lookups.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQueries the Polish Ministry of Finance VAT White List API\u003c\/strong\u003e to retrieve VAT status and company details such as company name, REGON, KRS number (when present), addresses, and registered bank accounts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses the returned KRS number to query the KRS court register API\u003c\/strong\u003e, continuing gracefully even if no court record exists (e.g., sole traders).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMerges and flattens results\u003c\/strong\u003e into one row per NIP, including legal form, registration dates, people\/roles, main PKD activity, and a timestamp; long fields are capped.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets in write-back mode\u003c\/strong\u003e by matching the processed NIP rows and filling enriched columns (you must pre-create the output headers).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eEnrich supplier\/customer lists with \u003cstrong\u003eVAT status\u003c\/strong\u003e and verified legal identifiers before onboarding.\u003c\/li\u003e\n  \u003cli\u003eReduce risk in procurement by validating whether a counterparty appears in the \u003cstrong\u003eVAT White List\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eMaintain clean CRM or billing datasets by auto-populating addresses, REGON, KRS, and key registration info.\u003c\/li\u003e\n  \u003cli\u003ePrepare data for compliance workflows that depend on NIP-to-entity enrichment.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\u003cstrong\u003eManual Trigger\u003c\/strong\u003e\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (read + write-back to update enriched columns)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP Request\u003c\/strong\u003e (VAT White List API + KRS court register API)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCode \/ set \/ sticky note\u003c\/strong\u003e nodes for normalization, mapping, and field handling\u003c\/li\u003e\n  \u003cli\u003eReturns merged VAT + KRS enrichment per NIP with a timestamp and capped long fields\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45785646170291,"sku":"N8N-17916","price":41.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/UWZqbWt1Jx6zZzYaMPOrb_P6T24Ocw.png?v=1786180074","url":"https:\/\/buyflowscripts.com\/products\/enrich-polish-company-data-by-nip-with-vat-whitelist-krs-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}