The Scenario
The coaching business you took over from a previous owner has been tracking prospects in a spreadsheet for three years. Five hundred rows. Name, Email, Phone, Status, Notes — the notes are the important part, because they document where each conversation left off. You switched to PageX six weeks ago and the CRM is still empty because nobody has had time to move the legacy list over.
Every week the sales team asks if the old leads are in PageX yet. Every week the answer is "we're working on it."
The bad version:
- You open the legacy sheet, start at row 1, open a new PageX contact form, and type in the name, the email, the phone. Then you look at the Status column: "Interested — follow up Q3." That maps to one of four pipeline stages in PageX but you're not sure which one, so you make a judgment call and move on.
- The Notes column is the biggest problem. Each cell is a paragraph. You have to read it, decide whether it belongs in the PageX contact description field or as a CRM activity note, and then manually paste it into the right place.
- By row 30 you've made three different decisions about where to put notes and the data is already inconsistent.
You did not inherit this business to spend November doing data entry. The old leads are supposed to become revenue.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the legacy spreadsheet, understands the column structure, and through its built-in PageX integration it migrates every prospect into PageX CRM as a new lead — status, notes, and all.
Here is the prompt for this task:
Migrate all 500 prospect rows from the Prospects tab into PageX CRM as leads — map the Status column to the lead stage and the Notes column to the lead description field — write the migration result to column F
What You Get
- A PageX CRM lead created for each row, with name, email, phone, lead stage, and description populated from the sheet columns.
- Column F updated with the result per row: "Migrated," "Skipped (no email)," or the error detail if PageX rejected a record.
- Status values that don't match a known PageX pipeline stage are flagged in column F rather than silently dropped or mapped to the wrong stage.
- The full 500-record migration completes in one operation, not 500 separate form submissions.
What If the Data Is Not Quite Ready
The Status column uses values that don't match PageX's pipeline stage names
Your legacy sheet has statuses like "Hot," "Warm," "Cold," and "Dead" — but PageX uses "New Lead," "Contacted," "Qualified," and "Closed Lost."
Map the Status column values to PageX pipeline stages before migrating — "Hot" → "Qualified," "Warm" → "Contacted," "Cold" → "New Lead," "Dead" → "Closed Lost" — then migrate all rows from the Prospects tab and log the result in column F
Some rows have no email address (the old owner didn't always collect them)
About 60 of the 500 rows are missing an Email value, and PageX requires it to create a contact.
Migrate all rows from the Prospects tab that have a non-empty Email column into PageX CRM — skip rows with blank emails and write "Skipped (no email)" to column F for those rows — log "Migrated" for every successful record
Notes need to be cleaned up before they land in PageX
Some notes cells contain internal shorthand, abbreviations, or references that made sense to the previous owner but will confuse the sales team now.
For every row in the Prospects tab, rewrite the Notes column content into clear professional sentences before migrating to PageX CRM — then create a lead for each row mapping Status to lead stage and the cleaned note to the description field — log the result in column F
The full migration: status mapping, email filter, note cleanup, and push in one batch
The list is three years old, the statuses are nonstandard, some emails are missing, and the notes are a mix of shorthand and full sentences.
Filter the Prospects tab to rows with a non-empty Email, map Status values to PageX pipeline stages (Hot→Qualified, Warm→Contacted, Cold→New Lead, Dead→Closed Lost), rewrite the Notes column into clear sentences, then migrate all qualifying rows to PageX CRM and write the result to column F
Everything — the filter, the mapping, the cleanup, the push — in a single instruction.
Try It
Open your legacy prospect spreadsheet and get the 7-day free trial of SheetXAI. Ask it to migrate the full list to PageX CRM with status mapping and note cleanup included. Also see: Bulk Push Leads From a Google Sheet Into PageX CRM and the PageX integration overview.