Relations & database linking
Link synced items to other Notion databases
2sync can map external data to Notion Relations, enabling powerful connections between your synced items and other databases. Link calendar attendees to contacts, tasks to projects, or emails to CRM records.
What is relation mapping?
Relations in Notion link pages across databases. 2sync extends this by automatically creating relations based on synced data.
Without relations:
- Calendar event shows "john@example.com" as text
- No connection to your contacts database
With relations:
- Calendar event links to John Doe's page in Contacts
- Click through to see all interactions with John
- Use rollups to count meetings per contact
How do I set up relations?
Prerequisites
- Both databases connected to 2sync: The main database AND the related database must have 2sync access
- Relation property exists: Create a Relation property in Notion pointing to the target database
- Matching identifiers: Data must match between sources (e.g., email addresses)
Common relation types
Attendees → contacts
Map calendar attendees to a Contacts database:
- Create a Contacts database connected to 2sync
- Add a Relation property in your events database → Contacts
- Map Attendees (Relation) to this Relation property
- 2sync matches attendee emails to contact records
Result: Click an attendee to see their contact page. Use rollups to count meetings.
Once relations are set up, use Notion rollups to aggregate data across databases. For example, add a rollup on your Contacts database to count the number of meetings per contact, or sum hours per project.
Project → projects database
Map Todoist projects to a Notion Projects database:
- Create a Projects database connected to 2sync
- Add a Relation property in tasks → Projects
- Map Project (Relation) to this property
- Tasks link to project pages
Result: Project pages show all related tasks via backlinks.
Calendar → calendars database
Map calendar names to a Calendars database:
- Create a Calendars database with entries for each calendar
- Add a Relation property in events → Calendars
- Map Calendar Name (Relation) to this property
- Events link to their calendar page
Result: Filter and organize by calendar with rich calendar metadata.
When should I use relations instead of select?
| Use case | Use relation | Use select |
|---|---|---|
| Need to store additional info about the linked item | ✓ | |
| Want rollups (count, sum, etc.) | ✓ | |
| Simple categorization | ✓ | |
| Minimal setup | ✓ | |
| Dynamic values that may change | ✓ | |
| Fixed, predefined options | ✓ |
How do I troubleshoot relation issues?
"Can't create a relation" error
Cause: The target database isn't connected to 2sync.
Fix: Open the target database in Notion, click (•••) > Add connections > 2sync.
Relations not linking
Causes:
- Names don't match exactly (case-sensitive)
- Target page doesn't exist yet
- Permission issues
Fixes:
- Check spelling and case of project/section names
- Ensure target pages exist in the related database
- Verify 2sync has access to both databases
Empty relation field
Cause: The linked value doesn't exist in the target database.
Example: Task has Project "Marketing," but no "Marketing" page exists in Projects database.
Fix: Create the missing page in the target database, or let 2sync create it automatically (for supported relations).
How does automatic entry creation work?
For some relations, 2sync can create entries automatically:
Projects and Sections (Todoist):
- When a task syncs with a new project name
- 2sync creates a corresponding page in the Projects database
- Future tasks link to that page
Requirements:
- Target database must be connected to 2sync
- Relation must be properly mapped
Automatic entry creation only works for specific relation types like Todoist Projects and Sections. For other relations (such as attendees to contacts), the target page must already exist in the related database.
Email sender → CRM
For a full walkthrough on building a Notion CRM with synced contacts, see Create a Notion CRM.
Link Gmail/Outlook emails to a CRM or Contacts database:
- Sync contacts to a Contacts database
- Sync emails with From (Relation) mapped
- Emails automatically link to sender's contact page
Result: Open a contact to see all email correspondence.
Thread relations (email)
Group email threads using relations:
- Thread (Relation): Link emails in the same conversation
- Navigate through email threads in Notion
- See the full conversation history
Setup:
- Map Thread (Relation) to a self-relation (same database)
- Or create a Threads database for thread metadata
Calendar relations
Multiple calendars
When syncing multiple calendars:
- Map Calendar Name (Relation) to a Calendars database
- Each event links to its source calendar
- Filter views by calendar relation
Attendees across databases
Link event attendees to:
- Contacts database: Full contact info
- Team directory: Internal team members
- CRM records: External contacts
What are the best practices for relations?
Keep names consistent
Relations match by name. Ensure:
- Project names in Todoist match entries in Projects database
- Calendar names match entries in Calendars database
- Contact emails match between sources
Connect databases first
Before mapping relations, ensure both databases are connected to 2sync. Missing connections are the most common cause of relation failures.
Use self-relations carefully
Self-relations (database relates to itself) work for:
- Parent/child tasks
- Email threads
- Subtask hierarchies
But can create complex setups. Start simple.
Monitor sync status
Map Sync Status to catch relation issues. See Sync item statuses for a full list of states:
- Items failing to link show different statuses
- Helps diagnose problems early
Related
- Notion property types for understanding which property types support relations
- Create a Notion CRM for a step-by-step guide to building a CRM with relations
- Google Contacts fields for fields available when mapping contacts
- Outlook Contacts fields for Outlook-specific contact fields
- How sync works for understanding how relation matching is processed
FAQ
Why can't I create a relation to my database?
The target database must be connected to 2sync. Add the 2sync connection via (•••) > Add connections > 2sync on the database page.
Do relations work with formulas and rollups?
Yes. Once relations are set up, you can use rollups to aggregate data (count tasks per project, sum hours per contact, etc.).
What if the related page doesn't exist?
For some relation types (like Projects), 2sync can create the page automatically. For others, you need to create the target page first.
Are relations bidirectional?
Notion relations are inherently bidirectional. When A links to B, B also shows a backlink to A. 2sync creates the initial link; Notion handles the reverse.
Can I use multiple relation fields?
Yes. You can map different external fields to different relations. For example, map both Project and Section to separate relation properties.