Check US listing status as research files arrive
Add a listing status check to a Drive research flow and surface whether a named US stock or ETF is active or delisted.
Trigger
New File Matching Query
Triggers when a new Google Drive file matches a provided query. This is the legacy query-centric trigger: it preserves Drive API query config such as ``corpora`` / ``driveId`` aliases and emits the historical ``file_matching_query`` event type. ``FileCreatedTrigger`` covers the broader "new file" case and emits ``file_created``.
Action
Listing Status
Tool to fetch listing status of us stocks and etfs. use when you need active or delisted securities as of a date.
Why this helps
Research can proceed on an outdated assumption that a security is still actively listed.
- Check active or delisted status for explicitly named US stocks and ETFs.
- Use new matching research files as a consistent check point.
- Flag symbols that need clarification before lookup.
Setup
Build it in a few focused steps.
- 1Connect Google Drive and Alpha Vantage once in the Notis portal.
- 2Create an automation in the portal or tell Notis from any channel what outcome you want.
- 3In one instruction, ask Notis to identify US stock or ETF symbols in the matching file, fetch listing status, and summarize the result.
- 4Pick the Google Drive New File Matching Query trigger and choose where run reports should go.
- 5Test with one real matching file containing a known US stock or ETF symbol.
Questions about this workflow
Does listing status cover every global security?
The listed action fetches listing status of US stocks and ETFs. It is not described as a global listing status lookup.
Can it decide if a security is appropriate for my portfolio?
It reports listing status, such as active or delisted. Portfolio suitability criteria are outside the action and must be supplied separately.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Drive to Alpha vantage. A trigger fires from one place; an action lands in another.
Google Drive triggers
Alpha vantage actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Get All Commodities Price Index
Tool to retrieve the global price index of all commodities. use when you need monthly, quarterly, or annual aggregated price index data for commodities.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
ALUMINUM
Tool to fetch global aluminum prices. use when you need monthly, quarterly, or annual lme aluminum price data.
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
Balance Sheet
Tool to return annual and quarterly balance sheets for a company. use when you need detailed fiscal statements for analysis.
File Created
Triggers when a new file is created in Google Drive.
Brent Crude Oil Prices
Tool to fetch brent crude oil prices. use when you need daily, weekly, or monthly brent price data.
File Deleted or Trashed
Triggers when a file is moved to trash or permanently deleted in Drive.
Global Coffee Price
Tool to retrieve the global coffee price series. use when you need historical monthly, quarterly, or annual coffee prices.
File Shared (Permissions Added)
Triggers when new sharing permissions are granted to a file or folder. Uses Drive's `changes.list` endpoint with inline `permissions` in the `fields` mask so each change carries the file's current permission set provider-atomically. We diff that against `seen_permission_keys` to identify newly added grants. Drive page tokens are the primary cursor; if Drive rejects a stored token, the trigger raises `PollingTriggerError` without clearing state rather than silently re-baselining and dropping events. Limitation: truly ephemeral permissions (added and revoked between two polls without any other file modification in between) are not detected. Drive Activity API would catch those but requires an additional OAuth scope and a different payload contract.
COPPER
Tool to fetch global price of copper in monthly, quarterly, and annual intervals. use when you need historical copper price series for analysis.
File Updated
Triggers when a file's metadata or content changes in Google Drive.
Corn
Tool to retrieve global price of corn in monthly, quarterly, and annual intervals. use after verifying api key when you need historical corn price data.
Google Drive Changes
Triggers when changes are detected in a Google Drive.
COTTON
Tool to retrieve global cotton prices in monthly, quarterly, and annual intervals. use when you need historical cotton price data.
Connect any two apps with Notis in the middle.
Google Drive and Alpha vantage, 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 Alpha vantage.