How to Build Notion Import From Salesforce Object With Field Mapping

You have Salesforce data in an object like Accounts or Contacts and need to bring it into Notion without losing the relationship between columns. Notion offers a native import tool that reads Salesforce objects and lets you map each Salesforce field to a Notion property. This article explains how to connect Notion to Salesforce, select the object you want to import, and define the field mapping so the data lands in the correct columns. You will also learn how to handle common mapping mismatches and what to do when the import fails to preserve certain field types.

How Notion Handles Salesforce Object Imports

Notion uses a connector that connects to Salesforce through OAuth 2.0. Once authorized, Notion can read the metadata of any standard or custom object in your Salesforce instance. The import process does not pull all records at once. It pulls a sample of up to 500 records during the mapping phase so you can verify the data layout before committing the full import.

The mapping step is where you decide which Salesforce field goes into which Notion property. Notion reads the field type from Salesforce (text, number, date, picklist, checkbox, etc.) and suggests a matching Notion property type. You can override the suggestion by choosing a different property type, but some conversions will cause data loss. For example, mapping a Salesforce date field to a Notion text property will convert the date to a plain string, losing the ability to sort or filter by date.

Notion supports importing from the following Salesforce object types: Account, Contact, Lead, Opportunity, Case, Task, Event, and any custom object that appears in the Salesforce object list. The connector also reads formula fields, but those values are computed at the time of import and will not update later.

Steps to Import a Salesforce Object With Field Mapping

Before you begin, make sure you have a Notion workspace where you are an admin or have the ability to add connections. You also need a Salesforce account with read access to the object you want to import.

1. Open Notion and go to Settings & Members
   Click the sidebar arrow icon and select Settings & Members. Then click Connections in the left menu.
2. Add the Salesforce connection
   Click Add or Manage next to Salesforce. A new browser tab opens asking you to log in to Salesforce. Grant Notion permission to read your Salesforce data. After authorization, you return to Notion.
3. Create a new page or open an existing database
   You can import into a brand new page by clicking the + icon in the sidebar and selecting Database. Or open an existing database where you want the records to appear.
4. Select Import from the database menu
   Click the three-dot menu at the top-right of the database view. Choose Import. From the list of import sources, select Salesforce.
5. Choose the Salesforce object
   A dropdown shows all objects available in your Salesforce instance. Select the object you want to import, for example Account or Contact. Notion loads a preview of up to 500 sample records.
6. Map the fields
   For each Salesforce field listed, click the dropdown in the Notion property column and select an existing property or type a new property name to create one. If the field type does not match, Notion shows a warning icon. Click the warning to see the recommended type. Adjust the mapping until all warnings are resolved.
7. Start the import
   After mapping all fields you want to include, click Import. Notion pulls the records into the database. The import runs in the background. A notification appears when the import is complete.
8. Verify the data
   Open the database and check a few records. Confirm that text, numbers, dates, and picklist values appear in the correct columns. If a field shows an error or empty value, return to the mapping step and adjust the property type.

Common Mapping Problems and How to Fix Them

Salesforce Picklist Values Appear as Plain Text

Notion does not support a native picklist property type. When you map a Salesforce picklist field, Notion converts it to a Select or Multi-Select property depending on whether the picklist allows multiple selections. If the mapping shows a text property instead, manually change it to Select in the field mapping dropdown.

Formula Fields Show #Error or Empty

Salesforce formula fields are computed on the server. Notion can read the computed value only if the formula references fields that are also included in the import. If a formula field depends on a related object field that is not imported, Notion returns an empty value. Include all referenced fields in the mapping to fix this.

Date Fields Import as Text Instead of Date Type

This happens when the Salesforce date field has a format that Notion does not recognize. In the mapping dropdown, manually select the Date property type. If the date format still does not parse correctly, reformat the date in Salesforce before importing. Notion expects ISO 8601 format (YYYY-MM-DD) for date fields.

Import Stops at 500 Records

The preview step shows only 500 sample records, but the full import should pull all records from the object. If the import stops at exactly 500 records, the Salesforce API limit may be blocking the request. Run the import again after 24 hours, or reduce the number of fields mapped to lower the API call size.

Notion Import Methods Compared

Item	Native Salesforce Import	CSV Export + Import
Connection setup	OAuth 2.0, no file handling	Requires Salesforce export to CSV
Field mapping	Automatic type detection with manual override	Manual column-to-property mapping in Notion import dialog
Record limit	Up to 5000 records per import	Limited by CSV file size (Notion accepts up to 5 MB)
Data freshness	Snapshot at time of import, no live sync	Snapshot at time of CSV export, no live sync
Formula fields	Reads computed value if dependencies are included	Only static values from CSV, formulas are not computed

Now you can import Salesforce objects into Notion with field mapping that preserves the data structure. Start by connecting Notion to Salesforce through Settings & Members. Then select the object and map each field to the correct Notion property. If a field type mismatch occurs, adjust the property type in the mapping dropdown. For large imports, run the process during off-peak hours to avoid Salesforce API limits.