Enrich HubSpot Companies with Polish CEIDG Data using NIP Identifiers

Description

This workflow automatically enriches HubSpot company records with official data from the Polish CEIDG (Central Register and Information on Economic Activity) database when a NIP (Polish Tax ID) is added or updated.

Who's it for

Polish sales teams, marketing agencies, and CRM administrators who work with Polish companies in HubSpot and want to save time on manual data entry while ensuring data accuracy.

How it works

Trigger: Monitors HubSpot for changes to the "NIP" property on company records
Validation: Checks if the NIP field is not empty
API Query: Fetches official company data from the Polish CEIDG database using the provided NIP
Data Check: Verifies if company data was successfully retrieved
Transform: Maps CEIDG data to HubSpot company properties
Update: Enriches the HubSpot company record with:
Company name
Full address (street, city, postal code, state)
Phone number
Website URL
NIP and REGON numbers
Business start date
Error Handling: If NIP is invalid or no data found, adds a note to the company record

Requirements

HubSpot account** with:
Custom property "nip" created for companies
Custom property "ceidg_notes" created for companies (optional, for storing API notes)
App token or developer API credentials
CEIDG API Token** (free registration at https://dane.biznes.gov.pl/)
n8n instance** (self-hosted or cloud)

How to set up

Create HubSpot custom properties:
Go to HubSpot Settings > Properties > Company Properties
Create a "nip" property (single-line text)
Create a "ceidg_notes" property (multi-line text) for storing API responses

Get CEIDG API Token:
Register at https://dane.biznes.gov.pl/
Navigate to API section and generate your token
Add token to n8n credentials (HTTP Bearer Auth)

Configure HubSpot credentials:
Add your HubSpot App Token in n8n credentials
Or use HubSpot Developer API credentials

Activate the workflow:
Import this workflow to your n8n instance
Configure the credentials in all HubSpot and HTTP nodes
Activate the workflow

Test:
Add or update a NIP value in any HubSpot company record
Check if the company data gets automatically populated

How to customize

Add more fields**: Modify the "Transform data for HubSpot" Code node to map additional CEIDG fields
Change trigger property**: Update the HubSpot Trigger to monitor a different property name
Notification**: Add an email or Slack notification node after successful updates
Batch processing**: Add a schedule trigger to process multiple companies at once
Data validation**: Add nodes to validate NIP format before making the API call
Logging**: Add a Google Sheets or database node to log all enrichment activities

Notes

CEIDG database contains data for sole proprietorships registered in Poland
For limited liability companies (sp. z o.o.) and other entities, you'll need to use KRS (National Court Register) API instead
The workflow processes one company at a time as they are updated
API rate limits apply based on your CEIDG API plan