The Scenario
Your CRM admin has a nagging suspicion. After three separate CSV imports over the past year — one from a conference list, one from a partner handoff, one from a form tool migration — Nutshell probably has several hundred duplicate contacts. Nobody has ever checked. The problem surfaces in customer success when two reps call the same person from different records, and it surfaces in reporting when contact counts look off. Today is the day someone finally digs in.
The bad version:
- You export all Nutshell contacts as a CSV, open it in Google Sheets, and start looking for duplicate emails by eye.
- You write a COUNTIF formula to flag emails that appear more than once. It works on 200 rows and then something breaks because two email values have invisible trailing spaces.
- You spend 30 minutes debugging the formula and are not confident the results are complete.
The duplicate problem is real. The detection method shouldn't be this fragile.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet and, through its built-in Nutshell integration, can pull the full contact list and flag duplicates in a single operation.
Open SheetXAI in the sidebar and ask:
List all Nutshell contacts and write contact ID, full name, email, and account name into this sheet — then highlight any rows where the email address appears more than once
What You Get
- One row per Nutshell contact with ID, name, email, and account name.
- Rows where the email appears on more than one record highlighted or flagged so they're immediately visible.
- Contacts with no email address listed clearly rather than hidden or excluded.
- A count of duplicate groups written below the data so you know the scope before you start merging.
What If the Data Is Not Quite Ready
You want a Duplicate flag column instead of visual highlighting
Fetch all Nutshell contacts, dump them into my Google Sheet with ID, name, and email, then add a Duplicate flag column that marks TRUE for any email that appears on more than one row
Some emails differ only by case or trailing whitespace
Fetch all Nutshell contacts and write ID, name, and email into this sheet — normalize emails to lowercase and trim whitespace before dedup comparison, then flag any email that appears on more than one row after normalization
You want to see only the duplicates, not the full list
Fetch all Nutshell contacts, identify any email that appears on more than one record, and write only those rows into this sheet — showing all records that share a duplicated email so I can decide which to keep
Full dedup audit in one shot
Fetch all Nutshell contacts, normalize emails to lowercase and trim whitespace, flag rows where the normalized email appears on more than one record with TRUE in a Duplicate column, sort by email ascending so duplicates appear adjacent, and write a summary count below the data showing the total number of duplicate groups found
When the CRM audit has been deferred long enough, describe the full dedup detection — the normalization, the flagging, the sort, the summary — in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet for your next CRM cleanup session — then ask it to pull the full Nutshell contact list and surface every duplicate email. You can also bulk-import new contacts with automatic dedup checking, provision custom fields for standardization, or bulk-tag leads after an ICP scoring exercise.