Use spreadsheet intake to prepare DataRobot data
Connect incoming spreadsheet activity to a defined SQL transformation over datasets already available in DataRobot.
Trigger
New Rows in Google Sheet
Simple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new sheet entries.
Action
Create Data Engine Workspace State
Create a Data Engine workspace state by executing a SQL query against DataRobot datasets. Use when you need to transform, join, or prepare data before modeling. The workspace state captures the query definition and can be used to generate new datasets or feed into projects.
Why this helps
Data preparation can get delayed when teams must notice a new intake and manually restart a familiar query.
- Reduce manual reminders to run a known preparation query
- Keep intake events connected to a defined data preparation step
- Create a workspace state for downstream dataset or project work
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and DataRobot once in the Notis portal.
- 2Create an automation in Automations, New Automation, and give it a name.
- 3Provide the SQL query and references to existing DataRobot datasets that Notis should use.
- 4Pick the Google Sheets New Rows in Google Sheet trigger and choose where run reports should go.
- 5Test with one real row and confirm the workspace state in DataRobot.
Questions about this workflow
Does this automatically bring the Google Sheet into DataRobot SQL?
The action executes SQL against DataRobot datasets. The sheet must already be represented in an accessible DataRobot dataset for the query to use it.
Will Notis invent the query?
Provide a tested query or clear query requirements and valid dataset references. The action creates a workspace state by executing SQL against DataRobot datasets.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Datarobot. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Datarobot actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add Users to Group
Tool to add one or more users to a DataRobot user group by groupId. Use when you have a valid groupId and want to add existing usernames. Limit 100 users per request.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Add User to Organization
Tool to add a user to an existing organization. Use when you have an organizationId and wish to add or create a user within it.
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.
Analyze Dataset Definition
Tool to analyze a dataset definition by ID. Use when you need to trigger an analysis job that retrieves dataset metadata, schema, and statistics.
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.
Archive Model Package
Tool to archive a DataRobot model package. Use when you need to archive a model package that is no longer actively used.
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.
Build Java Scoring Code Package
Initiates an asynchronous build of a Java JAR package containing DataRobot Scoring Code for a deployment. The JAR can be executed locally for predictions or used as a library in Java applications. Use after confirming the deployment is active and supports scoring code. Poll the returned statusId or location URL to track build progress.
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.
Cancel Notebook Job
Tool to cancel a running or pending notebook job execution. Use when you need to stop a notebook job that is currently executing or queued. The cancellation is immediate and cannot be undone.
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.
Cancel Project Job
Tool to cancel a pending job for a project. Use when you need to stop a queued or running job after confirming its ID.
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.
Check Project Status
Tool to check the status of a DataRobot project. Use after creating or loading a project to monitor its stage and Autopilot completion.
Connect any two apps with Notis in the middle.
Google Sheets and Datarobot, 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 Datarobot.