Clean and enrich a company list with Goava MCP
Complete, correct and check a file of companies against Goava and your CRM using an AI assistant.
If you have a file of companies with incomplete, incorrect or outdated data, you can let Claude, ChatGPT or another AI assistant that supports MCP clean and enrich it for you with Goava MCP. It could be a lead list from a trade fair, an export from a previous CRM, a partner list or a customer register that hasn’t been updated in a while.
You get the file back with complete, up-to-date company data and can see at the same time what already exists in your CRM. It saves a lot of manual work and helps you avoid duplicates and existing customers ending up as new leads.
What you can do
- Fill in missing basic data: organization number, address, website, industry (SNI code), number of employees, revenue and more.
- Correct and clean: find misspelled names, old company names and duplicates, and get a consistent format for things like organization numbers.
- Flag companies that are no longer relevant, e.g. deregistered, bankrupt or in liquidation.
- See group affiliation: which rows belong to the same group, and which belong to a group where you already have a customer.
- Check against your CRM whether the company already exists, whether it’s a customer and who owns it.
- See whether the contacts in the file already exist in your CRM.
- Get back a new file with a column showing whether each company is a customer, a prospect or missing from your CRM, ready to import or to update existing records with.
Step by step
- Connect Goava MCP by adding a new connector with the address https://mcp.goava.com/mcp and logging in with your Goava account. In Claude, you do this under Settings → + → Add custom connector. In other AI tools it may be called connectors, apps or MCP servers.
- Connect your CRM’s MCP the same way if you want to match directly against your CRM.
- Start a new chat and make sure the connectors are enabled.
- Upload your Excel or CSV file.
- Describe what you want done. Feel free to start from the example prompts below.
- Test on a few rows first, check the result, then run the full list.
- Download the new file and import it into your CRM.
Example prompts
Enrichment with Goava only
Match all companies in the attached file against Goava. Add columns for organization number, number of employees, revenue and industry. Flag rows where you can’t find a reliable match, and flag duplicates. Give me a new Excel file.
Enrichment plus CRM check
Match all companies in the file against Goava and add organization number, number of employees, revenue and industry. Then check each company against [your CRM] by organization number: does it already exist, is it a customer and who owns it? Also check whether the contacts already exist. Add a column for CRM status (Customer, Prospect, Not in CRM) and give me a new Excel file.
Good to know
- Not every row may get a match. This is usually because the company name in the list is incomplete or misspelled. Those rows are easy to complete manually. You can ask the AI assistant to suggest the most likely match, but check those rows before you import.
- Organization number is the most reliable key for matching against your CRM. Matching on name or domain works but is less precise, especially in larger groups.
- What the AI assistant can do in your CRM depends on your CRM’s MCP and your permissions. Always check the result before you import or change anything.