Check companies in the official register
Legal name, number, status and VAT validity for each company in your list, from official sources.
- You start it: When you start it
What it does
The task
Open the sheet sheet url. For each company, search the official company register of its country, such as Companies House in the UK or the Handelsregister in Germany. Check its VAT number in the EU VIES service when it has one. Record the legal name, the registration number, the status (active, dissolved or in liquidation), the date of incorporation, the registered address, and whether the VAT number is valid, with the date of the check. Write the results in new columns, and mark each row where the name or the address differs from our data. Do not change the original columns.
- It works in any government site and Google Sheets, in the workspace you pick, and signs in with passwords from your Cuiar vault.
- It runs once, when you start it.
What you give it
| Blank | What to give | Example |
|---|---|---|
| sheet url | The Google Sheet with company names, countries and VAT numbers | https://docs.google.com/spreadsheets/d/1Cr5hWk3Tp/edit |
What you get back
An example run with the example values above. Your run uses your own data.
Companies checked: 146 suppliers in 9 countries
Active: 131. Dissolved: 4. In liquidation: 3. Not found: 8
VAT numbers valid: 118 of 127. Not valid: 9
Name differs: 17 (for example, 'Bergmann Tools' is 'Bergmann Werkzeuge GmbH')
Address differs: 11
Needs attention: Lumen Print Ltd was dissolved in March 2026 and still gets orders
New columns: Legal name, Number, Status, Incorporated, Address, VAT valid, Checked on
Run it in Cuiar
- 01
Open it
Click Use in Cuiar on this page. The side panel opens with the task in the composer.
- 02
Fill in the blank
Type sheet url. Tab moves to the next blank.
- 03
Run it
Run sends it to the agent. Follow each step in the panel, and stop it at any time.
From the terminal
cuiar exec "Open the sheet https://docs.google.com/spreadsheets/d/1Cr5hWk3Tp/edit. For each company, search the official company register of its country, such as Companies House in the UK or the Handelsregister in Germany. Check its VAT number in the EU VIES service when it has one. Record the legal name, the registration number, the status (active, dissolved or in liquidation), the date of incorporation, the registered address, and whether the VAT number is valid, with the date of the check. Write the results in new columns, and mark each row where the name or the address differs from our data. Do not change the original columns."Run it from your AI agent
Claude Code, Codex, Cursor and other MCP clients reach Cuiar at https://mcp.cuiar.com/mcp. Add the server one time, then ask for the task in plain words, or call run_task yourself.
1. Add Cuiar to Claude Code
claude mcp add --transport http cuiar https://mcp.cuiar.com/mcp2. Ask your agent
Use the Cuiar tool run_task to run my "Check companies in the official register" template with sheet url = https://docs.google.com/spreadsheets/d/1Cr5hWk3Tp/edit.Setup for other agents: AI agents.
The tool call
{
"name": "run_task",
"arguments": {
"task": "Open the sheet https://docs.google.com/spreadsheets/d/1Cr5hWk3Tp/edit. For each company, search the official company register of its country, such as Companies House in the UK or the Handelsregister in Germany. Check its VAT number in the EU VIES service when it has one. Record the legal name, the registration number, the status (active, dissolved or in liquidation), the date of incorporation, the registered address, and whether the VAT number is valid, with the date of the check. Write the results in new columns, and mark each row where the name or the address differs from our data. Do not change the original columns."
}
}Related templates
All data templatesData
Turn a list on a website into a sheet
Each item from each page, one row for each, with no duplicates.
You start it: When you start it- Any website
- Google Sheets
Data
List local businesses with their contacts
Name, address, phone, website, rating and e-mail for each business.
You start it: When you start it- Google Maps
- Google Sheets
Data
Export your order history
For stores with no export: each order in a sheet, with totals for each year.
You start it: When you start it- Any online store
- Google Sheets
Data
Pull tables from PDFs into a spreadsheet
Each matching table from your PDFs and scans in one sheet, with numbers as numbers and the page noted.
You start it: When you start it- Google Drive
- Google Sheets
Data
Clean up a messy spreadsheet
Consistent names, dates, phone numbers and amounts in a new tab, with a count of each type of change.
You start it: When you start it- Google Sheets
Data
Find and merge duplicate rows in a sheet
Exact and near-duplicate rows grouped and merged into one row each, with a list of every merge.
You start it: When you start it- Google Sheets