ARTICLE AD BOX
I’m trying to scrape opening and closing hours (Monday to Sunday) for about 2000 clinic entries.
I already have a CSV file with ~20,00 rows containing the clinic name and clinic country.
My goal is:
For each clinic, search Google (or another reliable source)
Extract the weekly opening hours
Export the results into a CSV/JSON file
I have a free SerpAPI key, and I also tried basic web scraping in Python, but neither approach worked reliably. With SerpAPI I ran into incomplete results and rate-limit issues, and with Python scraping I wasn’t able to get consistent or structured opening-hours data.
My questions:
Is SerpAPI the right tool for scraping thousands of opening-hours records, or is there a better API/service for this?
Is it realistic to extract accurate opening hours for each clinic using the free SerpAPI plan?
How should I structure my script (Python/Node.js) to handle thousands of queries without hitting API limits?
Are there alternative APIs, crawling methods, or data providers better suited for this kind of large-scale hours lookup?
Any advice, working examples, or recommended approaches would be greatly appreciated.
