Skip to content

Notion Database Properties Not Extracted as Structured Metadata When Synced #695

@Amama-Fatima

Description

@Amama-Fatima

Notion database properties are currently converted to markdown tables in document content but are not available as structured metadata fields for filtering and querying.

Expected Behavior

According to Notion connector documentation:

Database Properties
Notion database properties are mapped to metadata

Documentation shows filtering by properties:

const projectWithStatus = await client.search.documents({
  q: "machine learning project",
  filters: JSON.stringify({
    AND: [
      { key: "status", value: "In Progress" },
      { key: "priority", value: "High" }
    ]
  })
});

Actual Behavior

Properties only appear as markdown tables in document content. Metadata object contains only generic Notion fields, no custom database properties.

Example: "To Do List" Database

Notion Database Structure:

  • Database name: "To Do List"
  • Properties: Assignee (Person), Status (Select), Due date (Date), Task name (Title)
  • 7 tasks with varying statuses ("Done", "Not started") and due dates

What Gets Synced to Supermemory:

Content (as markdown):

| Assignee | Status | Due date | Task name |
| --- | --- | --- | --- |
| Amama  | Not started | 2026-01-19 | Click me to learn how to hide checked items |
| Amama  | Not started | 2026-01-19 | See finished items in the "Done" view |
| Amama  | Done | 2026-01-19 | Check the box to mark items as done |
| Amama  | Not started | 2026-01-20 | Click me to learn how to see your content your way |

Metadata (structured):

{
  "createdAt": "2026-01-19T16:02:00.000Z",
  "lastEditedTime": "2026-01-19T16:17:00.000Z",
  "title": "To Do List",
  "type": "notion_doc",
  "url": "https://www.notion.so/To-Do-List-2ed47295e89980509418c25122b0332c",
  "notionTitle": "To Do List",
  "notionCreatedAt": "2026-01-19T16:02:00.000Z",
  "notionLastEditedTime": "2026-01-19T16:17:00.000Z",
  "notionUrl": "https://www.notion.so/To-Do-List-2ed47295e89980509418c25122b0332c",
  "source": "notion",
  "notionProcessed": true,
  "extractedAt": "2026-01-21T17:22:17.911Z"
}

What's Missing

The database properties (Assignee, Status, Due date) from the individual task entries are not extracted as metadata. For a database entry like "Check the box to mark items as done", the expected meta data was:

{
  "assignee": "Amama",
  "status": "Done",
  "due_date": "2026-01-19",
  "task_name": "Check the box to mark items as done",
  ..... and so on
}

Use Case

Need to query tasks by their properties:

  • Find all tasks with status: "Not started"
  • Find all tasks assigned to assignee: "Amama"
  • Find all tasks due on due_date: "2026-01-19"
  • etc

Currently not possible because properties exist only as text in markdown tables, not as queryable metadata fields.

Reproduction Steps

  1. Create Notion connection via /v3/connections/notion
  2. Complete OAuth flow
  3. Sync workspace: POST /v3/connections/notion/import
  4. Retrieve database document

Environment

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions