Filter Capsule accounts from Sheet query changes
Move from changing data to the accounts that need a decision.
Trigger
Table Query Result Changed
Triggers when the result set of a saved table query changes in Google Sheets. Detects rows added, removed, or updated in the query output. This trigger monitors the result of a SQL query against a Google Sheets table and fires when changes are detected.
Action
Run Filter Query
Tool to run structured filter queries on parties, opportunities or kases. use when you need to retrieve entities matching specific filter conditions.
Why this helps
Query results change, but finding the affected customer records still takes a separate manual search.
- Identify affected accounts quickly
- Reduce cross tool searching
- Support faster decisions
Setup
Build it in a few focused steps.
- 1Connect Google Super and Capsule CRM once in Notis.
- 2Create an automation that translates the changed query context into a Capsule filter query and summarizes matching accounts.
- 3Pick the Table Query Result Changed trigger.
- 4Choose a report channel.
- 5Test with one real query result change.
Questions about this workflow
Can the filter use custom business rules?
Yes. Describe the party or opportunity conditions that define an affected account.
What if the query result does not identify an account?
Ask Notis to report the unmatched rows for review.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Super to Capsule crm. A trigger fires from one place; an action lands in another.
Google Super triggers
Capsule crm actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Capsule CRM Party
Tool to create a party in capsule crm. use when you have collected a person's or organisation's details and need to add a new record.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Delete Party
Tool to fully delete a specific party (person or organisation) from capsule crm. use when you need to completely remove a party after confirming no active references remain.
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.
List Deleted Opportunities
Tool to list opportunities deleted or restricted since a given date. use when you need to identify recently deleted or restricted opportunities.
Attendee Response Changed
Polling trigger that fires when any attendee's RSVP changes to accepted, declined, or tentative. Returns attendee info and current status.
List deleted parties
Tool to retrieve parties deleted since a given date. use when you need to sync deletions.
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 Entries By Date
Tool to list notes, emails, and completed party tasks in descending order by entry date. use when you need the most recent entries first after authenticating.
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
List Organisation Employees
Tool to list employees linked to a specific organisation (party). use when you need to retrieve all employees under a given organisation.
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.
List Parties
Tool to list all parties (contacts) on the account. use when you need to fetch contacts with optional filters or embed additional related data.
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.
List Projects
Tool to list projects (cases) from capsule crm. use when you need a paginated or filtered view of projects.
Connect any two apps with Notis in the middle.
Google Super and Capsule crm, 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 Capsule crm.