Read a Notion database
query_notion_databaseRead filtered, sorted rows and columns from a Notion database to import calendars, schedule posts, or find rows to update. Returns up to 100 rows per call with cursor paging.
Instructions
Read the ROWS of a Notion database the user shared with Hermoso — e.g. the team's content calendar: each row's title, id, link and every property as a plain value (status, date, channels, caption, links), plus the database's columns with their types and options. Filter with match {"Status": "Scheduled"} (typed from the database's own columns) or a raw Notion filter object; sort with sortBy (a column, or created_time / last_edited_time) and direction. Up to 100 rows per call, cursor for more; the answer says when Notion stopped at its 10,000-result limit. Use it to import a calendar and schedule its posts, or to find the row update_notion_row changes. Read-only, free. Needs Notion connected (Settings > Connectors > Notion).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | 1-100, default 50 | |
| match | No | {"Column": value} — equality for status/select/checkbox/number/date, contains for text/multi-select | |
| cursor | No | nextCursor from the previous page of rows | |
| filter | No | a raw Notion filter object | |
| sortBy | No | column name to sort by, or created_time or last_edited_time | |
| archived | No | read archived rows instead | |
| direction | No | ascending (default) or descending | |
| databaseId | No | database id or link (list_notion_pages type:"database") | |
| dataSourceId | No | data source id from an earlier read, as an alternative to databaseId |