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.