Analyze GitHub pull request reviews in Google BigQuery
Turn review feedback into patterns you can act on.
Trigger
Pull Request Review Submitted
Fires when a review is submitted for a GitHub pull request.
Action
Query
Runs a SQL query in BigQuery, including statements that can modify data.
Why this helps
Repeated review churn is hard to recognize across busy projects.
- Highlights review bottlenecks
- Creates evidence for process improvements
Setup
Build it in a few focused steps.
- 1Connect GitHub and Google BigQuery to Notis once.
- 2Create an automation in the portal or ask Notis conversationally.
- 3Tell Notis to store submitted review activity for trend analysis.
- 4Select Pull Request Review Submitted and choose a reporting channel.
Questions about this workflow
Can Notis distinguish review outcomes?
Describe the analysis you need in your prompt; Notis uses the review event details.
When this happens · Trigger
Fires when a review is submitted for a GitHub pull request.
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.