Why shouldn't you rely on Notion's 'Last edited time' for completed work?

'Last edited time' changes whenever someone fixes a typo or updates a property. A dedicated `Completed Date` date property guarantees historical accuracy.

How do you query a Notion database for completed tasks?

Send a `POST /v1/databases/:id/query` request with a compound filter: `Status equals Done` AND `Completed Date on_or_after `.

Can multiple Notion databases be combined into one update?

Yes. Map each Notion database (e.g. 'Engineering Tasks', 'Design System') to its respective category in Soobrief.

How are Notion rich text blocks converted to markdown?

Soobrief parses Notion page block trees, converting paragraphs, code snippets, and callouts into standard clean Markdown.

Generate Verified Release Notes from Notion Databases

How to query Notion project databases, filter by Status and completion dates, and generate accurate weekly changelogs.

Soobrief Team — Product & Engineering, Sooapps · 2026-09-04

In short

Generating a verified changelog from Notion requires querying a database with an explicit `Status == 'Done'` filter and a dedicated `Completed Date` property. Mapping database relation rollups to product areas ensures clean, repeatable release documentation without manual page copying.

Generating a verified changelog from Notion requires querying a database with an explicit Status == 'Done' filter and a dedicated Completed Date property. Mapping database relation rollups to product areas ensures clean, repeatable release documentation without manual page copying.

Many modern tech companies use Notion as their all-in-one product management hub. But pulling release notes out of Notion databases usually involves tedious manual filtering and copy-pasting across pages.

1. Database Schema Requirements for Automation

To generate reliable changelogs from Notion, your database must include:

Status Property: Type status with a group matching "Complete".
Completed Date Property: Type date, populated automatically via Notion database automations or manually on task completion.
Category / Area: Type select or relation indicating the target product area.


{
  "filter": {
    "and": [
      {
        "property": "Status",
        "status": { "equals": "Done" }
      },
      {
        "property": "Completed Date",
        "date": { "on_or_after": "2026-09-03" }
      }
    ]
  }
}

2. Ingesting Page Content Safely

While the task title provides the changelog item, Notion page bodies often contain extensive mockups, meeting notes, and internal discussions. The ingestion layer selectively extracts only the top summary callout, ensuring internal draft notes are never leaked to customer release feeds.