Track new GitHub issues in Google BigQuery
See what is arriving before it becomes an unmanageable backlog.
Trigger
New Issue Created
Fires when a new issue is created in a GitHub repository.
Action
Query
Runs a SQL query in BigQuery, including statements that can modify data.
Why this helps
New requests can pile up before a founder notices the pattern.
- Preserves every incoming request
- Surfaces recurring customer problems
Setup
Build it in a few focused steps.
- 1Connect GitHub and Google BigQuery to Notis once.
- 2Create a new automation from the Notis portal.
- 3Ask Notis to add each new issue to an issue-intake analysis table.
- 4Select New Issue Created and choose where run reports arrive.
Questions about this workflow
Will pull requests be included?
No. This GitHub trigger is for true issues, not pull requests.
When this happens · Trigger
Fires when a new issue is created in a GitHub repository.
Do this · Action
Runs a SQL query in BigQuery, including statements that can modify data.
Supported Triggers and Actions
Notis builds workflows that link GitHub to Google BigQuery. A trigger fires from one place; an action lands in another.
GitHub triggers
Google BigQuery actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Query
Runs a SQL query in BigQuery, including statements that can modify data.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Cancel BigQuery Job
Requests cancellation of a running BigQuery job; cancellation must be checked and may still incur costs.
New Workflow Artifact Created
Fires when a new GitHub Actions workflow artifact is created in a repository.
Create Capacity Commitment
Creates a capacity commitment to purchase BigQuery compute slots for a committed term.
Branch Changed
Fires when a branch’s commits or protection status or settings change.
Create BigQuery Connection
Creates a BigQuery connection to an external data source.
New Branch Created
Fires when a new branch is created in a GitHub repository.
Create Analytics Hub Listing
Creates an Analytics Hub listing; its dataset must exist in the exchange’s region.
Check Run Status / Conclusion Changed
Fires when a GitHub check run’s status or conclusion changes.
Create BigQuery Dataset
Creates a BigQuery dataset in a specified location.
Check Suite Status / Conclusion Changed
Fires when a GitHub check suite changes status or conclusion for a reference.
Create Analytics Hub Data Exchange
Creates an Analytics Hub data exchange for sharing BigQuery datasets.
New Code Scanning Alert Created
Fires when a new code scanning alert is created in a repository.
Create Analytics Hub Listing
Creates an Analytics Hub listing to publish a BigQuery dataset for subscription.
Connect any two apps with Notis in the middle.
GitHub and Google BigQuery, or any other combination from 1,500+ 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.