The Scenario
Someone on the legal team dropped a message in your Slack channel at 4:45 PM on a Thursday: the new vendor onboarding policy now requires OFAC screening before any new business partner contract is countersigned. You have 50 new partners in your 'New Partners' Google Sheet — names in column A — and countersigning is scheduled to start Monday morning.
The bad version:
- Manually look up each business name in the OFAC SDN search tool, screenshot or note the result, and fill in column B by hand — 50 times.
- Reach row 23 and get an ambiguous partial match, spend fifteen minutes reading SDN list entries trying to determine whether it's actually your partner, and make a call you're not sure is defensible.
- Finish the list Saturday morning, email it to legal, and get a reply asking whether you also checked the EU Consolidated List and BIS Entity List — which you didn't.
The countersigning window is Monday. The screening has to be documented, not just done.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent built into your Google Sheet. It reads the 'New Partners' tab and calls Enigma's sanctions screening API for every business in column A, writing the result directly back into the sheet — no manual lookups, no tab-switching.
Run Enigma sanctions screening on every business name in column A of my 'New Partners' Google Sheet and write the alert status and matched watchlist name into columns B and C.
What You Get
- Column B: screening result — CLEAR, ALERT, or REVIEW for each business
- Column C: the name of the matched watchlist (OFAC SDN, EU Consolidated, BIS Entity List, etc.) for any ALERT rows
- CLEAR rows get a clean marker so the legal team can see the full picture at a glance
- Partial matches that need human review are surfaced as REVIEW rather than silently passing
What If the Data Is Not Quite Ready
Business names have inconsistent formatting (DBA vs. legal name)
Some rows list the doing-business-as name, others the registered legal entity name.
Run Enigma watchlist screening on every business in column A of 'New Partners'. For each name, screen both the value in column A and the registered entity name in column B if it's different. Write the alert status and matched list into columns C and D.
You need to screen addresses as well as names
Some partners appear on watchlists by address, not company name.
Screen every business in my 'New Partners' sheet against Enigma watchlists using both the name in column A and the address in column B. Write the combined alert status into column C and the matched watchlist into column D, flagging any row where the address triggered a match separately in column E.
Only new rows added this week need screening
The sheet has rows from prior weeks that have already been screened.
For all rows in my 'New Partners' sheet where column C is blank, run Enigma sanctions screening on the business name in column A. Write the alert status into column B and the matched watchlist name into column C. Skip any row that already has a value in column B.
Full onboarding compliance pass: screen, score risk, document, and notify in one shot
For every business in 'New Partners': run Enigma sanctions screening on the name in column A, write the alert status into column B and matched watchlist into column C, set column D to 'High Risk' if the status is ALERT or REVIEW and 'Low Risk' if CLEAR, then in a new 'Compliance Log' tab create a timestamped summary row for each screened business with its name, status, and risk classification.
The point is that screening, risk tagging, and documentation are one operation — not three separate passes that have to be reconciled afterward.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of business partners or vendors, then ask it to run Enigma sanctions screening across the list. To also run full KYB verification on the same partners, see the KYB batch article or return to the Enigma overview.