TL;DR: To build a CRM in Notion, create two separate databases for “Clients” and “Deals,” then link them using a bidirectional relation property. This setup allows you to view all associated transactions for each client directly within their record, streamlining your sales tracking workflow.
Step 1: Create the Core Databases
Begin by creating a new page in your workspace. Inside this page, create your first database named “Clients.” This database will hold your primary contact information. Add properties for “Name,” “Company,” “Email,” and “Phone Number.” Next, create a second database on the same page or in a linked view named “Deals.” For the Deals database, add properties for “Deal Name,” “Value,” “Status,” and “Close Date.” Keeping these entities separate is crucial for maintaining data integrity and scalability.
If you want to dig deeper, check out our guide on 7 Profitable Shopify Store Niches for Dropshipping.
Step 2: Establish the Relation
Now, you need to connect these two databases. Go to the “Deals” database and add a new property. Select “Relation” as the property type. Choose the “Clients” database from the dropdown menu. Notion will automatically create a matching relation property in the “Clients” database. This bidirectional link allows you to see which deals belong to a specific client and, conversely, which clients have active deals. Ensure you set the relation to be “bidirectional” if you want to see the connection in both databases simultaneously.
Step 3: Customize Views for Efficiency
With the databases linked, customize your views to suit your workflow. In the “Clients” database, create a “Table” view to list all your contacts. In the “Deals” database, create a “Kanban” board grouped by “Status” to visualize your sales pipeline. You can also add a “Gallery” view for Clients if you want to see more detailed profile information, including the linked deals directly on the card. Use filters to hide closed deals from your main Kanban view to keep your active pipeline clear.
Pro Tips for Success
Utilize rollup properties to automate calculations. For example, in the “Clients” database, add a rollup property that sums the “Value” of all linked “Deals.” This gives you an immediate view of the total revenue potential per client without manual calculation. Additionally, use formulas to calculate margins or projected revenue based on deal value. Keep your property names consistent across both databases to avoid confusion when linking records. Regularly audit your linked records to ensure no orphaned data exists, which can happen if you delete a client without checking their associated deals first.
FAQ
Q: Can I link more than two databases together?
A: Yes, Notion allows you to link multiple databases to a central hub, though direct multi-database relations are limited. You can use a central “Hub” database or link via a common ID property to connect three or more distinct entities.
Q: What happens if I delete a linked record?
A: When you delete a record in one database, the link in the related database becomes empty. The related record is not deleted unless it is also manually removed. You should verify dependencies before deleting critical client or deal records to avoid losing connection history.
Q: Is there a limit to the number of linked records?
A: Notion does not impose a strict low limit on the number of linked records per cell. However, performance may degrade if a single record links to thousands of others. It is best to maintain a reasonable number of active links per view to ensure smooth loading times.
Leave a Reply