Review Countdown API usage when a tracked metric shifts
When an important spreadsheet metric changes, get a current view of Countdown API usage and account status.
Trigger
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.
Action
Get Account Information
Tool to retrieve account usage and current platform status. Use when needing to check plan, usage, and quota details for the authenticated user.
Why this helps
A change in a tracked workload metric can be easy to miss when checking research capacity requires another portal visit.
- Pair a meaningful spreadsheet metric change with an account usage check.
- Bring platform status into the same run report.
- Avoid checking account usage without a clear operational cue.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Countdown API once in the Notis portal.
- 2Create an automation in Automations, New Automation, or tell Notis from any channel.
- 3In one instruction, tell Notis to retrieve account usage and status when the monitored aggregate changes.
- 4Pick the Aggregate Metric Changed trigger and choose where run reports go.
- 5Test with one real metric change.
Questions about this workflow
Does this check usage against a limit?
The action retrieves account information including usage and quota details. Set any comparison threshold in your instruction if you have a known limit.
Which metric should I monitor?
Choose a useful SUM, COUNT, AVG, MIN, or MAX calculation in Sheets that signals a change in your research workload.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Countdown api. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Countdown api actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Clear Collection Requests
Tool to clear all requests from a specified collection. Use when you need to remove all queued requests for an idle collection.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create a new collection
Tool to create a new collection. Use when you need to batch and orchestrate multiple requests on a schedule.
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 Collection
Tool to retrieve details for a single collection by ID. Use when you need collection metadata and counts for a given collection ID.
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.
List Collections
Tool to list all collections for the authenticated account. Use when you need to retrieve paginated collections with filtering, sorting, and timing constraints.
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.
Start Collection
Tool to start processing a collection's queued requests. Use after creating or pausing a collection to initiate its queued requests.
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.
Update an existing collection
Tool to update an existing collection. Use when you need to modify collection settings before scheduling runs.
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.
eBay Autocomplete
Tool to fetch eBay autocomplete suggestions. Use when needing search-term-based suggestions from Countdown API.
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 Destination
Tool to create a destination. Use when you need to set up a new destination for results or notifications.
Connect any two apps with Notis in the middle.
Google Sheets and Countdown api, 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 Countdown api.