The Scenario
Your revenue ops team is onboarding a 40-person sales team onto Specific, and you have a Salesforce export sitting in Google Sheets — 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 the CSV, and discover that the "company name" field needs to match an existing Specific company record — not a string. You go back to the sheet 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 Google Sheet. It reads your sheet, 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.
Create a Specific contact for each row in this sheet using email (column A), first name (column B), last name (column C), and company name (column D) — write 'created' or the error into column E
What You Get
- A new contact record in Specific for each row processed successfully.
- Column E populated with 'created' for each success, or the specific API error message for each failure — so you know exactly which rows need follow-up without re-running anything.
- Company associations matched by name against existing Specific company records where they exist.
- A completed import across all 600 rows without leaving the sheet.
What If the Data Is Not Quite Ready
The company name doesn't match any Specific company record
Create a Specific contact for each row in this sheet using email (A), first name (B), last name (C), and company name (D) — if the company doesn't exist in Specific, create the company first, then associate the contact to it — write the contact ID and company ID into columns E and F
The sheet has duplicate emails across rows
Before importing, check column A for duplicate email addresses — 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 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 through the data.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet 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.