Populate Supabase with n8n integration
Budget: $30 – $250 USD
Rules for this project!
1. All bids that doesn’t involve the word ”Carrot” will be ignored
2. Only bid if you have the knowledge and expertice to successfully finnish this project in time.
3. If you dont understand the project as described then dont bid.
4. Only bid the amount that you are willing to complete the project with.
I need a developer to fetch population data from Statistics Sweden (SCB) — dataset BE0101N1 (population by municipality, age (0–100+), sex, and year 1968–2024) — and load it into a Supabase (Postgres) table. The solution must be well-indexed, and easily queriable from n8n and an AI assistant (ChatGPT). Deliver a working N8N workflow plus documentation.
Scope & Deliverables:
Data Ingestion
Use SCB API endpoint: https://api.scb.se/OV0104/v1/doris/sv/ssd/START/BE/BE0101/BE0101A/BefolkningNy
Query parameters:
Regions: all municipalities
Sex: male (1), female (2)
Age: 0..100 (100+ as top-coded)
Years: 1968–2024
Contents: BE0101N1 (population)
n8n Integration
Provide:
a) An n8n workflow (HTTP Request → transform → Supabase Upsert) with chatGPT inegration.
Documentation
Brief README: how to run, env variables (Supabase URL/keys), how to schedule, and how to extend to new years (e.g., 2025+).
Acceptance Criteria:
Full dataset 1968–2024 successfully stored in Supabase with correct keys and values.
Random spot checks against SCB website confirm correctness.
Re-running the job makes no duplicates (idempotent).
Example n8n query that returns population for a given municipality/year works.
1. All bids that doesn’t involve the word ”Carrot” will be ignored
2. Only bid if you have the knowledge and expertice to successfully finnish this project in time.
3. If you dont understand the project as described then dont bid.
4. Only bid the amount that you are willing to complete the project with.
I need a developer to fetch population data from Statistics Sweden (SCB) — dataset BE0101N1 (population by municipality, age (0–100+), sex, and year 1968–2024) — and load it into a Supabase (Postgres) table. The solution must be well-indexed, and easily queriable from n8n and an AI assistant (ChatGPT). Deliver a working N8N workflow plus documentation.
Scope & Deliverables:
Data Ingestion
Use SCB API endpoint: https://api.scb.se/OV0104/v1/doris/sv/ssd/START/BE/BE0101/BE0101A/BefolkningNy
Query parameters:
Regions: all municipalities
Sex: male (1), female (2)
Age: 0..100 (100+ as top-coded)
Years: 1968–2024
Contents: BE0101N1 (population)
n8n Integration
Provide:
a) An n8n workflow (HTTP Request → transform → Supabase Upsert) with chatGPT inegration.
Documentation
Brief README: how to run, env variables (Supabase URL/keys), how to schedule, and how to extend to new years (e.g., 2025+).
Acceptance Criteria:
Full dataset 1968–2024 successfully stored in Supabase with correct keys and values.
Random spot checks against SCB website confirm correctness.
Re-running the job makes no duplicates (idempotent).
Example n8n query that returns population for a given municipality/year works.