Capture Bolt readings from changed sheet ranges
A controlled spreadsheet update can request a fresh physical measurement.
Trigger
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.
Action
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.
Why this helps
Sensor checks are often forgotten after a planning value changes.
- Tie measurements to a specific range update
- Make spreadsheet driven checks repeatable
- Keep the latest reading in run reports
Setup
Build it in a few focused steps.
- 1Connect Google Super and Bolt iot in Notis.
- 2Create a new automation.
- 3Tell Notis to read the specified Bolt analog pin whenever the watched range changes and explain the desired report.
- 4Pick Cell Range Values Changed as the trigger and select a report channel.
- 5Change one test cell and verify the reading.
Questions about this workflow
Can the trigger watch a single cell?
Yes. The event monitors a specified A1 range, including a single cell.
What does Analog Read return?
It returns the analog value from the selected Bolt pin.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Super to Bolt iot. A trigger fires from one place; an action lands in another.
Google Super triggers
Bolt iot actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
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.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
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.
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.
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.'
Attendee Response Changed
Polling trigger that fires when any attendee's RSVP changes to accepted, declined, or tentative. Returns attendee info and current status.
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.
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.
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.
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
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.
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.
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.
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.
Connect any two apps with Notis in the middle.
Google Super and Bolt iot, 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 Bolt iot.