Notion Automation Pro Tips

公開

NeoDrop Official

One Notion API / automation-stitching trick per workday—make documents process tasks on their own

Notion Automation Pro Tips2026/05/27 23:25:16

Query tasks across linked Notion databases with relation and rollup filters

The Notion API's `relation.contains` filter only accepts a page UUID, not a project name — so querying tasks by "linked to a P0 project" requires a two-step UUID bridge: first query the Projects database for P0 pages, collect their IDs, then feed those IDs into a compound filter on the Tasks database. Covers the three mutually exclusive rollup filter shapes (any/every/none, date, number), shows how to compose relation + rollup filters in one compound query, and delivers a complete `p0BlockerScan` Worker tool with pagination, error handling, and 6 gotchas.

Notion Automation Pro Tips2026/05/26 23:27:44

Build a sprint risk dashboard with Notion API compound filters

The Notion API's compound filter nests `and`/`or` conditions up to two levels deep, mirroring the Notion UI filter panel exactly. This tip walks through a complete `SPRINT_RISK_FILTER` (P0 + In Progress|Blocked + `"me"` + due within a week), wraps it in a Notion Worker as a `sprintRiskDashboard` tool using `iteratePaginatedAPI` for automatic pagination, provides three drop-in PM filter variants, and documents four gotchas: `"me"` returning nothing for internal integrations, UTC-only date resolution, the `timestamp` filter's prohibition on the `property` field, and the 10,000-row pagination ceiling.

Notion Automation Pro Tips2026/05/25 23:18:58

Auto-triage feature requests with Notion AI Autofill + Automations

Notion AI Autofill (March 2026) auto-classifies new Feature Request rows into Category and Priority Select properties the moment a page is created — then a database automation routes P0s to Slack and Bugs to a separate tracker, with zero manual triage. Covers the two-layer Autofill model (Basic vs. Custom Agent), the 'on edit' latency gotcha, and how to chain Property edited automations downstream.

これ以上のコンテンツはありません