Review Affinda usage when your tracked metric changes
When a spreadsheet metric shifts, pull the workspace usage data into the same operational review.
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 Usage by Workspace
Tool to retrieve monthly credits consumption for a workspace. use when tracking usage over a specific period before reporting.
Why this helps
Usage checks are easy to postpone when they live outside the spreadsheet where workload trends are tracked.
- Use a meaningful metric change to prompt a usage check.
- Retrieve monthly credit consumption for a workspace.
- Keep operational review reports connected to existing tracking.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Affinda once in the Notis portal.
- 2Create an automation and describe which monitored metric change should prompt an Affinda workspace usage lookup.
- 3Pick the Aggregate Metric Changed trigger and choose where run reports should go.
- 4Test with one real metric change and confirm the workspace and reporting period are clear.
Questions about this workflow
Does the trigger itself provide Affinda usage?
No. The Google Sheets trigger detects an aggregate change; the Affinda action retrieves monthly credit consumption for a workspace.
What workspace information is needed?
The automation needs enough context to identify the Affinda workspace whose usage should be retrieved.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Affinda. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Affinda actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Batch Update Annotations
Tool to update multiple annotations in one request. use when you need to modify parsed values or other fields across many annotations at once.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create Collection
Tool to create a new collection. use after you have a valid workspace id and want to group documents by a specific extractor within that workspace.
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 Document
Tool to upload a new document for parsing. use when you have the document file or a public url and need to extract structured data immediately.
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 Organization
Tool to create a new organization. use when you have a unique organization name and want to group resources under it.
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 RESTHook Subscription
Tool to create a new resthook subscription. use after confirming your webhook endpoint is ready to receive document event notifications.
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 Tag
Tool to create a new tag. use when you need to label documents in a specific workspace.
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 Validation Result
Tool to create a validation result. use when recording validation outcomes for a document after parsing.
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 Workspace
Tool to create a new workspace. use when you need to programmatically create a workspace container within an organization.
Connect any two apps with Notis in the middle.
Google Sheets and Affinda, 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 Affinda.