The Scenario
You joined the deal team at a private equity firm two weeks ago. Your first assignment: prepare the due diligence data room for 30 target acquisitions. A senior analyst matched them to Enigma IDs last month — they're sitting in column A of the 'Due Diligence' Excel table — but the rest of the workbook is empty. Addresses, industries, associated contacts, websites: all blank. The IC meeting is in eight days.
The bad version:
- Write a script to call Enigma's business profile endpoint for each ID, handle authentication, parse the response JSON for the six fields you need, and write the results to the workbook — then discover that four IDs return a different response schema because they're structured entities rather than operating locations, and the script crashes.
- Fix the script, re-run it, notice that the 'associated people' field returns a nested array that doesn't flatten cleanly into a single cell, and spend two hours figuring out how to represent it.
- Deliver the workbook a day late with a note that the associated contacts column is formatted differently than what the data room template expects.
The IC deck needs to be finalized before the meeting. The data room can't be a blocker.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent built into your Excel workbook. It reads the Enigma IDs in column A, calls the business profile API for each one, and writes the relevant fields back — handling schema variations across entity types without you having to account for them.
Retrieve complete business details from Enigma for all 30 IDs in my Excel 'Due Diligence' table and populate the name, state, industry, and any associated people columns.
What You Get
- Column B: primary registered address for each entity
- Column C: industry classification
- Column D: associated contacts (key people linked to the entity in Enigma's data)
- Column E: website if available in the business profile
- Rows where a field isn't available in Enigma's data get a clear blank or "not available" marker rather than silently missing
What If the Data Is Not Quite Ready
Some Enigma IDs in the workbook are stale or no longer valid
A handful of the 30 IDs were matched six months ago and may have changed.
For each Enigma ID in column A of my Excel 'Due Diligence' table, attempt to fetch the business profile. Write the primary address, industry, and website into columns B, C, and E. For any ID that returns a "not found" or error response, mark column F as 'ID stale — re-match needed'.
You need the founding year and employee count in addition to the standard fields
The IC deck template has two more columns than the original brief.
For each Enigma ID in column A of the 'Due Diligence' table, fetch the full business profile and write primary address into column B, industry into column C, associated contacts into column D, website into column E, founding year into column F, and estimated employee count into column G.
The associated contacts field needs to be split into individual rows
The IC wants each person on their own row for the data room, not all contacts collapsed into one cell.
For each Enigma ID in column A of 'Due Diligence', fetch the business profile. For each associated person returned, create a separate row in a new 'Contacts' worksheet with the Enigma entity ID in column A, the person's name in column B, their title in column C, and their role in column D.
Full due diligence pull: profile, contacts, deduplication, and red-flag check in one pass
For each Enigma ID in column A of 'Due Diligence': fetch the business profile, write primary address into column B, industry into column C, and website into column D. In a separate 'Contacts' worksheet, create one row per associated person with the entity ID, name, and title. Then check each entity name against Enigma's watchlist and flag any match in column E of the 'Due Diligence' table as 'Watchlist hit'.
One instruction covers the profile pull, the contacts normalization, and the compliance flag — nothing requires a second pass.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a column of Enigma entity IDs, then ask it to pull full business profiles for your due diligence or research workflow. To run KYB verification on the same entities, see the KYB batch article or return to the Enigma overview.