Automate monthly CrUX report transfer from BigQuery to NocoDB with data cleanup
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 9 nodes and runs on a schedule (every month at 12:00) (plus 1 other trigger). Along the way it connects Google BigQuery and NocoDB.
How it runs
Trigger: On a schedule (every month at 12:00) (plus 1 other trigger).
- Convert month name to number (Code): runs custom JavaScript code
- Get Last Month Data (NocoDB): get many
- Edit Fields (Edit Fields (Set)): sets 1 field: table
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Google BigQuery: uses Google BigQuery
- Delete in NocoDB (NocoDB): delete
- Append Crux Data into NocoDB (NocoDB): create
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Google BigQuery
n8n-nodes-base.googleBigQuery - NocoDB
n8n-nodes-base.nocoDb - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
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…