# CRM

> Part of the NocoDB documentation (Product docs > Sync > App Sync). Index of all pages: https://nocodb.com/llms.txt. Any docs page is available as Markdown by adding `.md` to its URL.

URL: https://nocodb.com/docs/product/sync/app-sync/crm
Last updated: 2026-10-03

Bring customer and contact data from your CRM into NocoDB with automatic syncs.

Use CRM Sync to import accounts, contacts, and owner information from your CRM platform. It follows a predefined schema that makes CRM data the same across systems. Use it to keep account reports in one place, segment contacts, and build sales dashboards together with the rest of your workspace.

Current supported sources include:

* HubSpot

All three CRM tables are essential, and App Sync always includes them. App Sync makes the relationships between accounts, contacts, and users automatically.

## Available Tables

Each table maps to a well-defined set of fields, so the structure stays the same. App Sync also includes relational fields that connect these tables as necessary.

### **CRM\_Account**

Represents companies and organizations tracked in the CRM.
**Key fields include:**

| Field                         | Description                             |
| ----------------------------- | --------------------------------------- |
| **Name**                      | The account or company name.            |
| **Description**               | A summary of the account.               |
| **Industry**                  | The industry classification.            |
| **Website**                   | The website of the company.             |
| **Number Of Employees**       | The company size.                       |
| **Addresses / Phone Numbers** | The contact details on record.          |
| **Remote Fields**             | Provider-specific fields, kept as JSON. |

Each account links to its **Contacts** and to the **User** who owns the account.

### **CRM\_Contact**

Represents individual people tracked in the CRM.
**Key fields include:**

| Field                                           | Description                                  |
| ----------------------------------------------- | -------------------------------------------- |
| **First Name / Last Name**                      | The name of the contact.                     |
| **Email Addresses / Phone Numbers / Addresses** | The contact details.                         |
| **Last Activity At**                            | When the contact was last active in the CRM. |
| **Remote Fields**                               | Provider-specific fields, kept as JSON.      |

Each contact links to its **Account** and to the **User** who owns the relationship.

### **CRM\_User**

Represents CRM users, such as account owners and sales reps.
**Key fields include:**

| Field             | Description                                       |
| ----------------- | ------------------------------------------------- |
| **Name**          | The name of the user.                             |
| **Email**         | The email address of the user.                    |
| **Is Active**     | Shows if the user is currently active in the CRM. |
| **Remote Fields** | Provider-specific fields, kept as JSON.           |

Each user links to the **Accounts** and **Contacts** that the user owns.

## Metadata Fields

Each synced table in the CRM category includes a set of metadata fields. These fields track the lifecycle, state, and origin of each record. They show how data flows from the external source into NocoDB. They are important for traceability, debugging, and audit requirements.

App Sync manages these metadata fields automatically. They are read-only.

| Field                 | Description                                                                                                                          |
| --------------------- | ------------------------------------------------------------------------------------------------------------------------------------ |
| **RemoteId**          | The unique identifier of the record in the external source system.                                                                   |
| **RemoteCreatedAt**   | The timestamp when the record was first created in the source.                                                                       |
| **RemoteUpdatedAt**   | The timestamp of the most recent update in the source.                                                                               |
| **RemoteDeleted**     | Shows if the record was deleted in the source platform. App Sync uses this especially when the delete behavior is set to **Ignore**. |
| **RemoteDeletedTime** | The timestamp when the record was deleted in the source, if applicable.                                                              |
| **RemoteRaw**         | The raw payload from the provider for that record. Use it for troubleshooting, verification, or advanced integrations.               |
| **RemoteNamespace**   | The origin portal or account in the CRM platform.                                                                                    |
| **RemoteSyncedAt**    | The last timestamp when NocoDB synced this record.                                                                                   |
| **SyncConfigId**      | An internal reference to the sync configuration for this record.                                                                     |
| **SyncRunId**         | The sync run that last updated this record.                                                                                          |
| **SyncProvider**      | The external service (such as HubSpot) that the record came from.                                                                    |

## Availability

* App Sync is available on **NocoDB Cloud** (Plus plan and above) and licensed self-hosted deployments (Business plan and above).

---

## Related pages

- [Ticketing](https://nocodb.com/docs/product/sync/app-sync/ticketing.md): Ticketing Sync in NocoDB App Sync imports tickets, comments, users and teams from external ticketing platforms on an automatic schedule.
- [HRIS](https://nocodb.com/docs/product/sync/app-sync/hris.md): Bring employee data from your HR system into NocoDB with automatic syncs.
- [File Storage](https://nocodb.com/docs/product/sync/app-sync/file-storage.md): Bring file and folder metadata from cloud storage platforms into NocoDB with automatic syncs.
- [Calendar](https://nocodb.com/docs/product/sync/app-sync/calendar.md): Bring your calendar events into NocoDB with automatic syncs from Google Calendar, Outlook Calendar, and CalDAV.
- [Custom Sync](https://nocodb.com/docs/product/sync/app-sync/custom.md): Mirror tables from PostgreSQL, MySQL, or SQL Server databases into NocoDB as read-only synced tables.
