Enrich Polish Company Data by NIP with VAT Whitelist & KRS (n8n)

Enrich Polish company records from NIP using the VAT White List and KRS (n8n)

Stop manually verifying Polish businesses. This n8n workflow reads NIP tax numbers from your Google Sheets, checks each company against the Polish VAT White List, pulls available KRS court-register data, and writes enriched details back to the same sheet.

What this workflow does

• Runs on demand (Manual Trigger) whenever you start the workflow.
• Reads NIP rows from a Google Sheets spreadsheet—expects a column containing a NIP header (you can align it to your sheet).
• Normalizes and validates each NIP: it cleans the number, performs a checksum validation, and keeps the corrected NIP for lookups.
• Queries the Polish Ministry of Finance VAT White List API to retrieve VAT status and company details such as company name, REGON, KRS number (when present), addresses, and registered bank accounts.
• Uses the returned KRS number to query the KRS court register API, continuing gracefully even if no court record exists (e.g., sole traders).
• Merges and flattens results into one row per NIP, including legal form, registration dates, people/roles, main PKD activity, and a timestamp; long fields are capped.
• Updates Google Sheets in write-back mode by matching the processed NIP rows and filling enriched columns (you must pre-create the output headers).

Use cases

• Enrich supplier/customer lists with VAT status and verified legal identifiers before onboarding.
• Reduce risk in procurement by validating whether a counterparty appears in the VAT White List.
• Maintain clean CRM or billing datasets by auto-populating addresses, REGON, KRS, and key registration info.
• Prepare data for compliance workflows that depend on NIP-to-entity enrichment.

Technical details

• Manual Trigger
• Google Sheets (read + write-back to update enriched columns)
• HTTP Request (VAT White List API + KRS court register API)
• Code / set / sticky note nodes for normalization, mapping, and field handling
• Returns merged VAT + KRS enrichment per NIP with a timestamp and capped long fields