The Scenario
You work in a call center's data team. Last week the inbound line logged 500 phone numbers — no names, no emails, no company associations, just raw phone strings in column A. Before the sales team can work the list, someone needs to reverse-lookup carrier, geographic location, and associated name for each number to separate genuine inbound interest from noise.
The bad version:
- Paste each number into a reverse-lookup tool one at a time, copy three fields per row, paste them into columns B, C, and D — 500 times, probably 3-4 hours of work
- Find a bulk-lookup site that accepts a CSV upload, upload the file, hope the output columns map cleanly, download the results, discover half the numbers came back with "Unknown" and now you need to figure out which rows to trust
- Write a script to call Datagma's API directly — authenticate, loop through the array, parse the JSON response, handle rate limits, write to the sheet
Nobody assigned a dev sprint to qualify this list. That script isn't getting written today.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the inbound leads tab, understands the layout, and through its built-in Datagma integration it runs reverse-lookup on every number in column A and writes the results back — carrier, location, and name into columns B, C, and D.
For each phone number in column A, run a Datagma reverse lookup and write the associated name, carrier, and location into columns B, C, and D
What You Get
- Column B: associated name where Datagma found a match (blank where no match)
- Column C: carrier or network provider for each number
- Column D: geographic location (city/state or region) tied to the number
- Rows where Datagma returned no data are noted in column E so the team can triage them separately
What If the Data Is Not Quite Ready
The phone numbers have inconsistent formatting
Some are formatted as "(555) 867-5309", others as "15558675309" or "+1-555-867-5309". Datagma's API expects E.164 format.
Normalize all phone numbers in column A to E.164 format (+1XXXXXXXXXX), then run Datagma reverse lookup for each one and write name, carrier, and location into columns B, C, and D
You need to score lead quality based on the result
Your team wants to know at a glance which numbers are worth calling. Any number where Datagma found an associated name gets marked "Verified," everything else gets "Unknown."
Reverse-lookup all 500 phone numbers in my 'Inbound Leads' sheet and add a 'Lead Quality' column using the result — 'Verified' if a name was found, 'Unknown' otherwise
Some numbers are duplicates from the same inbound session
The log captured a few numbers multiple times when callers hung up and called back. You want each number looked up only once.
Deduplicate column A by phone number, then run Datagma reverse lookup on the unique set and write name, carrier, and location into columns B, C, and D — mark the duplicate rows in column E
Full normalization, dedup, lookup, and quality score in one shot
The numbers have mixed formats, there are duplicates, and you want a lead quality column before handing the sheet to sales.
Normalize all phone numbers in column A to E.164 format, deduplicate the list, run Datagma reverse lookup on the unique numbers, write name into column B, carrier into column C, location into column D, and write 'Verified' or 'Unknown' into column E based on whether a name was found
Try It
If your inbound number log is sitting raw in Google Sheets with no enrichment, open it and get the 7-day free trial of SheetXAI. Ask it to run Datagma reverse lookup across column A and you'll have carrier, location, and name data written in before the sales team's next shift. For related workflows, see bulk-enrich a lead list or append mobile phone numbers.