Skip to content
Notis

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.

TriggerScheduled

Execute ClickHouse Query

Runs a SQL query in ClickHouse, including queries that modify data or schema.

ActionInstant

Webhook trigger

Notis starts this workflow when an external tool or custom backend sends an HTTP request.

TriggerInstant

Get Database Schema

Retrieves a ClickHouse database schema overview and optionally its column definitions.

ActionInstant

Get Table Schema

Gets the schema and column details for a table.

ActionInstant

Get ClickHouse Play Interface

Returns the ClickHouse Play interface for writing queries and viewing results.

ActionInstant

List ClickHouse Databases

Lists the databases in an instance.

ActionInstant

List ClickHouse Tables

Lists tables in databases with basic details.

ActionInstant

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.