Map a contact export to CRM fields

What this template does

Map full_name to name, email_address to normalized email, organization to company and record_id to source_id. Missing required values are rejected, and the output explicitly disables CRM writing.

Prepare these inputs

A known export schema using those exact field names. Update the mapping only after checking the destination CRM field definitions.

Field map: full_name, email_address, organization, record_id

From input to reviewable output.

Use the synthetic example or edit its JSON structure. This demo sends no input to an AI service or our server. Keep real personal data in your approved environment. Up to 1,000 records and 100 KB of JSON.

Ready. Run the sample to inspect the result.

Use the starter in n8n

1. Download the JSON and import it using n8n’s import-from-file option. Keep it unpublished.
2. Inspect the three nodes: Manual start → Sample input → Reviewable output. Run it manually with the synthetic example.
3. Compare records, rejected and the counts with the demo here. The output is one item containing an envelope; split the records array if a later node expects individual items.
4. Replace Sample input with an approved source only after mapping its data to the same single-item JSON structure shown above. Supply an explicit as_of where required.
5. Add a separate review or approval step before any external write. Test credentials and permissions in your own environment, then decide whether a schedule is appropriate.

The download has no live connector, schedule, credential or external request. Connecting a mailbox, CRM, spreadsheet or notification destination is a separate setup and test.

SHA-256: f7e6b444664978d72cb9a245a1c1d24a9772efa7b5b263bc9d5e1edd75648a19

Limits and review points

This mapping does not create contacts, check duplicates in a live CRM or validate consent. Review a small export before connecting any write node.

Rejected rows are returned with their one-based input position and a reason. Review them before using the result; an empty output can be a valid outcome. Unknown or malformed top-level inputs produce an error instead of a guessed result. Keep an untouched input export for reconciliation.

Run costs and data handling

The browser step has no service fee, API call or account requirement. It uses no browser storage for your input. Ordinary website access logs still apply. Downloaded results are saved only when you request them. Your own n8n hosting, cloud plan and any later connected service may have charges; no paid AI model is required by this starter.