AutoTrader Data to Sheets

Build a tool that processes an AutoTrader UK search URL, visits all adverts returned, and appends selected data to Google Sheets.

The tool must capture “Date advert posted” as shown by the Chrome extension AT Price Tracker.
Each postcode location run should write results to a specific Google Sheets tab (either an existing tab or a newly created one).
Example URL, which I can provide for locations:
https://www.autotrader.co.uk/motorhome-search?maximum-mileage=125000&postcode=so151gy&price-from=9500&radius=50&seller-type=private&sort=most-recent&year-from=2000
________________________________________
Data to Capture (per advert)
The “Date advert posted” is not normally shown by AutoTrader, but it is visible using the Chrome plugin AT Price Tracker. The solution must capture that value.
• Date advert posted (from AT Price Tracker), If AT Price Tracker integration fails, run in dedupe-only mode.
• Phone number (if visible; click “Show number” if needed)
• Make or Model
• Price
• Mileage
• Location (town/area)
• Distance from postcode (in URL, miles) Autotrader displays this in advert
• Advert URL
• Listing ID (from URL, for dedupe)
________________________________________
Key Requirements
• Process all pages of search results.
• Optional date range filter (inclusive, UK time).
• Deduplication required (listing ID or URL).
• If date cannot be retrieved, skip advert and log it.
• If AT Price Tracker integration fails, run in dedupe-only mode.
• Run when requested
________________________________________
Output
• Append rows to Google Sheets (one advert per row).
• Each postcode/location writes to its own Google Sheets tab
(use an existing tab if present, otherwise create a new one).
• Required columns:
o Date posted
o Phone
o Location
o URL
o Listing ID
________________________________________
Configuration
• Search URL (postcode varies per run)
• Target Google Sheet ID
• Target tab name (per postcode) or auto-create if missing
• Date-from / date-to (optional)
________________________________________
Implementation (open to advice or other options)
• Browser automation preferred
• Must read AT Price Tracker–exposed data. If possible
• Rate-limited, robust error handling, logging.
________________________________________
Deliverables
• Working script + source code
• Google Sheets API integration
________________________________________
Acceptance Criteria
• Running the tool appends all matching adverts to the correct sheet tab.
• Re-running does not create duplicates.
• Date filtering works when enabled.
• Logs show totals: found / added / skipped / failed.
________________________________________
No renegotiate and on price if you accept the project. Unless the valid reason is given outside of the job description