The Scenario
The third time this week, your RevOps lead has asked for the same thing: a fresh prospecting list for the Chicago restaurant 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 phone numbers. This time, you want to just pull what you need from Enigma's business database straight into Google Sheets and hand it over.
The bad version:
- Log into Enigma's API console, write a GraphQL query for operating locations in the restaurant industry in Chicago, export the result as JSON, write a conversion script to flatten the response into rows, paste the rows into the sheet, and then notice that the phone number format doesn't match what the sequencing tool expects.
- Send a corrected version. Get a reply asking for the SIC code column too. Export again.
- Realize the export has 250 rows but the RevOps lead wanted only businesses with an active operating status. Filter the sheet 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 Google Sheet. It calls Enigma's business search API directly and writes the results into the sheet — no JSON parsing, no intermediate exports, no schema translation.
Search Enigma for operating locations in the restaurant industry in Chicago, IL and write business name, address, and phone number into columns A, B, and C of my 'Prospects' Google Sheet.
What You Get
- Column A: business name for each matching operating location
- Column B: full street address
- Column C: phone number
- Results are scoped to active operating status by default — inactive businesses don't appear unless you ask for them
- If Enigma returns more results than fit on screen, SheetXAI writes all of them and tells you how many rows were populated
What If the Data Is Not Quite Ready
You need more fields than the basic three
The sequencing tool also requires the SIC code and the Enigma operating location ID for deduplication.
Search Enigma for restaurant industry operating locations in Chicago, IL and write business name, address, phone number, SIC code, and Enigma operating location ID into columns A through E of my 'Prospects' sheet.
You want to filter by a minimum number of associated locations
You only want multi-location restaurant groups, not single-unit operators.
Search Enigma for restaurant operating locations in Chicago, IL where the legal entity has more than three associated locations. Write business name, address, phone, and entity location count into columns A through D of my 'Prospects' sheet.
The list needs to be deduplicated against an existing prospecting sheet
You already have a 'Contacted' tab with businesses you've already reached out to.
Search Enigma for restaurant operating locations in Chicago, IL and write results into columns A through C of my 'Prospects' sheet. Then remove any row where the business name in column A matches a name in the 'Contacted' tab's column A.
Pull, deduplicate, format phone numbers, and sort by zip code in one instruction
Search Enigma for operating restaurant businesses in Chicago, IL. Write name, address, and phone into columns A, B, and C of 'Prospects'. Format all phone numbers in column C as (XXX) XXX-XXXX. Remove any rows where column A matches anything in 'Contacted' column A. Sort the remaining rows by zip code ascending.
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 Google Sheet, 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.