PREREQUISITE: Call NOTION_FETCH_DATABASE first to discover property names and types. Filter type keys MUST match the property's actual type in the schema. Each filter object MUST contain exactly ONE filter type key. For multiple conditions, use compound filters: {"and": [{"property": "Name", "title": {...}}, {"property": "Description", "rich_text": {...}}]}. 'title' IS A RESERVED PROPERTY NAME: 'title' always refers to the database's built-in primary title column (type 'title', NOT 'select' or 'rich_text'). Even custom properties named 'title' are treated as the built-in title column. FILTER TYPE MUST MATCH SCHEMA TYPE: Property names are NOT reliable indicators of type. A property named 'Status' could be type 'select' in one database but type 'status' in another. 'select' is for dropdowns; 'status' is ONLY for Notion's built-in Status property with workflow groups. SELECT/STATUS/MULTI_SELECT VALUES ARE CASE-SENSITIVE: Option names must match EXACTLY as defined in the database schema, including capitalization and emoji prefixes (e.g., 'Done' not 'done', '✅ Done' not 'Done'). Common mistake: using 'done' when the actual option is 'Done'. Check the database schema for exact option names. Valid filter type keys: title, rich_text, number, checkbox, select, multi_select, status, date, people, files, url, email, phone_number, relation, created_by, created_time, last_edited_by, last_edited_time, formula, unique_id, rollup, verification, timestamp. FORMULA FILTERS: Structure: {'property': '', 'formula': {: {: }}}. Result types: 'string' (rich_text conditions), 'number' (numeric conditions), 'date' (date conditions), 'checkbox' (boolean conditions). The result type MUST match the formula's actual output type. If the formula property value shows type 'boolean', use 'checkbox' in the filter (API naming mismatch). Some complex formulas are unfilterable ('Unable to filter based on a formula of unknown type') - use client-side filtering instead. NOTE: 'text' is NOT valid - use 'rich_text' for text properties or 'title' for title properties. SYSTEM TIMESTAMP FILTERS: Use simplified format: {"created_time": {"on_or_after": "2024-01-01"}} - auto-transformed to correct API format. Filter structure for database properties: {"property": "", "": {"": ""}}. Common conditions by type: title/rich_text: equals, contains, starts_with, ends_with, is_empty, is_not_empty; select/status: equals, does_not_equal, is_empty, is_not_empty; number: equals, does_not_equal, greater_than, less_than, greater_than_or_equal_to, less_than_or_equal_to, is_empty, is_not_empty; checkbox: equals (true/false); date: equals, before, after, on_or_before, on_or_after, is_empty, is_not_empty, past_week, past_month, past_year, next_week, next_month, next_year; relation: contains, does_not_contain (both require a valid page UUID), is_empty, is_not_empty. ROLLUP FILTERS: Require a nested aggregation type wrapper. Do NOT use flat filters like {"rollup": {"contains": "value"}}. Instead use one of: (1) {"rollup": {"any": {}}} - matches if ANY related item satisfies condition; (2) {"rollup": {"every": {}}} - matches if ALL related items satisfy condition; (3) {"rollup": {"none": {}}} - matches if NO related items satisfy condition; (4) {"rollup": {"number": {}}} - for number rollup aggregations (count, sum, avg, etc.); (5) {"rollup": {"date": {}}} - for date rollup aggregations (earliest, latest). Inside rollup.any/every/none, use the filter type matching the underlying property type. Compound filters use 'and' or 'or' arrays: {"and": [, ]} or {"or": [, ]}.

Build AI agents that work in Notion

Everything your agent can do in Notion

Add multiple content blocks (bulk, user-friendly)

Append code blocks (code, quote, equation)

Append layout blocks (divider, TOC, columns)

Append media blocks (image, video, audio, files)

Append table blocks

Append task blocks (to-do, toggle, callout)

Append text blocks (paragraphs, headings, lists)

Archive Notion Page

Create comment

Create Notion Database

Create Notion file upload

Create Notion page

Create Notion view

Create Notion view query

Delete a block

Delete Notion view

Delete Notion view query

Duplicate page

Fetch All Notion Block Contents

Fetch comments

Fetch Database

Fetch database row

Fetch Notion Block Children

Fetch Notion block metadata

Fetch Notion Data

Get about user

Get Notion view query results

Get page markdown

Get page property

Get plugin

Insert row database

Insert Row From Natural Language

List data source templates

List Notion file uploads

List Notion views

List plugins

List users

Move Page

Query data source

Query database

Query database with filter

Replace page content (with backup)

Retrieve Comment

Retrieve Database Property

Retrieve Notion file upload

Retrieve Notion view

Retrieve page

Search Notion pages and databases

Send file upload

Update block

Update Database Row (Page)

Update database schema

Update Notion view

Update Page

Update page markdown

Upsert database rows

Who Am I

More integrations

Build your first Notion agent