Keep key numbers current when a Drive dataset changes
Have the latest file trigger the same KPI calculation, so you can review the updated numbers without repeating the analysis.
Trigger
File Updated
Triggers when a file's metadata or content changes in Google Drive.
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
Repeating the same calculations after a file update creates busywork and makes it easy to compare the wrong version.
- Recalculate specified metrics after file changes
- Keep a repeatable analysis instruction
- Reduce version mix-ups
Setup
Build it in a few focused steps.
- 1Connect Google Drive and Codeinterpreter once in the Notis portal.
- 2Create an automation for your KPI snapshot.
- 3Describe the metrics, input file, and output summary in one instruction.
- 4Pick File Updated as the trigger and choose where run reports go.
- 5Test with one real updated dataset.
Questions about this workflow
Can it compare this update with the previous version?
Only if the earlier version or baseline is available to the automation or you provide the comparison values. Otherwise, it can calculate the current snapshot.
Can I specify my own KPI definitions?
Yes. Include formulas, date ranges, and any exclusions in your instruction.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Drive to Codeinterpreter. A trigger fires from one place; an action lands in another.
Google Drive 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.
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
Get File
Get a file from the sandbox and returns the file. the files should be read from /home/user folder.
File Created
Triggers when a new file is created in Google Drive.
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.
File Deleted or Trashed
Triggers when a file is moved to trash or permanently deleted in Drive.
Upload File
Upload a file to the sandbox environment. the files should be uploaded to the /home/user folder.
File Shared (Permissions Added)
Triggers when new sharing permissions are granted to a file or folder. Uses Drive's `changes.list` endpoint with inline `permissions` in the `fields` mask so each change carries the file's current permission set provider-atomically. We diff that against `seen_permission_keys` to identify newly added grants. Drive page tokens are the primary cursor; if Drive rejects a stored token, the trigger raises `PollingTriggerError` without clearing state rather than silently re-baselining and dropping events. Limitation: truly ephemeral permissions (added and revoked between two polls without any other file modification in between) are not detected. Drive Activity API would catch those but requires an additional OAuth scope and a different payload contract.
File Updated
Triggers when a file's metadata or content changes in Google Drive.
Google Drive Changes
Triggers when changes are detected in a Google Drive.
Connect any two apps with Notis in the middle.
Google Drive 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.