Bring document exceptions into focus
Ask Notis to inspect a document and look up related ClickHouse records so you can review the cases that need attention.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
Execute ClickHouse Query
Runs a SQL query in ClickHouse, including queries that modify data or schema.
Why this helps
A document that needs a second look can be difficult to compare with related records already stored in analytics.
- Pair extracted document details with relevant records from ClickHouse.
- Keep review context together in one run report.
- Make exceptions easier to triage without searching multiple tools.
Setup
Build it in a few focused steps.
- 1Connect Algodocs and ClickHouse once in the Notis portal.
- 2Create an automation named Document processing exceptions.
- 3Tell Notis to process each submitted document with Algodocs, identify the review conditions you provide, and query ClickHouse for related records.
- 4Choose the Webhook trigger and choose where run reports go.
- 5Test with one real document that should be reviewed and check the returned records.
Questions about this workflow
Can Notis decide what counts as an exception?
Specify the review conditions in the Prompt. Notis can compare the processed document and query results against those conditions.
Does ClickHouse provide a historical baseline automatically?
Only if the relevant historical records are stored in ClickHouse and your query can retrieve them.
When this happens · Trigger
Do this · Action
Runs a SQL query in ClickHouse, including queries that modify data or schema.
Supported Triggers and Actions
Notis builds workflows that link Algodocs to ClickHouse. A trigger fires from one place; an action lands in another.
Algodocs triggers
ClickHouse actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Execute ClickHouse Query
Runs a SQL query in ClickHouse, including queries that modify data or schema.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Database Schema
Retrieves a ClickHouse database schema overview and optionally its column definitions.
Get Table Schema
Gets the schema and column details for a table.
Get ClickHouse Play Interface
Returns the ClickHouse Play interface for writing queries and viewing results.
List ClickHouse Databases
Lists the databases in an instance.
List ClickHouse Tables
Lists tables in databases with basic details.
Connect any two apps with Notis in the middle.
Algodocs and ClickHouse, or any other combination from 1,600+ 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 ClickHouse.