How to Import Salesforce Data into Notion

Looking for an easy way to import Salesforce data to Notion? Whether you need to track contacts, manage deals, or analyze customer insights, a Notion Salesforce integration can help streamline your workflow.

With Note API Connector, you can seamlessly connect Salesforce’s API and import data into Notion—without coding. This guide will walk you through the process step by step, from generating a Salesforce credentials to setting up API requests that sync Salesforce data with Notion.

Getting started with Note API Connector

You can get started in just a few clicks:

Simply authenticate your Notion account, grant the necessary permissions, and start creating API requests effortlessly.

👉 Follow the official setup guide for step-by-step instructions.

Generate Salesforce OAuth Credentials

To securely import Salesforce data into Notion, you must first create a Connected App in Salesforce and obtain an Client ID and Client Secret credentials.

Log in to Salesforce and in left panel open Apps → App Manager.

Salesforce App Manager

Click New Connected App.

Salesforce New Connected App

Select Create a Connected App and confirm.

Salesforce Create Connected App

Name your app (for example, "Notion") and add your contact email.

Salesforce App Name

Now, scroll down and enable Enable Oauth Settings. Add https://api.noteapiconnector.com/oauth/callback as Callback URL.

Add Full access (full) and Perform requests at any time (refresh_token, offline_access) into Selected Auth Scopes.

Enable:

  • Require Secret for Weh Server Flown
  • Require Secret for Refresh Token Flown
  • Enable Authorization Code and Credentials Flow

Salesforce OAuth Settings

Go back to App Manager in Salesforce and click Manage for our created app.

Salesforce App Manage

Enter Edit Policies.

Salesforce Edit Policies

Select All users may self-authorize in Permitted Users and Relax IP restrictions in IP Relaxation. Change the value for Expire refresh token if not used for to 30 or whatever number. Then click Save.

Salesforce OAuth Policies

Import Salesforce Data into Notion

Before making API requests, review Salesforce’s API documentation to see how it works: Execute a SOQL Query.

You can import Salesforce data by running SOQL queries, where query is defined in url parameter such as:

https://MyDomainName.my.salesforce.com/services/data/v57.0/query/?q=SELECT Id,FirstName,LastName FROM Lead

Connect Salesforce to Note API Connector

First, you need to create OAuth Connection between Salesforce and Note API Connector. Click Create request and select Authorization → OAuth → New.

Notion Add OAuth

Then, in the modal dialog add:

  • Name, e.g. Salesforce Connection
  • Authorization Base URLhttps://login.salesforce.com/services/oauth2/authorize
  • Token URLhttps://login.salesforce.com/services/oauth2/token
  • Scopesfull refresh_token
Notion Salesforce OAuth Params

You need to go back to Salesforce to get Client ID and Client Secret parameters.

Salesforce App View

Enter Manage Consumer Details.

Salesforce Consumer Details

You can see Consumer Key and copy paste it to Client ID and Consumer Secret into Consumer Secret.

Salesforce Client ID Notion Salesforce Client ID

Then, you just need to confirm the connection between Salesforce and Note API Connector in a popup window. Then, you can see the success status for OAuth connection in Note API Connector.

Notion Salesforce OAuth Status

Create a Notion Database where Salesforce data will be imported.

Notion Salesforce Database

Name your request (e.g., Salesforce Contacts). Select the Notion database where you want to import the data.

Add the url with SOQL query into URL field. Then, click Run to call API request.

https://martinros-dev-ed.my.salesforce.com/services/data/v57.0/query/?q=SELECT Id,FirstName,LastName FROM Lead
Notion Salesforce SOQL

Review the fetched Salesforce leads in the Response Field Mapping view.

Salesforce Notion Response View

Click Save & Import to store the data in your Notion database.

Notion Salesforce Imported Data

Automate Data Updates in Notion

Manually refreshing your Salesforce data in Notion can be a time-consuming, especially when tracking contacts, deals, and marketing campaign metrics. With Note API Connector’s scheduling feature, you can automate data updates, ensuring your Notion dashboard always reflects the latest Salesforce information—without lifting a finger. Set it to refresh hourly, daily, or at custom intervals, so you never have to worry about outdated data again. Whether you're monitoring sales pipelines, tracking lead engagement, or analyzing customer relationships, automated synchronization lets you focus on strategy while your data stays current.

Automate Data Updates

Conclusion

With Note API Connector, importing Salesforce data into Notion is seamless and efficient. This Notion Salesforce integration centralizes your valuable CRM information in one collaborative workspace, making it easier for teams to access and utilize customer data.

Whether you're tracking contacts, monitoring deals, or analyzing marketing performance, connecting Salesforce to Notion eliminates data silos and improves team productivity. The ability to create custom views, filters, and dashboards in Notion transforms your Salesforce data into actionable insights.

🚀 Start streamlining your workflow today. Try Note API Connector and seamlessly import Salesforce data to Notion to create a unified hub for your customer information.

Frequently asked questions