Connect Google Sheets to Bolt iot

When something happens in Google Sheets, Notis takes the next step in Bolt iot. 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 Google Sheets to Bolt iot

View example

Check Bolt Devices When a Sheet Checklist Row Arrives

When a new row lists a Bolt device for attention, check whether that device is online before anyone tries to control it.

View example

Read a Bolt Sensor When a Sheet Control Range Changes

Use a change in a designated Google Sheets range to prompt a Bolt analog sensor reading and send the result to your report channel.

View example

Check Device Connectivity When a Sheet Metric Moves

When a monitored aggregate changes, ask Notis to check a specified Bolt device's online status and report the result for review.

View example

Use a Changed Sheet Row to Set a Bolt Digital Output

When a looked-up spreadsheet row changes, tell Notis the intended digital pin state and have it send that supported command to Bolt IoT.

View example

Read Bolt Serial Data When Filtered Sheet Values Change

When values matching a Google Sheets data filter change, prompt a serial read from a Bolt device and send the result to your run report channel.

View example

Send a Bolt Serial Command from a New Sheet Entry

Use a new row in an operations sheet as a cue to send a clearly specified ASCII command to a Bolt device over initialized UART.

View example

Check a Bolt Device When Sheet Validation Rules Change

When spreadsheet data validation rules change, check a specified Bolt device's online status and report the result for an operational review.

View example

Capture a Bolt Serial Reply When a New Spreadsheet Is Created

When a new spreadsheet is created, send a specified ASCII request to a Bolt device and capture its immediate serial response.

Supported Triggers and Actions

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

Google Sheets triggers

Bolt iot actions

Recurring trigger

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

TriggerScheduled

Analog Read

Tool to read the analog value from a specified pin on a bolt device. use when you need sensor readings (0–1023) after confirming the device is online.

ActionInstant

Webhook trigger

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

TriggerInstant

Bolt IoT Digital Write

Tool to set a digital pin high or low on a specified bolt device. use when controlling actuators or leds via digital output.

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

Check Bolt device online status

Tool to check whether a specified bolt device is online. use when you need to verify device connectivity before sending commands (e.g., control signals). example: 'check if device bolt1234567 is online.'

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

Bolt IoT Digital Write

Tool to set a digital pin high or low on a specified bolt device. use when controlling actuators or leds via digital output.

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

Bolt IoT Serial Read

Tool to read incoming serial data from a bolt device. use when you've initialized uart with serialbegin and need to retrieve serial data.

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

Bolt IoT Serial Write

Tool to send serial data to a bolt device. use when you need to transmit ascii data over uart after initializing uart with serialbegin.

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

Bolt IoT Serial Write & Read

Tool to send serial data and read the response on a bolt device. use when you need to transmit ascii data over uart and capture its reply immediately.

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

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.