Check a company in seven EU business registers from a form

{
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Check a company in seven EU business registers from a form",
  "nodes": [
    {
      "id": "a1000000-0000-4000-8000-000000000001",
      "name": "Someone submits the form",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        -220,
        0
      ],
      "webhookId": "b1000000-0000-4000-8000-000000000001",
      "parameters": {
        "options": {},
        "formTitle": "Company check",
        "formFields": {
          "values": [
            {
              "fieldLabel": "Company name or registration number",
              "placeholder": "Bolt, or cz:27074358",
              "requiredField": true
            },
            {
              "fieldType": "dropdown",
              "fieldLabel": "Country",
              "fieldOptions": {
                "values": [
                  {
                    "option": "cz"
                  },
                  {
                    "option": "ee"
                  },
                  {
                    "option": "fi"
                  },
                  {
                    "option": "fr"
                  },
                  {
                    "option": "no"
                  },
                  {
                    "option": "pl"
                  },
                  {
                    "option": "sk"
                  }
                ]
              },
              "requiredField": true
            }
          ]
        },
        "formDescription": "Enter a company name or a registration number. The official register of the country is read directly."
      },
      "typeVersion": 2.2
    },
    {
      "id": "a1000000-0000-4000-8000-000000000002",
      "name": "Look up the official register",
      "type": "@apify/n8n-nodes-apify.apify",
      "position": [
        20,
        0
      ],
      "parameters": {
        "build": "",
        "memory": 1024,
        "actorId": "gubidonius~company-registry-lookup",
        "timeout": 600,
        "resource": "Actors",
        "operation": "Run actor and get dataset",
        "customBody": "={{ JSON.stringify({ queries: [$json['Company name or registration number']], countries: [$json['Country']], maxResultsPerQuery: 5, onlyActive: false }) }}",
        "actorSource": "store",
        "authentication": "apifyApi"
      },
      "typeVersion": 1
    },
    {
      "id": "a1000000-0000-4000-8000-000000000003",
      "name": "Is the company still active",
      "type": "n8n-nodes-base.if",
      "position": [
        260,
        0
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "caseSensitive": false
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "c1000000-0000-4000-8000-000000000001",
              "operator": {
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.status }}",
              "rightValue": "active"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "a1000000-0000-4000-8000-000000000004",
      "name": "Passed, keep the register fields",
      "type": "n8n-nodes-base.set",
      "position": [
        520,
        -100
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "d1",
              "name": "verdict",
              "type": "string",
              "value": "ok"
            },
            {
              "id": "d2",
              "name": "company",
              "type": "string",
              "value": "={{ $json.name }}"
            },
            {
              "id": "d3",
              "name": "registrationNumber",
              "type": "string",
              "value": "={{ $json.registrationNumber }}"
            },
            {
              "id": "d4",
              "name": "country",
              "type": "string",
              "value": "={{ $json.countryName }}"
            },
            {
              "id": "d5",
              "name": "legalForm",
              "type": "string",
              "value": "={{ $json.legalFormCode }}"
            },
            {
              "id": "d6",
              "name": "address",
              "type": "string",
              "value": "={{ $json.address }}"
            },
            {
              "id": "d7",
              "name": "vatNumber",
              "type": "string",
              "value": "={{ $json.vatNumber }}"
            },
            {
              "id": "d8",
              "name": "registryUrl",
              "type": "string",
              "value": "={{ $json.registryUrl }}"
            },
            {
              "id": "d9",
              "name": "registryUpdatedAt",
              "type": "string",
              "value": "={{ $json.registryUpdatedAt }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "a1000000-0000-4000-8000-000000000005",
      "name": "Not active, send it to a human",
      "type": "n8n-nodes-base.set",
      "position": [
        520,
        100
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "e1",
              "name": "verdict",
              "type": "string",
              "value": "check by hand"
            },
            {
              "id": "e2",
              "name": "company",
              "type": "string",
              "value": "={{ $json.name }}"
            },
            {
              "id": "e3",
              "name": "status",
              "type": "string",
              "value": "={{ $json.status }}"
            },
            {
              "id": "e4",
              "name": "statusRaw",
              "type": "string",
              "value": "={{ $json.statusRaw }}"
            },
            {
              "id": "e5",
              "name": "dissolvedAt",
              "type": "string",
              "value": "={{ $json.dissolvedAt }}"
            },
            {
              "id": "e6",
              "name": "registryUrl",
              "type": "string",
              "value": "={{ $json.registryUrl }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "a1000000-0000-4000-8000-000000000006",
      "name": "Read me",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -700,
        -140
      ],
      "parameters": {
        "color": 4,
        "width": 420,
        "height": 460,
        "content": "## What this does\n\nSomebody types a company name or a registration number into a form. The workflow reads that company straight out of the country's official business register and answers one question, which is whether the company is still active.\n\nSeven registers are covered and all of them return the same field names, so nothing downstream has to know which country it got.\n\nCzechia (ARES), Estonia (Ariregister), Finland (PRH), France (Annuaire des Entreprises), Norway (Bronnoysund), Poland (MF VAT list), Slovakia (RPO).\n\n## Setup\n\n1. Install the Apify node. It is verified by n8n, so it works on Cloud and on self-hosted.\n2. Add your Apify API key in the node credentials. A free Apify account is enough to start.\n3. Open the form URL on the trigger node.\n\nThe Actor is gubidonius/company-registry-lookup. It reads the government API of each\ncountry directly, so there is no login to any register and no personal data is returned.\n"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "connections": {
    "Someone submits the form": {
      "main": [
        [
          {
            "node": "Look up the official register",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Is the company still active": {
      "main": [
        [
          {
            "node": "Passed, keep the register fields",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Not active, send it to a human",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Look up the official register": {
      "main": [
        [
          {
            "node": "Is the company still active",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}