Add outside context when a key metric shifts
A changing total or average can be a good moment to check how the wider market looks.
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
Composio Google Search
Perform a google search using the composio google search api.
Why this helps
A metric can move sharply without anyone taking time to investigate external context.
- Pair a changing aggregate with relevant outside research.
- Use the monitored calculation as a timely review cue.
- Summarize returned context alongside the changed metric.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Composio search once in the Notis portal.
- 2Create an automation in Automations, New Automation, or tell Notis from any channel.
- 3In one instruction, ask Notis to search the web for relevant benchmark context when the monitored aggregate changes and summarize findings.
- 4Pick the Aggregate Metric Changed trigger and choose where run reports go.
- 5Test with one real aggregate metric change.
Questions about this workflow
Which calculations can trigger this?
The trigger supports SUM, COUNT, AVG, MIN, or MAX on a target column, optionally filtered by a search column and value.
Does the search return comparable benchmarks automatically?
Only if your instruction provides a clear industry, geography, and metric definition. Search results may not use the same methodology.
Can I treat search results as verified benchmarks?
Review sources and definitions before comparing them to your metric.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Composio search. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Composio search actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Composio DuckDuckGo Search
The duckduckgosearch class utilizes the composio duckduckgo search api to perform searches, focusing on web information and details. it leverages the duckduckgo search engine via the composio duckduckgo search api to retrieve relevant web data based on the provided query.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Composio Google Events Search
The eventsearch class enables scraping of google events search queries. it conducts an event search using the composio events search api, retrieving information on events such as concerts, festivals, and other activities based on the provided query.
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.
Exa Answer
Get answers with citations using the exa api.
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.
Composio Similarlinks
Perform a search to find similar links and retrieve a list of relevant results. the search can optionally return contents.
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.
Composio Finance Search
The financesearch class utilizes the composio finance search api to conduct financial searches, focusing on financial data and stock information. it leverages the google finance search engine via the composio finance search api to retrieve pertinent financial details based on the provided query.
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.
Composio Google Maps Search
The googlemapssearch class performs a location-specific search using the composio goolge maps search api. this class extends the functionality of the base action class to specifically target locations related to the given query. by utilizing the google maps search engine through the composio goolge maps search api, it fetches the most relevant location data based on the input query. the `googlemapssearch` class is particularly useful for applications that need to retrieve and display location information about a specific area. it leverages the powerful search capabilities of google's maps search engine, ensuring that the returned results are accurate and relevant.
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.
Composio Image Search
The imagesearch class performs an image search using the composio image search api, to target image data and information. it uses the google images search engine through the composio image search api to fetch relevant image information based on the input query.
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.
Composio News Search
The newssearch class performs a news-specific search using the composio news search api. this class extends the functionality of the base action class to specifically target news articles related to the given query. by utilizing the google news search engine through the composio news search api, it fetches the most relevant news articles based on the input query. the `newssearch` class is particularly useful for applications that need to retrieve and display the latest news articles about a specific topic. it leverages the powerful search capabilities of google's news search engine, ensuring that the returned results are current and relevant.
Connect any two apps with Notis in the middle.
Google Sheets and Composio search, 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 Composio search.