Review economic events when your spreadsheet setup changes
A change to a spreadsheet's title, locale, time zone, or recalculation settings can start a Benzinga calendar check using the country and date criteria in your prompt.
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
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.
Why this helps
A spreadsheet context change can signal a new reporting setup, but related economic events still require a separate search.
- Starts a calendar review when spreadsheet properties change.
- Lets the prompt define date, country, or importance criteria.
- Sends the returned event context to a selected report channel.
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 economic calendar date, country, or importance criteria to retrieve from Benzinga when the spreadsheet properties change.
- 4Pick Spreadsheet Properties Changed as the trigger, then choose where run reports go.
- 5Test with one real properties change and review the calendar summary.
Questions about this workflow
Which property changes can trigger this?
The event monitors top-level properties such as title, locale, time zone, and autoRecalc settings.
Does changing locale automatically choose the economic country?
The event detects a property change. State the country you want Notis to use in the automation instruction.
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.