Keep priority companies on a dependable watchlist
When a company becomes a priority, send that decision into a BigQuery watchlist query so it is easy to find again.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
Query
Query tool will run a sql query in bigquery. note: make sure the query being input in a single line format. for example, select * from sample dataset.sample table where column name = 'value'
Why this helps
High-priority companies can get buried among routine research, especially when prioritization happens in a separate tool.
- Keep priority companies visible in a dedicated review dataset.
- Preserve a useful trail from enrichment to prioritization.
- Spend less time searching for the companies you meant to revisit.
Setup
Build it in a few focused steps.
- 1Connect Companyenrich and Google BigQuery to Notis once in the portal.
- 2Create an automation in the portal or ask Notis to maintain a priority company watchlist.
- 3Describe how the BigQuery query should use each prioritized company payload in one plain-language prompt.
- 4Choose the incoming webhook trigger and a channel for run reports.
- 5Send one real priority-company payload and check the watchlist query outcome.
Questions about this workflow
How does the workflow know a company is a priority?
Your backend should send the company when it meets your chosen prioritization criteria.
Can the query avoid duplicate watchlist entries?
Describe your matching identifier and desired update behavior in the prompt, using fields supported by your dataset.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Companyenrich to Google BigQuery. A trigger fires from one place; an action lands in another.
Companyenrich triggers
Google BigQuery actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Query
Query tool will run a sql query in bigquery. note: make sure the query being input in a single line format. for example, select * from sample dataset.sample table where column name = 'value'
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Connect any two apps with Notis in the middle.
Companyenrich and Google BigQuery, 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 Google BigQuery.