The Scenario
The third time this week, your RevOps lead has asked for the same thing: a fresh prospecting list for the Texas construction vertical, pulled to spec, ready for sequencing by end of day. The first time, you built it manually from a vendor database. The second time, you re-exported it because the original had stale addresses. This time, you want to just pull what you need from Enigma's business database straight into Excel and hand it over.
The bad version:
- Log into Enigma's API console, write a GraphQL query for legal entities in the construction sector in Texas, export the result as JSON, write a conversion script to flatten the response into rows, paste the rows into the workbook, and then notice that the incorporation date format doesn't match what the sequencing tool expects.
- Send a corrected version. Get a reply asking for the TIN column too. Export again.
- Realize the export has 150 rows but the RevOps lead wanted only entities incorporated after 2015. Filter the workbook manually. Send the third version.
The list needed to be in the sequence tool four hours ago.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent built into your Excel workbook. It calls Enigma's business search API directly and writes the results into the workbook — no JSON parsing, no intermediate exports, no schema translation.
Use Enigma's GraphQL search to find 100 legal entities in Texas in the construction sector, import their names, TINs, and incorporation dates into my Excel sheet, and sort by incorporation date descending.
What You Get
- Column A: legal entity name for each matching business
- Column B: TIN (Employer Identification Number)
- Column C: state of incorporation date
- Results are sorted by incorporation date descending as requested
- If Enigma returns more results than the limit specified, SheetXAI writes up to that limit and notes the total available
What If the Data Is Not Quite Ready
You need more fields than the basic three
The sequencing tool also requires the registered address and the Enigma entity ID for deduplication.
Use Enigma's GraphQL search to find 100 legal entities in Texas in the construction sector. Write entity name, TIN, incorporation date, primary address, and Enigma entity ID into columns A through E of my Excel sheet, sorted by incorporation date descending.
You want to filter by incorporation year
You only want entities incorporated after 2015.
Use Enigma's GraphQL search to find legal entities in Texas in the construction sector incorporated after January 1, 2015. Write entity name, TIN, and incorporation date into columns A, B, and C of my Excel sheet, sorted by incorporation date descending.
The list needs to be deduplicated against an existing prospecting workbook
You already have a 'Contacted' worksheet with businesses you've already reached out to.
Search Enigma for construction sector legal entities in Texas and write results into columns A through C of my Excel sheet. Then remove any row where the entity name in column A matches a name in the 'Contacted' worksheet's column A.
Pull, deduplicate, normalize TIN format, and sort by incorporation date in one instruction
Search Enigma for construction legal entities in Texas. Write name, TIN, and incorporation date into columns A, B, and C. Format all TINs in column B as XX-XXXXXXX. Remove any rows where column A matches anything in 'Contacted' column A. Sort the remaining rows by incorporation date descending.
This is one prompt, not four tasks. SheetXAI chains them without you having to pause between steps.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook, then ask it to pull a targeted business list from Enigma by industry and location. To enrich those same businesses with verified identity data, see the bulk enrichment article or return to the Enigma overview.