TL;DR Short answer: Whisky Hunter ETL tools load whisky auction statistics from WhiskyHunter.net into a warehouse, sheet or notebook for collectors, investors and analysts. The API is free and needs no key, and Airbyte has a Whisky Hunter connector with auction and distillery streams. It is a small, niche source, so check that it is responding before you build on it, and refresh daily at most. Six Whisky Hunter ETL tools compared:
Airbyte dlt Custom Python Google Sheets with Apps Script n8n Make The Whisky Hunter constraint: the API is a small, independent service that publishes summary statistics rather than every lot, so refresh at most daily and add a check that it is responding. Whisky Hunter ETL tools move data from WhiskyHunter.net, which tracks online whisky auctions, into a warehouse, database or spreadsheet. The API publishes statistics about past auctions, such as volumes and prices, along with information about auctions and distilleries, which collectors and analysts use to follow the secondary whisky market. For other public data sources, see our guide to Alpha Vantage ETL tools .
Is the Whisky Hunter API still available? Whisky Hunter is a small, independent service, and third-party monitors have recorded timeouts on its site, so check that the API responds before scheduling syncs. Airbyte's connector has had only maintenance updates since its 2022 release, which is typical for a stable, simple API but means you should test it before relying on it.
If the API is unavailable, the same market data exists on auction houses' own sites, but collecting it means scraping, which needs care with each site's terms.
Every tool here reads the same public API, with no key required. The main data is:
Auction statistics: trading volumes, lots and price statistics for past auctions. Auction information: metadata about recurring and one-off online whisky auctions. Distillery information: details about the distilleries whose bottles appear at auction. How do the Whisky Hunter ETL tools compare? Tool Approach Destinations Best for Cost Airbyte Pre-built connector Any warehouse, lake or database Auction data next to other sources Free self-hosted Core; paid Cloud plans dlt Python REST API source DuckDB, BigQuery, Snowflake, Postgres and more Python teams loading a warehouse Free, open source Custom Python Direct API calls Wherever you write it Research and charts Free, engineering time Apps Script Script with a time trigger Google Sheets Collectors tracking a few auctions Free with Google Workspace n8n HTTP Request node Databases, sheets, apps Scheduled checks with alerts Free self-hosted; paid cloud Make HTTP module in scenarios Sheets, databases, apps No-code pulls Operations-based, free tier
Which Whisky Hunter ETL tools should you consider? Six Whisky Hunter ETL tools, from a pre-built connector to spreadsheets:
1. Airbyte Airbyte is the open-source data connectivity platform for AI and analytics, and among Whisky Hunter ETL tools it is the one with a pre-built connector. Its Whisky Hunter source syncs three streams, auction data, auction information and distillery information, with no credentials needed, and Airbyte recommends syncing every 24 hours or less often. For more ELT options, see our guide to ELT tools .
Airbyte runs in Airbyte Cloud, in your own environment with Airbyte Flex, or self-hosted with Airbyte Core.
Pros Cons Pre-built connector, no key needed Connector has had only maintenance updates Auction data next to other sources Depends on a small independent API Cloud, Flex or self-hosted Core Summary statistics, not every lot
2. dlt dlt is an open-source Python library for loading data. Its REST API source can call Whisky Hunter's endpoints and load the JSON into DuckDB, BigQuery, Snowflake or Postgres with schema inference. For more code-first options, see our guide to Python ETL tools .
Pros Cons Schema inference from JSON You write and schedule the pipeline Loads to many destinations Requires Python skills Free and open source API changes are yours to handle
3. Custom Python Calling the API with Python's requests library and loading results into pandas is the quickest route for research and price charts. You control storage and history. For other API pipelines, see our guide to REST API ETL tools .
Pros Cons Full control over requests Not a pipeline: scheduling is up to you Easy charts with pandas Storage and history are yours No licence cost Ongoing maintenance
4. Google Sheets with Apps Script A short Apps Script function can call the API with UrlFetchApp and write auction statistics into a sheet, with a daily trigger. It suits collectors tracking a few auctions. For more spreadsheet pipelines, see our guide to Google Sheets ETL tools .
Pros Cons Free with Google Workspace Not suited to long history Easy to share and chart Apps Script quotas limit run time No extra tools needed Errors are easy to miss without alerting
5. n8n n8n can call the API on a schedule, store new figures in a database or sheet, and alert you if the API stops responding, which matters for a small independent source.
Pros Cons Self-hosting option You run and maintain it if self-hosted Easy health checks and alerts Not built for large backfills Hundreds of destination integrations Response handling is yours to add
6. Make Make calls the API through its HTTP module inside a scheduled scenario and routes auction statistics to sheets, databases or messaging tools, without code.
Pros Cons No-code and quick to set up Operations-based pricing adds up Easy routing to many apps Not designed for warehouse loading Free tier to start Complex scenarios become hard to maintain
What should you check before syncing Whisky Hunter data? Whichever tool you choose, check these first:
Availability: test that the API responds before scheduling syncs, and alert if it stops.Refresh frequency: sync daily at most, since auction statistics change slowly.Granularity: the API publishes summary statistics, not every lot, so check it answers your question.Currencies: auctions report prices in different currencies, so normalise them before comparing.Fair use: the API is free and run independently, so keep request volumes modest.Which Whisky Hunter ETL tool should you choose? Choosing between Whisky Hunter ETL tools comes down to where the data is going. For auction data next to other sources in a warehouse, use Airbyte or dlt. For research and charts, custom Python is quickest, and Apps Script, n8n or Make suit collectors tracking a few auctions. If the API is unavailable, see our guide to web scraping tools , with care for each site's terms.
Load whisky auction data with Airbyte Sync Whisky Hunter auction and distillery data into the same warehouse as your other data with Airbyte, in Airbyte Cloud, in your own environment with Airbyte Flex, or self-hosted with Airbyte Core.
Try Airbyte Cloud free for 14 days or talk to our team .
Frequently Asked Questions (FAQs) 1. What are the best Whisky Hunter ETL tools? Airbyte has a pre-built Whisky Hunter connector for loading auction and distillery data into a warehouse, and dlt or custom Python suit code-first users. Google Sheets with Apps Script, n8n and Make suit collectors tracking a few auctions.
2. Do I need an API key for Whisky Hunter? No. The Whisky Hunter API is free and needs no key or account. Keep request volumes modest, since it is a small, independently run service.
3. What data does the Whisky Hunter API provide? It provides statistics about past online whisky auctions, information about recurring and one-off auctions, and details about distilleries. It publishes summary statistics rather than every individual lot.
4. What if the Whisky Hunter API is down? Check again later and add an alert to your pipeline. Auction houses publish results on their own sites, but collecting those means scraping, which needs care with each site's terms.
Suggested reads Alpha Vantage ETL Tools
Web Scraping Tools
REST API ETL Tools
Data Ingestion Tools
.webp)