Skip to content
Notis

Find Baserow tables after a sheet metric changes

Turn meaningful KPI movement into a focused table review.

Trigger

Aggregate Metric Changed

Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.

Action

List Tables in Database

This tool lists all tables within a specified baserow database. it allows users to retrieve information about all tables in a database by using the get /api/database/{database id}/tables/ endpoint. the expected output is an array of table objects containing details such as id, name, order, database id, type, and first row header.

Why this helps

Metric changes demand investigation, but the supporting operational table is often unclear.

  • Speed up KPI investigation
  • Connect metrics to source tables
  • Focus review time

Setup

Build it in a few focused steps.

  • 1Connect Google Super and Baserow once in the Notis portal.
  • 2Create an automation asking Notis to list Baserow tables relevant to the changed aggregate and summarize likely investigation paths.
  • 3Pick the Aggregate Metric Changed trigger.
  • 4Choose a report destination and test with one real metric change.

Questions about this workflow

Which aggregates are supported?

The trigger supports SUM, COUNT, AVG, MIN, and MAX.

Can it filter the metric?

The trigger can optionally filter by a search column and value.

When this happens · Trigger

Do this · Action

Supported Triggers and Actions

Notis builds workflows that link Google Super to Baserow. A trigger fires from one place; an action lands in another.

Google Super triggers

Baserow actions

Recurring trigger

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

TriggerScheduled

List Databases

This tool retrieves a list of all databases in a specified workspace. as a fundamental operation, it allows users to discover which databases are available in their baserow workspace. this operation is independent and requires only authentication in order to fetch essential metadata for subsequent operations.

ActionInstant

Webhook trigger

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

TriggerInstant

List Tables in Database

This tool lists all tables within a specified baserow database. it allows users to retrieve information about all tables in a database by using the get /api/database/{database id}/tables/ endpoint. the expected output is an array of table objects containing details such as id, name, order, database id, type, and first row header.

ActionInstant

Aggregate Metric Changed

Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.

TriggerPolling

Attendee Response Changed

Polling trigger that fires when any attendee's RSVP changes to accepted, declined, or tentative. Returns attendee info and current status.

TriggerPolling

Cell Range Values Changed

Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.

TriggerPolling

Comment Added (Docs/Sheets/Slides)

Triggers when a new comment is added to Google Docs, Sheets, or Slides.

TriggerPolling

Conditional Format Rule Changed

Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.

TriggerPolling

Data Validation Rule Changed

Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.

TriggerPolling

Connect any two apps with Notis in the middle.

Google Super and Baserow, 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 Baserow.