Connect Google Sheets and Yelp to power automations.

Trigger from one app, act on another, with a thinking brain in the middle. Build it in plain English. Approve from your phone.

When this happens · Trigger

Do this · Action

Build an automation Browse templates

Supported Triggers and Actions

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

Google Sheets triggers

Yelp actions

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

Autocomplete Search

Get autocomplete suggestions for businesses, categories, and search terms on Yelp based on partial text input. Returns matching businesses with their Yelp IDs, relevant category suggestions, and additional search term recommendations. Use this action when users are typing search queries and need real-time suggestions to refine their search before executing a full business search. Location coordinates (latitude/longitude) are optional but can improve suggestion relevance for geographic searches.

ActionInstant

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

Get Business Details

Get detailed information about a specific business on Yelp using its business ID or alias. Returns comprehensive business information including hours (in the business's local timezone), photos, reviews, and location details. The returned `url` field is the Yelp listing page, not the business's own website. Response fields such as `phone` and `website` may be null; handle missing values explicitly. Avoid many parallel calls — HTTP 429 throttling applies; limit concurrency to ~5 parallel requests with exponential backoff.

ActionInstant

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

Get Business Reviews

Get reviews for a specific business on Yelp using its business ID or alias. Returns up to 3 review excerpts for the business.

ActionInstant

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

Get Category Details

Get detailed information about a specific Yelp category by its alias. Returns category metadata including the human-readable title, parent categories, and country availability lists. Use this action when you need to understand category hierarchies, check category availability by country, or get the proper display name for a category alias. The alias parameter must be a valid Yelp category identifier — use the list categories endpoint to discover available aliases.

ActionInstant

Developer Metadata Changed

Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.

TriggerPolling

Get Event Details

Get detailed information about a specific Yelp event using its event ID. Returns comprehensive event information including dates, location, cost, attendance counts, and associated business details. Use this action when you need to retrieve full details about a specific event that you already have the ID for. Event IDs can be obtained from the search events or featured events endpoints.

ActionInstant

Filtered Range Values Changed

Polling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.

TriggerPolling

Get Featured Event

Get the featured event for a given location on Yelp. Featured events are chosen by Yelp's community managers and represent notable happenings in the specified area. Use this action when you need to discover the highlighted or recommended event for a specific city, region, or coordinates. The returned `event_site_url` is the Yelp event page, not the event's own external website. Response fields such as `business_id`, `cost`, and `tickets_url` may be null; handle missing values explicitly.

ActionInstant

New Rows in Google Sheet

Simple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new sheet entries.

TriggerPolling

Get Review Highlights

Get review highlights for a specific business on Yelp using its business ID or alias. Returns summarized key points and themes from customer reviews. IMPORTANT: This endpoint requires Yelp Places API Premium Plan access. Without Premium Plan, requests will return a 403 NOT_AUTHORIZED error. For basic review access, consider using the Get Business Reviews action instead, which is available on Enhanced and Premium plans. Note: Get Business Reviews returns at most 3 recent reviews per call, while this action synthesizes themes across the full review history.

ActionInstant

New Sheet Added in Google Spreadsheet

Polling trigger that detects when a new sheet is added to a Google Spreadsheet.

TriggerPolling

List Categories

List all Yelp business categories across all locales by default. Returns category aliases, titles, parent relationships, and geographic availability. Use this action when you need to discover valid category aliases for filtering business searches or when building category-based navigation. The locale parameter allows filtering to categories available in specific regions while translating category names to the local language.

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 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.