The Scenario
It's 7:30 AM. The daily call list needs to be distributed to the sales reps by 8 AM. You're a field sales manager. The 2,000 inbound leads that came in overnight all have phone numbers but no geographic data — the form didn't collect city or state. Territory assignments run by geographic region. Without knowing which area codes correspond to which states, you can't route the calls.
Someone on the team suggested building a ZIP lookup table. That's a two-week project.
The bad version:
- Google area codes one at a time and manually fill in the city and state columns — workable for 20 leads, not 2,000.
- Try to find a free area code CSV, download it, import it into a second sheet, write a VLOOKUP — and discover the CSV hasn't been updated since 2019 and several codes are missing.
- Delay the call list distribution, explain to the reps that assignments are coming "soon," and lose the morning.
The 8 AM deadline is not soft. The reps need the list before their shift starts.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your Google Sheet and calls Interzoid's area code geography API for every lead phone number — appending primary city and state without you touching a lookup table.
For each phone number in column A, use Interzoid to look up the area code's primary city and state and write them to columns B and C.
What You Get
- Column B: primary city associated with the area code.
- Column C: state associated with the area code.
- A lead list ready for territory-based routing — filter by column C to create the per-rep call sheets.
What If the Data Is Not Quite Ready
Phone numbers in column A have inconsistent formatting — parentheses, dashes, spaces
Before calling Interzoid, strip all non-numeric characters from phone numbers in column A and write cleaned numbers to a helper column, then look up the area code geography and write primary city and state to columns B and C.
You need to handle toll-free numbers (800, 888, etc.) separately
For each number in column A, check if the area code is a toll-free prefix (800, 888, 877, 866, 855). If so, write 'TOLL-FREE' in column B and skip Interzoid. For all other numbers, look up the area code geography and write city and state to columns B and C.
You want territory name as well — your regions are Northeast, Southeast, Midwest, West
After writing state to column C, add a column D that maps each state to your four territory regions: Northeast, Southeast, Midwest, or West.
Full territory assignment in one shot
Extract the area code geography for every number in column B using Interzoid and write the associated city and region to columns C and D. Map each state to territory (Northeast/Southeast/Midwest/West) and write to column E. Then create four separate sheets — one per territory — each containing the leads assigned to that region, sorted by state.
The reps get their filtered call sheets. The distribution happens at 7:58 AM.
Try It
Get the 7-day free trial of SheetXAI and open your lead roster — ask SheetXAI to append area code city and state to column A before the morning distribution. Then see the spoke on bulk validating phone numbers for carrier and risk, or the full Interzoid integration overview.