The Scenario
The form submissions have been piling up in a Google Sheet for the past six weeks — 2,000 UK phone numbers collected from a landing page, a trade show badge scan, and a partner referral CSV someone uploaded last month. Your job is to validate the list and pass it to the outbound team with a clean signal: which numbers are mobile, which are landline, who's the carrier, and which ones are TPS-registered and off-limits.
You open the sheet and stare at column A. The numbers are a mix of formats. Some have country codes, some don't. A handful have letters in them from form validation failures you didn't catch at the time.
The bad version:
- Export the column to CSV, upload it to a validation service that checks format only, re-import the results, realize TPS status wasn't included, look for a separate tool, find one that only handles 50 numbers per day on the free plan
- Run 40 rows through the TPS lookup manually, spend 90 minutes, calculate that you need 48 more sessions like this to finish the list
- Paste the partial results into a Slack message asking a developer to help automate the rest, wait two days, get a script that works for the first 500 rows and then hits a rate limit
The outbound team has a kick-off call booked for Friday. Passing them a half-checked list isn't an option, and re-explaining why validation took this long isn't a conversation you want to have.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the data, understands the layout, and uses its built-in TPSCheck integration to validate, classify, and flag every number in the list — all in one pass. No exporting, no separate tools, no waiting on a developer.
For each UK phone number in column A, call TPSCheck and write whether the number is valid, its type (mobile/landline/VoIP), its network provider, its geographic region, and its TPS status into columns B through F
What You Get
- Column B: "valid" or "invalid" for each number — invalid entries include malformed numbers, disconnected ranges, and test numbers
- Column C: line type — "mobile," "landline," or "VoIP"
- Column D: network provider name (e.g., Three, Vodafone, Sky Mobile, BT)
- Column E: geographic region for landline numbers (e.g., "London," "Manchester," "Edinburgh")
- Column F: "TPS," "CTPS," or "clear" — the compliance status
What If the Data Is Not Quite Ready
Numbers arrived in mixed formats from different sources
Trade show badge scans often come through as 07700900123, landing page forms as +44 7700 900123, and partner CSVs as (44) 7700-900123. Before enrichment:
Normalize all phone numbers in column A to E.164 format (e.g., +447700900123), then for each one call TPSCheck and write the validity, line type, network, region, and TPS status into columns B through F
Some rows are missing a phone number entirely
If the form allowed optional phone entry, column A will have blanks scattered through the list:
Skip any row where column A is blank. For all rows that have a phone number in column A, run a TPSCheck lookup and write the validity, type, network, region, and TPS status into columns B through F. Write "no number" in column B for blank rows.
You need to join the results back to contact info in another tab
The phone numbers are in the "Leads" tab, but names and email addresses are in the "Contacts" tab, both keyed by a lead ID in column A of each:
Match each row in the "Leads" tab by the lead ID in column A to the corresponding row in the "Contacts" tab, then run a TPSCheck lookup on the phone number in column B of "Leads" and write the line type, network, and TPS status into columns C, D, and E of the "Leads" tab
Full cleanup and enrichment in one shot
In the "Raw Leads" tab: normalize all phone numbers in column A to E.164 format, flag any number that appears more than once in column A with "duplicate" in column G, then for each unique valid number call TPSCheck and write the validity, line type, network, region, and TPS status into columns B through F — leave columns B–F blank for duplicates and invalid entries
Ask for the deduplication and the enrichment together — SheetXAI handles both without needing two separate passes.
Try It
Open your form submissions sheet and Get the 7-day free trial of SheetXAI, then ask it to validate and classify the phone numbers in column A using TPSCheck. See also bulk TPS screening before a campaign or cleaning a large raw contact list for related workflows.