I found a cool n8n workflow by a user named 'aliasoblomov' on GitHub, which is worth "studying". It's a workflow to backfill historical GA4 data into BigQuery.
- Take a look at how the developer utilised the GA and BigQuery nodes in a clever way.
- Open GA nodes one by one to see how the various GA4 dimensions and metrics are being used.
- Open BigQuery nodes one by one to see how they are used to execute SQL queries, what SQL queries are being executed, and their purpose.
You can use Claude/ChatGPT to understand the purpose of each SQL Query block.
Essentially, reverse-engineer the entire workflow. It may give you ideas for future development.
You would need an n8n account and a GCP account with a BigQuery project.
The link to download the workflow and other details: https://github.com/aliasoblomov/N8N-GA4-Backfill-Workflow