The Scenario
The customer success team at a 50-person SaaS company just closed a cohort of 300 new clients. Every contact — name, email, phone, company — is sitting in the 'New Clients' worksheet of the onboarding tracker. Onboarding kicks off Monday. It's Thursday afternoon.
You need all 300 people in Missive's contact book before the team starts sending welcome emails. What you're tempted to do is open Missive and start creating contacts one at a time.
The bad version:
- Open Missive, click New Contact, paste first name from row 2, worksheet to last name, paste, worksheet to email, paste, worksheet to phone — realize you copied the wrong cell — undo, paste again, save.
- Repeat for rows 3 through 302, keeping track of where you left off after every interruption.
- Discover on row 180 that your column order is wrong and you've been pasting company names into the phone field for the last 40 rows.
You were hired to run onboarding, not transcribe spreadsheets. The launch window is Monday and this is not a task that scales to the number of rows in front of you.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your contact data and talks to Missive directly — creating all 300 contacts in one pass without you touching the Missive UI once.
Import all contacts from the 'New Clients' sheet (columns: A = first name, B = last name, C = email, D = phone, E = company) into our Missive contact book
What You Get
- 300 Missive contacts created, each with first name, last name, email, phone, and organization populated from the corresponding columns.
- A summary written back to the sheet — rows that succeeded, rows that were skipped, and the specific reason for each skip (missing email, duplicate, malformed phone number).
- No manual UI clicks. No mid-task column mix-ups.
What If the Data Is Not Quite Ready
Phone numbers have mixed formats — some are +1-555-123-4567, some are 5551234567
Before importing contacts from 'New Clients', normalize all phone numbers in column D to E.164 format (+1XXXXXXXXXX), then import into Missive with first name in A, last name in B, email in C, phone in D, company in E
Some rows are missing an email address
Import contacts from 'New Clients' into Missive — skip any row where column C (email) is blank and write the skipped rows with their row numbers into a new worksheet called 'Missing Email' so I can follow up
Company names in column E need to be matched against a canonical list in a second worksheet
Import contacts from 'New Clients' into Missive. Before creating each contact, look up the company name in column E against the 'Company Canonical' worksheet (column A = raw name, column B = canonical name) and use the canonical version in the organization field
Clean, deduplicate, and import in one shot
In the 'New Clients' worksheet: normalize phone numbers in column D to +1XXXXXXXXXX, remove any duplicate rows where column C (email) appears more than once, skip rows with a blank email, then import all remaining rows into Missive as contacts with first name, last name, email, phone, and organization — write a results summary to a new worksheet called 'Import Log'
The pattern here: describe the cleanup and the action together. SheetXAI handles both in the same prompt so you're not running three separate passes.
Try It
Open your client roster in Excel workbooks and get the 7-day free trial of SheetXAI. Ask it to import your contacts into Missive — specify your columns and let it handle the rest. You can also check out the spoke on exporting Missive contacts to a sheet for the reverse direction, or the hub overview for the full list of Missive tasks SheetXAI handles.