Review analyst consensus after a portfolio metric changes
A changing portfolio metric deserves current context. Notis can fetch ratings and price targets when your aggregate moves.
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
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 metric change can trigger decisions before anyone checks whether analyst sentiment also shifted.
- Adds market context to internal metrics
- Highlights rating and target changes
- Creates a repeatable review loop
Setup
Build it in a few focused steps.
- 1Connect Google Super and Benzinga in Notis once.
- 2Create an automation instructing Notis to use the changed aggregate context to retrieve consensus ratings for the relevant tickers.
- 3Pick Aggregate Metric Changed as the trigger.
- 4Choose a report channel and test with one real metric change.
Questions about this workflow
What if the metric does not include tickers?
Ask Notis to report that the lookup needs ticker context instead of guessing.
Which Benzinga data is returned?
The consensus ratings and price targets available for the requested ticker and date range.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Super to Benzinga. A trigger fires from one place; an action lands in another.
Google Super 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.
Attendee Response Changed
Polling trigger that fires when any attendee's RSVP changes to accepted, declined, or tentative. Returns attendee info and current status.
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.
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 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.
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
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.
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 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.
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 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 Super 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.