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 'Targets' sheet — but the rest of the sheet 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 sheet — 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 sheet 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 Google Sheet. 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.
For each Enigma ID in column A of my 'Targets' Google Sheet, fetch the full business profile and write the primary address, industry, associated contacts, and website into columns B through E.
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 sheet 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 'Targets' sheet, 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 'Targets', 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 'Targets', fetch the business profile. For each associated person returned, create a separate row in a new 'Contacts' tab 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 'Targets': fetch the business profile, write primary address into column B, industry into column C, and website into column D. In a separate 'Contacts' tab, 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 'Targets' tab 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 Google Sheet 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.