main.py

import requests
from bs4 import BeautifulSoup
import pandas as pd
import gspread
from google.oauth2.service_account import Credentials
from datetime import datetime

# Function to scrape Cashify prices
def scrape_cashify_price(device_name):
    # url = f"https://www.cashify.in/buy-refurbished-mobile-phones/renewed-{device_name.replace(' ', '-').lower()}"
    url="https://www.cashify.in/buy-refurbished-mobile-phones/renewed-apple-iphone-xs/sale/95837"
    response = requests.get(url)
    soup = BeautifulSoup(response.text, 'html.parser')

    # Example selector for getting price (modify as per actual structure)
    price_tag = soup.find('span', {'class': 'h1'})  # Replace with actual class
    if price_tag:
        return price_tag.text.strip()
    else:
        return "Price Not Found"

# Function to update Google Sheet
def update_google_sheet(data):
    scope = ["https://www.googleapis.com/auth/spreadsheets"]
    creds = Credentials.from_service_account_file('credentials.json')
    scoped_creds = creds.with_scopes(scope)  # Apply scopes to credentials
    client = gspread.authorize(scoped_creds)

    sheet_id = "1miZbmJsK9GZHXvwQvn7E0vr9XcRNtKURy7Y-Xw-fxMM"
    sheet = client.open_by_key(sheet_id).sheet1
    sheet.append_row(data)


# Main function
def main():
    device_name = "apple iphone x"  # Replace with your device
    price = scrape_cashify_price(device_name)
    date = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
    
    # Prepare data for Google Sheets
    data = [date, device_name, price]
    
    # Update Google Sheet
    update_google_sheet(data)  # Replace with your Google Sheet name

if __name__ == "__main__":
    main()