See analyst rating actions for companies you add
Each new ticker can prompt a Benzinga analyst ratings lookup, helping you review rating actions, targets, and analyst details as part of your company research.
Trigger
New Rows in Google Sheet
Simple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new sheet entries.
Action
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.
Why this helps
Tracking a new company often means another manual search for recent analyst rating activity.
- Checks analyst rating calendar data when a company is added.
- Surfaces rating actions and price target details for review.
- Keeps new company research in one run report.
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 each new row's ticker to retrieve Benzinga analyst rating actions, price targets, and analyst details, then summarize the results.
- 4Pick New Rows in Google Sheet as the trigger, then choose where run reports go.
- 5Test with one real ticker and review the returned rating details.
Questions about this workflow
What does the ratings action return?
It fetches analyst ratings calendar data, including rating actions, price targets, and analyst details.
Can I limit the research period?
Specify the relevant date window in your instruction to Notis. The action supports upcoming or historical analyst ratings.
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.