CSV preflight check (detect only)
preflight_csvChecks a contact or lead CSV (passed as text, up to 500 data rows and 64 KiB) before a CRM import and reports what it finds: duplicate emails (matched ignoring case and surrounding spaces), invalid email syntax, role or shared inboxes (info@, sales@ and similar), blank required fields (placeholders like N/A, null and - count as blank), phone numbers not written as + country code and digits only (with a suggested form when the fix is mechanical), country and state spelling drift, mixed or ambiguous date formats, and file problems (garbled characters, ragged rows, formula-like cells, stray spaces, header issues). Detection only: it changes nothing, returns no cleaned file, and does not store or log your CSV. Pattern-based; it does not check that mailboxes exist. Same checks as the free Sales List Rescue CSV preflight checker on pureservices.store.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| csv | Yes | The full CSV text including the header row. Comma, semicolon, tab or pipe delimited (auto-detected). | |
| email_column | No | Header name of the email column. Optional; auto-detected when omitted. | |
| phone_column | No | Header name of the phone column. Optional; auto-detected when omitted. | |
| required_columns | No | Header names that must not be blank. Optional; defaults to the detected email, first name, last name and company columns. | |
| default_country_code | No | Calling code assumed for phone numbers without a + prefix: 1 (US/Canada), 44, 61, 49, 33, 91, or "" for no default. | 1 |