The Scenario
Your revenue ops team is onboarding a 40-person sales team onto Specific, and you have a Salesforce export sitting in an Excel workbook — 600 rows of contacts with emails in column A, first names in column B, last names in column C, and company names in column D. The team's first recorded calls are scheduled for Thursday. It is Tuesday afternoon.
The bad version:
- You open Specific's contact import wizard, upload a CSV from Excel, and discover that the "company name" field needs to match an existing Specific company record — not a string. You go back to the workbook to add company IDs. You don't have them.
- You look up the first 20 company IDs manually, paste them into column D, re-export, re-upload. Row 47 fails because the company name has a comma. The import stops.
- You restart the process for rows 1 to 46, then again for rows 48 to 600, separately. You finish at 9 PM. Forty-seven contacts are still missing their company association.
You're supposed to be setting up call scoring templates and rep assignments, not untangling field-mapping issues in a CSV upload wizard for four hours. The team goes live in 36 hours.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your workbook, understands the data, and through its built-in Specific integration it can create contacts in bulk — handling each row, writing back the result, and flagging errors inline. No CSV upload wizard, no field-mapping ceremony.
For each row in this Excel sheet, upsert a contact in Specific using email (A), full name (B), and company ID (C) — create if not exists, update if exists — and write the returned contact ID into column D
What You Get
- A new contact record in Specific for each row processed successfully.
- Column D populated with the returned contact ID for each success, or the specific API error for each failure — so you know exactly which rows need follow-up without re-running anything.
- Company associations handled at the API level using the IDs in column C.
- A completed import across all 600 rows without leaving the workbook.
What If the Data Is Not Quite Ready
The company name doesn't match any Specific company record
For each row in this Excel sheet, create a Specific contact using email (A), first name (B), last name (C), and company name (D) — if the company doesn't exist in Specific, create it first, then associate the contact — write the contact ID and company ID into columns E and F
The workbook has duplicate emails across rows
Before importing, check column A for duplicate email addresses and flag duplicates in column F with 'DUPLICATE' — then create a Specific contact for each unique email using columns A through D, writing the result into column G
The name is in a single Full Name column instead of split first/last
For each row in this Excel sheet, split the value in column B on the first space to get first name and last name, then create a Specific contact with email (A), the split first name, the split last name, and company name (C) — write the result into column D
Full cleanup-plus-import in one shot
Check column A for duplicate emails and flag them in column F. For unique rows only, create a Specific contact using email (A), first name (B), last name (C), and company name (D) — creating the company in Specific first if it doesn't already exist — then write the contact ID and company ID into columns G and H, and any errors into column I
The pattern is to ask for the cleanup and the import together. One prompt, one pass.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a CRM export of contacts you need in Specific — then ask it to create the records, handle duplicates, and write back the results. You can also see how this works for bulk-importing company records or enriching existing contacts with custom attributes.