Scrape Store Data Spreadsheet

I have an up-to-date list of stores that we already supply to, but the details on my end are incomplete. I need you to go through Supplier A website and pull every location’s name, full street address, opening hours, as well as its exact longitude and latitude.

Once gathered, enter everything neatly into my existing spreadsheet so the data can be dropped straight into our “Find a Store” feature. Accuracy is crucial because the coordinates will feed our map and the hours will appear on the store profile pages.

Deliverables:
• One spreadsheet (Excel or Google Sheets) containing:
 – Store name
 – Street address (with city, state, postcode)
 – Opening hours in a clear format (e.g., “Mon-Fri 9 am-6 pm”)
 – Longitude and latitude in separate columns

I will provide the current sheet template; you only need to append the missing rows. Feel free to use Python, BeautifulSoup, Selenium, or any other scraping stack you prefer—just make sure the final data is complete and consistent.

Before handing over the file, please do a quick sanity check (spot-check at least 10 random locations) to confirm that the map pins line up correctly on Google Maps.

See our current documebt that we have populated around 80 stores in, There are about 800 stores in total so another 700+ to do.