Connect Airtable to ClickHouse

When something happens in Airtable, Notis takes the next step in ClickHouse. Describe what you want in plain English, or start from one of the examples below.

When this happens · Trigger

Do this · Action

Build an automation Browse examples

Examples

Ways Notis can move work from Airtable to ClickHouse

View example

Log Airtable base access changes in ClickHouse

Keep a ClickHouse audit trail when an Airtable base name or permission level changes.

View example

Snapshot ClickHouse schema after Airtable changes

When Airtable tables or fields change, fetch a ClickHouse database schema snapshot to help review downstream data structures.

View example

Check ClickHouse table readiness when a view is created

When a new Airtable view appears, retrieve the relevant ClickHouse table schema for a quick data-readiness review.

View example

Log deleted Airtable views for reporting cleanup

Record deleted Airtable view details in ClickHouse so you can review reports and processes that may need cleanup.

View example

Review ClickHouse table structure after view changes

When an Airtable view name or type changes, retrieve a specified ClickHouse table schema to support query and reporting review.

View example

Get a scheduled ClickHouse database inventory

On a recurring schedule, list ClickHouse databases and send the inventory to your chosen run report channel.

View example

Request a ClickHouse table inventory on demand

Start a Notis webhook to list ClickHouse tables for a specified database and return the inventory in a run report.

Supported Triggers and Actions

Notis builds workflows that link Airtable to ClickHouse. A trigger fires from one place; an action lands in another.

Airtable triggers

ClickHouse actions

Recurring trigger

Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.

TriggerScheduled

Execute ClickHouse Query

Execute a sql query in clickhouse and return the results. this is the primary action for querying data from clickhouse databases.

ActionInstant

Webhook trigger

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

TriggerInstant

Get Database Schema

Get comprehensive schema overview of an entire database including all tables and optionally their column definitions. essential for ai agents to understand the complete database structure in a single call.

ActionInstant

Base Metadata Changed

Triggers when an existing Airtable base changes its name or permission level.

TriggerPolling

Get Table Schema

Get detailed schema information for a specific table including column definitions, types, keys, and optionally sample data. this is essential for ai agents to understand table structure before constructing queries.

ActionInstant

Base Schema Changed

Triggers when tables, fields, or views change in an Airtable base.

TriggerPolling

List ClickHouse Databases

List all databases in the clickhouse instance. useful for discovering available databases before querying tables.

ActionInstant

User Profile Changed

Triggers when the connected Airtable user's profile information changes.

TriggerPolling

List ClickHouse Tables

List tables in clickhouse databases. returns information about tables including their engine, size, and row count.

ActionInstant

View Created

Triggers when a new view is created in an Airtable base.

TriggerPolling

View Deleted

Triggers when a previously known Airtable view is deleted.

TriggerPolling

View Metadata Changed

Triggers when an Airtable view changes its name or type.

TriggerPolling

Trigger Types

Four ways to start an automation.

A trigger is the event that kicks a workflow off. Notis supports four kinds: an event in a connected app, an inbound webhook, a recurring schedule, and soon, your own database.

Integration triggers

Fire when something happens inside a connected app. New Notion page, Stripe charge, Linear issue: any of 1,000+ apps can start a workflow.

New Notion pageStripe chargeCalendar event

Webhook triggers

A unique URL per workflow. Anything that can send an HTTP POST can start an automation, including no-code tools that speak webhooks.

Any HTTP POSTCustom backendIoT event

Works with

ZapierPipedream

Most used

Recurring triggers

Cron-style schedules run a workflow on the clock. Daily standups, hourly syncs, business-hours-only digests: the workhorse of Notis.

Daily · 8:00HourlyWeekdays only

Coming soon

Database triggers

Watch a row, query, or threshold in your own database and fire the moment the data changes. Row inserted, value crosses a limit, query starts matching.

Row insertedValue > limitQuery match

Why AI automation

Classic automation breaks. AI adapts.

Same triggers and actions, smarter middle. AI handles the fuzziness that breaks traditional Zapier-style workflows the moment a field gets renamed.

Classic automationAI automation

Cost

$ · pay per run

$$ · AI models per run

Reliability

Breaks on schema change

Adapts to format changes

Setup

Click 8 dropdowns

Describe it in English

Handles fuzzy

Hard-coded fields only

Reads intent, summarises

Human in loop

Bolted on

Built in · approval inbox

Maintenance

You own every break

Self-heals · we own it

Ease of use

Describe it. Notis builds it.

Skip the visual builder. Tell Notis what you want, in plain English. It writes the workflow, you review and deploy.

You · in the Notis Builder

NEW

“When a row gets added to the Q4 OKRs Notion database and the status is Blocked, send a Telegram message to the owner with a summary of what's blocking, and ping me if there's no reply within 24 hours.”

Notis built this automation:

TriggerRow added to "Q4 OKRs"

Condition✦Status = "Blocked"

AI step✦Summarise the blocker in plain English

ActionDM the row owner with summary

Timeout✦No reply in 24h → ping you

Observability

Watch every run.

Notis Desktop is Mission Control for your AI automations. See every run, replay, edit, or rewind. Set approval gates so Notis pauses before destructive actions.