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.
Abstract Textured Artwork Category: 3D Modelling, Adobe Illustrator, Photoshop, Art Consulting, Digital Art, Graphic Design, Illustration Budget: $30 - $250 USD
22-Jan-2026 16:56 GMT
Architectural Sections Drafting Category: 2D Drafting, 3D Drafting, AutoCAD, Building Architecture, CAD / CAM, Home Design, Kitchen, Millwork Budget: $25 - $50 USD
22-Jan-2026 16:56 GMT
Complete Classplus LMS Setup Category: Content Management System (CMS), Data Integration, HTML, MySQL, Payment Gateway Integration, PHP, Project Management, Web Design Budget: ₹12500 - ₹37500 INR
22-Jan-2026 16:55 GMT
Data Entry Specialist Needed Category: Data Analytics, Data Entry, Data Management, Google Sheets, Internet Research, Web Search, WordPress Budget: $25 - $50 USD
Photograph & Upload Zomato Menu Category: After Effects, Image Processing, Lighting Design, Menu Design, Photo Editing, Photography, Photoshop Budget: ₹600 - ₹1500 INR
22-Jan-2026 16:55 GMT
Email Data Extraction and Automation Category: Automation, Data Extraction, Data Integration, Data Processing, Data Scraping, Email Handling, Excel, Make.com, PHP, Web Scraping Budget: £20 - £250 GBP
Accurate Bank Data Entry Category: Bookkeeping, Data Analysis, Data Cleansing, Data Entry, Data Extraction, Data Management, Data Processing, Excel, Excel VBA, PDF Budget: $15 - $25 USD
Google Ads Suspension Recovery Category: Account Management, Advertising, Computer Security, Digital Marketing, Google Ads, Internet Marketing, Marketing, SEO Budget: $10 - $30 USD
22-Jan-2026 16:53 GMT
Engaging Scripts for Five Videos Category: Audio Production, Audio Services, Content Writing, Editing, Proofreading, Script Writing, Video Production, Voice Talent Budget: $15 - $25 USD
22-Jan-2026 16:52 GMT
WhatsApp Purchase Tracking for Meta Ads Category: API Development, Data Integration, Linux, Node.js, Payment Processing, PHP, Python, Software Architecture Budget: ₹600 - ₹1500 INR
