Recheck analyst consensus when your tracking data changes
A change in a watched range can prompt Notis to retrieve Benzinga consensus ratings and price targets for the related ticker, with a concise summary for review.
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 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.
Why this helps
A revised tracking sheet can change a decision context, while analyst consensus remains unchecked in a separate tool.
- Starts a consensus lookup when tracked values change.
- Brings ratings and price targets into a focused run report.
- Supports a more timely review of analyst sentiment.
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 to use the relevant ticker from the changed range to retrieve Benzinga consensus ratings and price targets over the date range you specify, then summarize them.
- 4Pick Cell Range Values Changed as the trigger, then choose where run reports go.
- 5Test with one real range change and verify the ticker and requested date range.
Questions about this workflow
Does the trigger understand which company changed?
The event watches values in a specified range. Include the ticker in the monitored data or tell Notis how to identify it in your prompt.
Does Benzinga provide investment advice?
The action returns analyst ratings and price target data. Treat the report as information for your own review, not individualized investment advice.
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.