Catch data quality questions in a Notion watchlist
Turn a recurring SQL check into a short list of what needs a human look.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Add multiple content blocks (bulk, user-friendly)
Efficiently adds multiple standard content blocks to a notion page in a single api call with automatic markdown parsing. the 'content' field in notionrichtext blocks now automatically detects and parses markdown formatting including headers (# ## ###), bold (**text**), italic (*text*), strikethrough (~~text~~), inline code (`code`), links ([text](url)), and more. ideal for bulk content creation, ai agents, and replacing multiple individual add page content calls. supports automatic text formatting, content splitting, and up to 100 blocks per request.
Why this helps
Data issues can sit unnoticed when nobody has time to remember and rerun the checks that might reveal them.
- Run the same quality check on a predictable schedule.
- Surface returned rows that deserve attention.
- Give the team one Notion page for follow-up and investigation.
Setup
Build it in a few focused steps.
- 1Connect ClickHouse and Notion once in the Notis portal.
- 2Create an automation and describe the data quality checks and summary you need.
- 3Pick a recurring schedule for those checks.
- 4Choose where Notis should send run reports.
- 5Test with one real check and confirm the watchlist is useful.
Questions about this workflow
Can Notis decide what counts as a data issue?
Only if you describe the checks or thresholds in the instruction or query. Notis can summarize the returned results, but it cannot supply an unstated baseline.
What if the query returns no concerning rows?
Ask Notis in the instruction to record that no issues were returned, so the scheduled check still leaves a clear status in Notion.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link ClickHouse to Notion. A trigger fires from one place; an action lands in another.
ClickHouse triggers
Notion actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add multiple content blocks (bulk, user-friendly)
Efficiently adds multiple standard content blocks to a notion page in a single api call with automatic markdown parsing. the 'content' field in notionrichtext blocks now automatically detects and parses markdown formatting including headers (# ## ###), bold (**text**), italic (*text*), strikethrough (~~text~~), inline code (`code`), links ([text](url)), and more. ideal for bulk content creation, ai agents, and replacing multiple individual add page content calls. supports automatic text formatting, content splitting, and up to 100 blocks per request.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Add content to Notion page
Deprecated: appends a single content block to a notion page or a parent block (must be page, toggle, to-do, bulleted/numbered list, callout, or quote); invoke repeatedly to add multiple blocks.
Append complex blocks (advanced, full control)
Appends complex blocks with full notion block structure to a parent block or page. use for advanced scenarios requiring precise control: code blocks, tables, embeds, nested children within blocks, or when working with pre-built notion block objects. requires full notion api block schema - use add multiple page content for simpler content creation.
Archive Notion Page
Archives (moves to trash) or unarchives (restores from trash) a specified notion page.
Create comment
Adds a comment to a notion page (via `parent page id`) or to an existing discussion thread (via `discussion id`); cannot create new discussion threads on specific blocks (inline comments).
Create Notion Database
Creates a new notion database as a subpage under a specified parent page with a defined properties schema; use this action exclusively for creating new databases.
Create Notion page
Creates a new empty page in a notion workspace.
Delete a block
Archives a notion block, page, or database using its id, which sets its 'archived' property to true (like moving to "trash" in the ui) and allows it to be restored later.
Connect any two apps with Notis in the middle.
ClickHouse and Notion, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Notion.