Check link inventory when a planning metric changes
When a tracked total changes, get a fresh count of Dub links matching your chosen filter and see the numbers together in a run report.
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 Links Count
Tool to retrieve the count of links in workspace with optional filters. Use when you need to get the total number of links matching specific criteria such as domain, tags, folder, or search terms.
Why this helps
A changing campaign total and a separate link inventory can make it harder to spot a planning gap.
- Run a fresh Dub count when a monitored aggregate changes.
- Compare the returned count with the changed metric in the automation report.
- Spot discrepancies without opening both tools for a manual check.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Dub once in the Notis portal.
- 2Create an automation in Automations, New Automation, or tell Notis to create it from any channel.
- 3Describe the Dub link filter to count and ask Notis to report the changed spreadsheet metric alongside the returned count.
- 4Pick Aggregate Metric Changed as the trigger and choose where run reports should go.
- 5Test with one real metric change and confirm the count and metric are clear in the report.
Questions about this workflow
Does this count links automatically filtered by the sheet?
The action supports optional Dub filters. Describe a filter Notis can determine from the available trigger data or your instruction; otherwise use a fixed filter or an unfiltered count.
Does the workflow change any links?
No. It retrieves a count and reports it; it does not update link records.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Dub. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Dub actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Bulk Delete Links
Tool to delete multiple short links in bulk from Dub. Use when you need to remove multiple links at once. Maximum of 100 link IDs per request. Non-existing IDs are silently ignored.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Bulk Update Links
Tool to update multiple short links in bulk. Use when you need to apply the same updates to multiple links at once by specifying link IDs or external IDs.
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 Domain
Tool to add a domain to a Dub workspace. Use when you need to create a new domain for shortening links. The domain must be verified before it can be used for link shortening.
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 Tag
Tool to create a new tag in Dub. Use when you need to organize links by creating custom tags. Tags help categorize and filter links for better organization.
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.
Delete Domain
Tool to delete a domain from your Dub workspace. Use when you need to permanently remove a domain. The domain must exist and be owned by your workspace.
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.
Delete Tag
Tool to delete a tag from Dub. Use when you need to remove a tag that is no longer needed.
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.
Get Link Info
Tool to retrieve details of a specific short link from Dub. Use when you need to get comprehensive information about a link including its configuration, targeting settings, and performance metrics.
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.
Get Links
Tool to retrieve a paginated list of links for the authenticated workspace. Use when you need to list links with optional filtering by domain, tags, folder, search terms, or user. Supports pagination and sorting for efficient retrieval of large link collections.
Connect any two apps with Notis in the middle.
Google Sheets and Dub, 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 Dub.