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.
You have 400 contacts saved in your Google account. Your CRM export is already in column A of an Excel workbook. You need the contacts in columns C through F.
The bad version:
- You go to contacts.google.com and export to CSV
- You open the CSV in Excel — it opens as a new workbook
- You copy the columns you need and paste into the original workbook
- Some names come through with encoding artifacts
- Phone numbers are in three different formats
- You spend an hour normalizing before you can run the VLOOKUP
- You walk into Thursday's meeting with a partial list.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your workbook and calls Google's People API directly, so you get the contacts formatted the way you need them without the CSV dance.
Open the SheetXAI sidebar and type:
Pull all my Google Contacts into this workbook — 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 workbook with the columns you specified.
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.
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.
Pull all my Google Contacts — name in C, email in D, company in E. Normalize phone numbers in column F to (XXX) XXX-XXXX format. If no phone exists, write "missing".
When you only want contacts with a company name
Personal contacts mixed in. You only want contacts with an organization.
Pull all my Google Contacts who have a non-blank company. 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. Skip the manual VLOOKUP.
Pull all my Google Contacts into columns C through F — name, email, company, phone. Compare email in column D against the CRM emails in column A. Write "not in CRM" in column G where no match is found, "in CRM" where a match exists.
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 into columns C through F. Compare column D against column A. Write "not in CRM" or "in CRM" in column G. Then on the Summary tab, write total contacts pulled, total not in CRM, and a list of companies for the not-in-CRM contacts sorted alphabetically.
The pattern: instead of export, clean, paste, VLOOKUP, you describe the comparison and SheetXAI runs it end to end.
Try It
Get the 7-day free trial of SheetXAI and open any workbook, 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 an Excel workbook or the Gmail in Excel overview.