2sync

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

  1. Both databases connected to 2sync: The main database AND the related database must have 2sync access
  2. Relation property exists: Create a Relation property in Notion pointing to the target database
  3. Matching identifiers: Data must match between sources (e.g., email addresses)

Common relation types

Attendees → contacts

Map calendar attendees to a Contacts database:

  1. Create a Contacts database connected to 2sync
  2. Add a Relation property in your events database → Contacts
  3. Map Attendees (Relation) to this Relation property
  4. 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:

  1. Create a Projects database connected to 2sync
  2. Add a Relation property in tasks → Projects
  3. Map Project (Relation) to this property
  4. Tasks link to project pages

Result: Project pages show all related tasks via backlinks.

Calendar → calendars database

Map calendar names to a Calendars database:

  1. Create a Calendars database with entries for each calendar
  2. Add a Relation property in events → Calendars
  3. Map Calendar Name (Relation) to this property
  4. 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 caseUse relationUse 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:

  1. Check spelling and case of project/section names
  2. Ensure target pages exist in the related database
  3. 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:

  1. Sync contacts to a Contacts database
  2. Sync emails with From (Relation) mapped
  3. 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:

  1. Map Thread (Relation) to a self-relation (same database)
  2. Or create a Threads database for thread metadata

Calendar relations

Multiple calendars

When syncing multiple calendars:

  1. Map Calendar Name (Relation) to a Calendars database
  2. Each event links to its source calendar
  3. 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

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.