> ## Documentation Index
> Fetch the complete documentation index at: https://docs.getoneprofile.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Push leads to your CRM

> Connect your CRM, add an export column, and write finished rows back as new records or updates to existing ones.

Work that stays in Oneprofile helps nobody. This guide connects a CRM and pushes a finished table into it.

<video alt="A screen recording of a CRM export: a connection is made once in Settings, an export column is added to a table, an action is chosen that decides whether records are created or updated, and the column waits to be run." controls className="w-full aspect-video rounded-xl" poster="https://static.getoneprofile.ai/docs/videos/push-leads-to-your-crm/poster-3af57454.jpg" crossOrigin="anonymous">
  <source src="https://static.getoneprofile.ai/docs/videos/push-leads-to-your-crm/push-leads-to-your-crm-a9585564.mp4" type="video/mp4" />

  <track kind="captions" src="https://static.getoneprofile.ai/docs/videos/push-leads-to-your-crm/push-leads-to-your-crm-d3ee5784.vtt" srcLang="en" label="English" default />
</video>

*2:00 video, recorded August 2026. The app moves fast, and the steps below stay current.*

## What you'll learn

* **Connecting a tool**: authorize your CRM once and reuse it everywhere.
* **Write modes**: create new records, update existing ones, or do both in one column.
* **Match fields**: tell Oneprofile how to recognise a record it has seen before.

## Before you start

You need a table whose rows are ready to leave, and permission to connect your CRM. Enrich the columns you want to send first, because an export writes what is there when it runs.

## Connect your CRM

<Steps>
  <Step title="Open Connections">
    Go to **Settings**, then **Connections**, then click **Add integration**.
  </Step>

  <Step title="Pick your CRM">
    Find it with **Search integrations** and open it.
  </Step>

  <Step title="Authorize it">
    Choose **Connect with one click** where it is offered, or **Connect with an API key**.
  </Step>
</Steps>

## Add the export column

<Steps>
  <Step title="Open the catalog">
    On your table, click **Add column**, then choose **Import & export** and pick your CRM.
  </Step>

  <Step title="Choose the action">
    Pick **Create or update records** so a row updates a match and creates one when there is none.
  </Step>

  <Step title="Pick the object">
    Set **Destination object** to what you are writing, such as a contact or a company.
  </Step>

  <Step title="Set the match field">
    Use **Match records on** to choose what identifies a record. An email address is the usual answer.
  </Step>

  <Step title="Decide what an update overwrites">
    Under **When a record matches**, set **Write mode**. **Fill empty fields only** leaves existing values alone; **Change mapped fields only** replaces the fields you mapped.
  </Step>

  <Step title="Map your columns">
    Under **Destination fields**, point each field at the column that fills it.
  </Step>
</Steps>

<Warning>
  An export writes to a live system. Use **Test on these rows** on a handful of rows before you push the table.
</Warning>

## Good to know

<AccordionGroup>
  <Accordion title="Will this overwrite what my CRM already has?">
    That depends on **Write mode**, which is a separate control from the action you picked first. It sits under **When a record matches**.
  </Accordion>

  <Accordion title="Does the export run on its own?">
    Only if you turn auto-run on for the column. Otherwise it runs when you run it.
  </Accordion>

  <Accordion title="What happens to a field my CRM will not accept?">
    Fields marked **Read only** by the CRM cannot be written and are not offered in the mapping.
  </Accordion>

  <Accordion title="What if a row fails?">
    The cell shows the error and the row is not written. Fix the cause, then use **Retry failed rows**.
  </Accordion>
</AccordionGroup>

## Next steps

<CardGroup cols={2}>
  <Card title="Export to a tool" icon="upload" href="/tables/columns/export-to-a-tool">
    Every write mode and setting, in full.
  </Card>

  <Card title="Connect a tool" icon="plug" href="/integrations/connect-a-tool">
    Connecting, reconnecting, and where connections live.
  </Card>

  <Card title="Look up your own data" icon="database" href="/integrations/look-up-your-own-data">
    Read your CRM into a column before you write to it.
  </Card>

  <Card title="Run columns" icon="play" href="/tables/run-columns">
    Decide when the export column runs.
  </Card>
</CardGroup>