I need to capture details from all product detail pages that are linked pages linked to in this site map - https://www.selectcarleasing.co.uk/sitemap-vehicles
The top level sitemap links down to 82 lower level sitemaps which then each link to product description pages.
Examples:
Top level sitemap: /sitemap-vehicles Sub-sitemap: /sitemap-derivative-groups?channel_id=car-leasing&page=1 Product Description Page: /car-leasing/hyundai/bayon/suv/10-tgdi-premium-5dr-dct
For each product description page I need the following fields pulled from the URL:
Manufacturer:text Model:text Bodytype: text Derivative: text MIleage: number Term: number
In addition, for each product description I need the following fields scraped from the page:
Initial Payment: number Monthly Payment: number Delivery Status: text
The attached PDF shows where each field can be found.
Data should be output in an excel friendly CSV with URL followed by the fields for that URL.
Meta Ads Lead Generation Category: A / B Testing, Advertising, Content Creation, Conversion Rate Optimization, Digital Marketing, Facebook Marketing, Instagram Marketing, Lead Generation, Social Media Marketing, Video Editing Budget: ₹1500 - ₹12500 INR
23-Feb-2026 11:01 GMT
Vibrant Imagination Book for Toddlers Category: Book Design, Book Writing, Content Writing, Creative Writing, Editing, Fiction, Ghostwriting, Proofreading, Publishing, Writing Tutoring Budget: €30 - €250 EUR
23-Feb-2026 11:01 GMT
Multiplayer Gaming Platform Development Category: Android, Backend Development, Flutter, Game Design, Game Development, Game UI, IOS Development, Mobile App Development, Online Multiplayer Budget: $750 - $1500 USD
23-Feb-2026 11:01 GMT
Lyric Video With Motion Graphics Category: 2D Animation, 3D Animation, Adobe Premiere Pro, After Effects, Animation, Graphic Design, Motion Graphics, Video Editing, Video Production, Video Services Budget: ₹600 - ₹1500 INR
23-Feb-2026 11:01 GMT
Podcast Social Media Manager Category: After Effects, Animation, Content Creation, Content Strategy, Instagram Marketing, Social Media Management, Social Media Marketing, Video Editing, Video Services Budget: €12 - €18 EUR
Facebook Lead Generation Campaign Category: Digital Marketing, Facebook Ads, Facebook Marketing, Google Adwords, Google Analytics, Internet Marketing, Lead Generation, Social Media Marketing Budget: ₹12500 - ₹37500 INR
Craft Arab Justice Advocacy Messaging Category: Content Writing, Copywriting, Public Relations, Research Writing, Social Media Marketing, Translation, Writing Tutoring Budget: $25 - $50 USD
23-Feb-2026 10:58 GMT
GPT Optimization Expert Category: AI (Artificial Intelligence) HW / SW, AI Chatbot Development, AI Model Development, Internet Marketing, PHP, Prompt Engineering, SEO Budget: ₹1500 - ₹12500 INR
23-Feb-2026 10:57 GMT
Excel Data Entry and Statistical Analysis Category: Data Analysis, Data Entry, Data Processing, Data Visualization, Excel, Python, Statistical Analysis, Statistics Budget: $2 - $8 USD
