Python Scraper for Competitor Prices (3 Sites) to CSV + Google Sheets

We're a small online outdoor gear store. Every week we check competitor prices by hand, and it takes hours. We need a Python script to do it for us. What the script should do: - Scrape product listings from 3 competitor websites (public pages, no login) - About 600 products per site, across 5 to 10 category pages - Collect: product name, SKU, price, sale price, stock status, product URL, site name, date - Save results to one CSV file and to a Google Sheet Technical details: - 2 sites are plain HTML. 1 site loads products with JavaScript. Python 3.11+ - Selectors should be in a config file so we can update them ourselves - Follow robots.txt and use polite request delays - Handle pagination, retries, and errors without crashing - A full run should finish in under 30 minutes Deliverables: - Source code + requirements.txt - Config file for all 3 sites - README with setup and "how to fix a broken selector" steps - One test run with output CSV Not included: Proxies, CAPTCHA solving, server hosting, dashboards, alerts.