Log GitHub commits in Google BigQuery
Keep a searchable history of delivery without maintaining a manual tracker.
Trigger
Commit Event
Triggers when a commit is pushed to a repository.
Action
Query
Runs a SQL query in BigQuery, including statements that can modify data.
Why this helps
Commit patterns disappear into GitHub when no one has time to compile them.
- Creates a consistent delivery dataset
- Makes weekly progress easier to review
Setup
Build it in a few focused steps.
- 1Connect GitHub and Google BigQuery to Notis once.
- 2Open Automations and create a new automation.
- 3Write a plain-language prompt to record each pushed commit for reporting.
- 4Choose the Commit Event trigger and a channel for run reports.
Questions about this workflow
Does this require field mapping?
No. Describe the commit record you want in one prompt and Notis handles the work.
When this happens · Trigger
Triggers when a commit is pushed to a 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.