Connect Airwallex to ClickHouse

When something happens in Airwallex, 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

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

Build an automation Browse examples

Examples

Ways Notis can move work from Airwallex to ClickHouse

Airwallex Cash Position Snapshot in ClickHouse

Run a scheduled ClickHouse query against Airwallex account data and receive a concise cash position report.

Check Airwallex Payout Reconciliation

Query ClickHouse on a schedule for payout records that may need reconciliation review.

Review Airwallex FX Movements

Run a scheduled ClickHouse query to summarize foreign exchange records and highlight movements for review.

Scan Airwallex Card Spend for Outliers

Query ClickHouse on a schedule for card spend records that stand out under criteria you define.

Track Airwallex Payment Volume Trends

Run a scheduled ClickHouse query to summarize payment volume over periods you specify.

Refresh the Airwallex Data Schema Inventory

Get a scheduled overview of ClickHouse databases and tables used for Airwallex data.

Retrieve Airwallex Table Details on Request

Start from an HTTP request and retrieve detailed ClickHouse schema information for a specified table.

Investigate Airwallex Payments from a Request

Start a ClickHouse payment query from an HTTP request carrying investigation context.

Investigate Airwallex Payouts from a Request

Use a Notis HTTP request to query ClickHouse for payout records relevant to an investigation.

Supported Triggers and Actions

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

Airwallex 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

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 schedule (recurring or one-time), and a change in one of your Notis databases.

Integration triggers

Fire when something happens inside a connected app. New Notion page, Stripe charge, Linear issue: any of 1,500+ 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

Scheduled triggers

Run a workflow on the clock, on a recurring schedule or once at a set date and time. Daily standups, hourly syncs, a one-off launch reminder: the workhorse of Notis.

Daily · 8:00Weekdays onlyOnce · Dec 13

Beta

Database triggers

Fire when a row in one of your Notis databases is added or edited, with optional filters on its properties. New lead added, status changed, value crosses a limit.

Row addedProperty editedValue > limit

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.