Capture a Bolt serial response when a spreadsheet is created
A newly created spreadsheet can prompt a defined device request and capture its reply, making setup checks easier to track.
Trigger
New Spreadsheet Created
Triggers when a new Google Spreadsheet is created. This trigger monitors Google Spreadsheets and fires when new spreadsheets are detected. Uses timestamp filtering to efficiently detect newly created spreadsheets.
Action
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.
Why this helps
Creating a new operational spreadsheet can require a separate device check that is easy to forget during setup.
- Send a specified ASCII request and capture the immediate response.
- Tie a device check to the creation of an operational spreadsheet.
- Keep the result visible in your selected run report channel.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Bolt IoT once in the Notis portal.
- 2Create a new automation in Automations and give it a clear name.
- 3Tell Notis: when a new spreadsheet is created, send the specified ASCII data to the specified Bolt device over UART and capture its response.
- 4Pick New Spreadsheet Created as the trigger and choose where run reports should go.
- 5Confirm UART is initialized, then test with one real spreadsheet creation and review the response.
Questions about this workflow
What does the serial write and read action do?
It sends ASCII data over UART and captures the reply immediately. UART must already be initialized with serialbegin.
Does the trigger watch for a particular spreadsheet name?
The listed trigger detects newly created Google Spreadsheets. The workflow description should not assume a name filter that is not listed.
When this happens · Trigger
Do this · Action
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.
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.'
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 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.
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 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.
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.
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.
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.
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.
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.
Connect any two apps with Notis in the middle.
Google Sheets 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.