See the pattern behind changed sheet values
A range of updated numbers can be hard to scan. Generate a chart from the changed values and get a file to review in your report channel.
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
Execute Code
Execute python code in a sandbox and return any result, stdout, stderr, and error. use /home/user folder to write/read files. try to not use plt.show() as the code is executed remotely. use files for image/chart output instead.
Why this helps
Spotting trends across changing numbers takes attention away from decisions and follow-up.
- Analyze values when a monitored range changes
- Create a chart file for visual review
- Reduce manual copying into analysis tools
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Codeinterpreter once in the Notis portal.
- 2Create an automation in Automations, then choose a name and report channel.
- 3Tell Notis to analyze changed range values with Python, save a relevant chart file, and share the result in the run report.
- 4Choose the Cell Range Values Changed trigger.
- 5Test it with one real example and review the run report.
Questions about this workflow
Can it chart any arbitrary data from the spreadsheet?
The trigger monitors a specified A1 range. The chart depends on the values and structure available in the changed range.
Where does the chart go?
The Python action can save a chart file in its sandbox. The automation run report can summarize the result.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Codeinterpreter. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Codeinterpreter actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Sandbox
Create a sandbox to execute python code in a jupyter notebook cell. this is useful for agents to communicate, execute code, see output, read files, write files, etc. it's like you own personal computer, but in the cloud. use /home/user folder to write/read files.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Execute Code
Execute python code in a sandbox and return any result, stdout, stderr, and error. use /home/user folder to write/read files. try to not use plt.show() as the code is executed remotely. use files for image/chart output instead.
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.
Get File
Get a file from the sandbox and returns the file. the files should be read from /home/user folder.
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.
Run Terminal Command
Run a command in the terminal and returns the stdout, stderr, and error code. use /home/user folder to write/read files.
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.
Upload File
Upload a file to the sandbox environment. the files should be uploaded to the /home/user folder.
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.
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.
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 Codeinterpreter, 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 Codeinterpreter.