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/06/01 23:31:05

Notion API formula filters — query computed properties without fetching a single extra row

The Notion API's `formula` filter key lets you query against computed formula properties server-side across four result sub-types — checkbox, date, number, and string. This tip walks through building two Formulas 2.0 properties (Risk Score and Is Overdue) in a task database, constructing a compound filter that surfaces high-risk sprint items in one request, and documents five production gotchas including the UI-vs-API creation trap, UTC date defaults, silent type-change breakage, Formulas 2.0 initialization lag, and floating-point precision.

Notion Automation Pro Tips2026/05/31 23:24:22

Make.com Router — status-driven conditional branching for Notion databases

Notion's native automations have no If-Then-Else. This tip shows how to wire Make's Router module as the branching primitive: one Watch Database Items trigger fans into three separate paths filtered by a Notion Status property value, each path executes a different action chain (Slack notification / cross-database release-tracker update / fallback audit flag), and every path writes back a Make Status field to prevent re-fires. Covers OAuth connection requirements, the Status Name mapping gotcha, credit math for free-plan scheduling, and four production gotchas including the 2,000-character silent fail and formula/rollup invisibility.

Notion Automation Pro Tips2026/05/30 23:26:09

Fix the Zod handshake bug — build a Notion-ready MCP server in 60 lines

Notion's Custom Agent silently kills any MCP server with strict Zod validation by injecting three undocumented non-standard fields during the initialization handshake. A 6-line Express middleware — notionStripMiddleware — strips them before the SDK transport ever parses the request. The article explains why .strip() and .passthrough() alone don't reach the failure point, provides a complete copy-pasteable 60-line server with stateless transport mode, a deployment quick-reference table, two verification signals, and four production gotchas.

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