Turn filtered database requests into cluster creation
Keep database requests in a filtered sheet view and have Notis act when matching values change.
Trigger
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.
Action
Create Database Cluster
Tool to create a new managed database cluster. use when you need to provision a database cluster with name, engine, version, region, size, and number of nodes.
Why this helps
Database requests can be overlooked when capacity details are scattered across changing spreadsheet rows.
- React to changes in rows matching a data filter
- Use complete request details for cluster creation
- Reduce manual handoffs from planning to provisioning
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and DigitalOcean once in the Notis portal.
- 2Create an automation in Automations, New Automation, and provide a name and prompt.
- 3Describe how Notis should create a database cluster from matching values, with name, engine, version, region, size, and node count supplied.
- 4Pick Filtered Range Values Changed as the trigger and choose where run reports go.
- 5Test with one real matching value change and review the request details.
Questions about this workflow
What information must be available for cluster creation?
The request needs a cluster name, engine, version, region, size, and number of nodes. Use DigitalOcean's available options for valid values.
Does the trigger return matching values?
Yes. The filtered range trigger emits matched values when it detects changes.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Digital ocean. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Digital ocean actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Custom Image
Tool to create a new custom image by providing a url to a linux vm image. use when you need to import a vm image into digitalocean after specifying name, url, distribution, and region.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create Database Cluster
Tool to create a new managed database cluster. use when you need to provision a database cluster with name, engine, version, region, size, and number of nodes.
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.
Create New Block Storage Volume
Tool to create a new block storage volume. use when you need to provision persistent block storage after confirming the target region supports volumes. example: "create a 100 gib ext4 backup volume named 'db-backup' in nyc1."
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.
Create New Domain
Tool to create a new domain. use when you have the domain name and optionally an ip address to assign an a record.
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.
Create Domain Record
Tool to create a new dns record for a domain. use after confirming domain exists and record specifics.
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.
Create New Droplet
Tool to create a new droplet. use when you need to provision a vm with name, region, size, and image.
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.
Create New Firewall
Tool to create a new firewall. use when you need to define a firewall name and custom rules (requires at least one inbound and one outbound rule).
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.
Create New Kubernetes Cluster
Tool to create a new kubernetes cluster. use when you have finalized the cluster name, region, version, and at least one node pool. confirm region supports kubernetes clusters before use.
Connect any two apps with Notis in the middle.
Google Sheets and Digital ocean, 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 Digital ocean.