Check for cancelled market calendar events after a sheet update
When a watched range changes, Notis can check Benzinga's removed events data and summarize calendar items cancelled in the time window you specify.
Trigger
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.
Action
Get Removed
Tool to retrieve removed or cancelled calendar events. use when you need to identify calendar items removed for specific event types or filtered by removal timestamp.
Why this helps
A planning sheet can change while a cancelled event remains on a separate calendar or event list.
- Checks for removed or cancelled events after tracked data changes.
- Lets the prompt specify event types and removal time filters.
- Helps keep event planning current.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Benzinga once in the Notis portal.
- 2Create an automation in Automations, New Automation, and enter a name and prompt.
- 3Tell Notis which Benzinga event types and removal time window to check when the range changes, then ask for a concise summary.
- 4Pick Cell Range Values Changed as the trigger, then choose where run reports go.
- 5Test with one real range update and review the returned removed events.
Questions about this workflow
What can the removed events action retrieve?
It retrieves removed or cancelled calendar events for specific event types and filters such as removal timestamp.
Does a sheet change tell Notis which calendar events were cancelled?
No. The sheet change starts the workflow. Your instruction should state which event types and removal time window Benzinga should query.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Benzinga. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Benzinga actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Get Calendar Earnings Stream
Tool to subscribe to real-time earnings calendar events via websocket. use when you need immediate updates as reports are announced.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Conference Calls
Tool to retrieve upcoming and historical conference call details such as times, tickers, and webcast urls. use when filtering conference calls by date range or ticker symbols.
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.
Get Consensus Ratings
Tool to get consensus analyst ratings and price targets for a specified ticker over a date range. use when you need to gauge analyst sentiment and target price consensus for investment decisions.
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.
Get Earnings Calendar V2.1
Tool to retrieve earnings calendar data (v2.1). use when you need dates, estimates, and actuals for upcoming earnings events.
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.
Get Economics
Tool to retrieve economic calendar events including actual, consensus, and prior values and importance. use when filtering by date, country, importance, or updated timestamp.
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.
Get Newsfeed Stream
Tool to stream real-time news events via websocket. use when you need immediate updates to news as they are created, updated, or removed.
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 Analyst Ratings
Tool to fetch analyst ratings calendar data including rating actions, price targets, and analyst details. use when querying upcoming or historical analyst ratings.
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 Removed
Tool to retrieve removed or cancelled calendar events. use when you need to identify calendar items removed for specific event types or filtered by removal timestamp.
Connect any two apps with Notis in the middle.
Google Sheets and Benzinga, 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 Benzinga.