The Scenario
You are a sales rep. Your manager asked you to compare your Google Contacts against the CRM before the pipeline review on Thursday and flag anyone in your contacts who is not in the CRM as a potential missed lead.
You have 400 contacts saved in your Google account. Your CRM export is already in column A of a Google Sheet. You need the contacts in columns C through F.
The bad version:
- You go to contacts.google.com
- You try to export to CSV
- You open the CSV in a separate app, copy the columns you need
- You paste them into the sheet
- Some names come through with extra formatting characters
- Some phone numbers are in international format, some are not
- You spend an hour cleaning before you can even run the VLOOKUP
- You walk into Thursday's meeting with a partial list and a lot of qualifiers.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your sheet and calls Google's People API directly, so you get the contacts formatted how you need them without a manual CSV dance.
Open the SheetXAI sidebar and type:
Pull all my Google Contacts into this sheet — display name in column C, primary email address in column D, company in column E, and phone number in column F. Start at row 2 and add headers to row 1.
SheetXAI calls the People API, fetches all 400 contacts, and writes them into the sheet with the columns you specified. You have the full list in the format you need, ready for the VLOOKUP.
What You Get
400 rows of contact data, structured for comparison:
- Column C — display name
- Column D — primary email address
- Column E — company / organization
- Column F — phone number
- Row 1 — headers written automatically
If a contact has no company, the cell is blank, not an error. SheetXAI handles missing fields cleanly, so your VLOOKUP does not break on empty values.
You can filter the export before it lands. Ask for only contacts with a company name, or only contacts added in the last year, and SheetXAI applies the filter via the API.
What If the Data Is Not Quite Ready
Contact exports are rarely clean. SheetXAI handles normalization and the export in the same prompt.
When phone numbers are in inconsistent formats
Some contacts have +1 (555) 000-0000, some have 5550000000, some have nothing. You want a consistent format for the pivot table.
Pull all my Google Contacts into this sheet — name in column C, email in D, company in E. For phone numbers in column F, normalize all of them to the format (XXX) XXX-XXXX. If no phone number exists, write "missing" in column F.
When you only want contacts with a company name
The list has personal contacts mixed in. You only want the ones that have an organization.
Pull all my Google Contacts who have a non-blank company name. Write display name in C, email in D, company in E, phone in F. Skip contacts with no organization.
When you want to flag contacts not in the CRM immediately
Column A already has your CRM emails. You want to skip the manual VLOOKUP.
Pull all my Google Contacts into columns C through F — name, email, company, phone. Then compare the email addresses in column D against the CRM emails in column A. For each contact email that does not appear in column A, write "not in CRM" into column G. For ones that match, write "in CRM".
When you want a combined enrichment and gap analysis in one pass
You have the CRM export, the contacts, and you want a formatted summary for the meeting.
Pull all Google Contacts with a company name into columns C through F. Compare column D against column A (CRM emails). Write "not in CRM" or "in CRM" in column G. Then on the Summary tab, write a count of total contacts pulled, total not in CRM, and a list of the companies of the not-in-CRM contacts sorted alphabetically.
The pattern: instead of export, clean, paste, VLOOKUP, you describe the comparison you need and SheetXAI runs it end to end.
Try It
Get the 7-day free trial of SheetXAI and open any sheet, then ask it to export your Google Contacts into the columns you specify. The Gmail integration is included in every SheetXAI plan. For related workflows, see how to send bulk emails from a sheet or the Gmail in Google Sheets overview.