A Python application that tracks prices from Cashify's refurbished mobile phone listings and logs them to a Google Sheet for price monitoring and analysis.
- Scrapes prices from Cashify's refurbished mobile phone pages
- Automatically logs price data with timestamps to Google Sheets
- Configurable for different device models
- Uses Google Sheets API for data storage
- Python 3.x
- Required packages:
requests,beautifulsoup4,pandas,gspread,google-auth - Google Service Account credentials (credentials.json)
- Install required packages:
pip install requests beautifulsoup4 pandas gspread google-auth-
Set up Google Sheets API:
- Create a Google Cloud Project
- Enable Google Sheets API
- Create a Service Account and download credentials.json
- Share your Google Sheet with the service account email
-
Update the script with your Google Sheet ID and device details
Run the script:
python main.pyThe script will scrape the current price and append it to your Google Sheet with a timestamp.
- Modify
device_namein the main function for different devices - Update the
sheet_idwith your Google Sheet ID - Adjust CSS selectors in
scrape_cashify_price()as needed
Make sure to keep your credentials.json file secure and never commit it to version control.