Get context when spreadsheet settings change
When a spreadsheet's top-level settings change, get a researched answer to the question behind the change.
Trigger
Spreadsheet Properties Changed
Polling trigger that detects when a Google Spreadsheet's top-level properties change. Monitors properties such as title, locale, timeZone, and autoRecalc settings.
Action
Composio LLM Search
The composio llm search class serves as a gateway to the composio llm search api, allowing users to perform searches across a broad range of content with multiple filtering options. it accommodates complex queries, including both keyword and phrase searches, with additional parameters to fine-tune the search results. this class enables a tailored search experience by allowing users to specify the search depth, include images and direct answers, apply domain-specific filters, and control the number of results returned. it is designed to meet various search requirements, from quick lookups to in-depth research.
Why this helps
A setting change can leave collaborators unsure about its implications or next steps.
- Connect a settings update with a specific research question.
- Find supporting context without interrupting the setup task.
- Review citations returned with the answer.
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 for an answer to your chosen question using the changed spreadsheet properties as context.
- 4Pick the Spreadsheet Properties Changed trigger and choose where run reports go.
- 5Test with one real property change and review the answer.
Questions about this workflow
Which properties does this trigger watch?
It monitors top-level properties such as title, locale, time zone, and automatic recalculation settings.
What question should I use?
Choose a question that can be informed by the settings that may change, such as a relevant locale or time zone consideration.
Are search citations proof that an answer is correct?
No. Review each citation and verify important conclusions against authoritative sources.
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.