See llms.txt for all machine-readable content.

Google BigQuery and NocoDB integration

Save yourself the work of writing custom integrations for Google BigQuery and NocoDB and use n8n instead. Build adaptable and scalable Data & Storage, Development, workflows that work with your technology stack. All within a building experience you will love.

How to connect Google BigQuery and NocoDB

Create a new workflow and add the first step

In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.

Google BigQuery and NocoDB integration: Create a new workflow and add the first step

Automate monthly CrUX report transfer from BigQuery to NocoDB with data cleanup

Overview This n8n workflow automatically retrieves the monthly CrUX (Chrome User Experience) Report from Google BigQuery and updates the data in NocoDB. It removes the previous month’s data before inserting the new dataset, ensuring your database always contains the latest CrUX rankings for website origins. The flow is fully automated, using schedule triggers to handle both data cleanup and data insertion each month. ✅ Tasks ⏰ Runs automatically on a monthly schedule 🔢 Converts the month name to a numeric value for table selection 🧹 Deletes last month’s CrUX data from NocoDB 🌐 Queries Google BigQuery for the latest monthly dataset 💾 Inserts the new CrUX rankings into NocoDB ⚙️ Keeps your database up to date with zero manual effort 🛠 How to Use 1️⃣ Set Up BigQuery Access Connect your Google BigQuery credentials. Make sure your project includes access to the chrome-ux-report public dataset. 2️⃣ Adjust the Query In the Google BigQuery node, change the LIMIT value to control how many top-ranked sites are retrieved. Ensure the {{ $json.table }} field correctly references the dataset for the desired month (e.g., 202509). 3️⃣ Prepare NocoDB Table Create a table in NocoDB with fields: origin, crux_rank, and any additional metadata you wish to track. 4️⃣ Schedule Automation The workflow includes two Schedule Trigger nodes: One runs the data cleanup process (deletes last month). One runs the data insertion for the new month. 5️⃣ Run or Activate the Workflow Activate it to run automatically each month. You can also run it manually to refresh data on demand. 📋 Prerequisites Before running this workflow, make sure you complete the following setup steps: 🧱 Enable BigQuery API Go to Google Cloud Console → APIs & Services Enable the BigQuery API for your project. 📊 Access the Chrome UX Report Dataset In BigQuery, search for “Chrome UX Report” in the Marketplace or go directly to: https://console.cloud.google.com/marketplace/product/chrome-ux-report/chrome-ux-report Click “View Dataset” and add it to your BigQuery project. 🔑 Connect BigQuery to n8n In n8n, create credentials for your Google BigQuery account using Service Account Authentication. Ensure the account has permission to query the chrome-ux-report dataset. 🗄️ Create a NocoDB Table In NocoDB, create a new table to store your CrUX data with the following fields: origin → Short text crux_rank → Number ⚙️ Connect NocoDB to n8n Use your NocoDB API Token to connect and allow the workflow to read/write data. What is CrUX Rank? CrUX Rank (Chrome User Experience Rank) is a metric from Google’s Chrome UX Report (CrUX) dataset that indicates a website’s popularity based on real user visits. It reflects how frequently an origin (website) is loaded by Chrome users around the world. A lower rank number means the site is more popular (e.g., rank 1 = top site). The data is collected from anonymized Chrome usage statistics, aggregated monthly. This rank helps you track site popularity trends and compare your domain’s visibility over time.

Popular ways to use the Google BigQuery and NocoDB integration

Build your own Google BigQuery and NocoDB integration

Create custom Google BigQuery and NocoDB workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.

Google BigQuery supported actions

NocoDB supported actions

Google BigQuery and NocoDB integration details

Google BigQuery

Google BigQuery

Many businesses use the Google Cloud service BigQuery for data reporting. BigQuery is categorized as an Advanced Data Connector. The amount of data that needs to be processed could be quite large (up to 10,000 columns and tens of millions of rows).

NocoDB

NocoDB

NocoDB is an Airtable alternative. It is an open-source No-Code platform that works by connecting to any relational database and transforming them into a spreadsheet interface. It is used by over 2000 organizations worldwide.

Save engineering resources

Reduce time spent on customer integrations, engineer faster POCs, keep your customer-specific functionality separate from product all without having to code.

Learn more

FAQ about Google BigQuery integrations

Need help setting up your Google BigQuery and NocoDB integration?

Discover our latest community's recommendations and join the discussions about Google BigQuery and NocoDB integration.

  • Alex Kim

    No path back to referenced node

    Alex Kim

    I’m working, on what I thought would be a very simple workflow, but have been lost for hours trying to remove duplicates when comparing a RSS Feed and items in NocoDB. Describe the problem/error/question Why can’t I com…

    Open topic
  • JOduMonT

    Why; wHy whY... Why NoCoDB don't have Create/Update like AirTable and Google Sheets?

    JOduMonT

    Hi; maybe it’s me I don’t understand the background of API but why AirTable and Google Sheets node allow us to do Create/Append or Update a record/row while NoCoDB and BaseRow don’t. From a philosophical point of view…

    Open topic
  • Luc Berge

    Unable to add NocoDB Cloud credentials

    Luc Berge

    Describe the problem/error/question I am trying to add NocoDB cloud credentials in N8n but I do not succeed. i guess I am doing something wrong but what ? I follow this steps : NocoDB credentials | n8n Docs I create m…

    Open topic

Looking to integrate Slack and VirusTotal in your company?

Three colleagues talking around laptops at a shared desk

Trusted by teams building smarter workflows.

Why

Why use n8n to integrate Google BigQuery with NocoDB

Handle branching, merging and iteration easily. Pause your workflow to wait for external events.

Re-run single steps to test changes in no time. And pin your data to avoid generating trigger events every time you execute.

Your data is displayed alongside your settings, making edge cases easy to track down.

Use 1000+ workflow templates available from our core team and our community.

Copy and paste, easily import and export workflows.

Simple enough to 
understand + sophisticated 
enough to ship

Man in a brown jacket working at his desk by a window