Building a Web Scraper to Track Product Prices and Send Alerts

A few months ago, I was just experimenting with Python, trying to automate small tasks and solve problems. I never expected that one of these little scripts would end up making me over $10,000. But that’s exactly what happened.

Here’s the full story of how a simple idea turned into a surprisingly profitable project.

لنبدأ في بناء منطق روبوت الدردشة:

import random

def chatbot_response(user_input):
    user_input = preprocess(user_input)
    for question, response in qa_pairs.items():
        if question in user_input:
            return response
    return "عذراً، لا أفهم سؤالك. هل يمكنك إعادة صياغته؟"

pip install flask websockets asyncio

Let’s first create the game logic for tic-tac-toe.

Here’s the full workflow:

if __name__ == "__main__":
    speak("Initializing your assistant...")
    while True:
        command = listen_command()
        if command:
            if "exit" in command or "stop" in command:
                speak("Goodbye!")
                break
            elif "weather in" in command:
                city = command.replace("weather in", "").strip()
                get_weather(city)
            else:
                process_command(command)

Store the attendance data in an SQLite database for record-keeping.

import sqlite3

# Connect to SQLite database
conn = sqlite3.connect("attendance.db")
cursor = conn.cursor()

# Create table
cursor.execute("""
    CREATE TABLE IF NOT EXISTS attendance (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        name TEXT,
        timestamp DATETIME DEFAULT CURRENT_TIMESTAMP
    )
""")

def log_attendance(name):
    cursor.execute("INSERT INTO attendance (name) VALUES (?)", (name,))
    conn.commit()

# Update the webcam loop to log attendance
if name not in attendance_log:
    attendance_log.add(name)
    log_attendance(name)
    print(f"{name} marked present in the database!")

To make the report visually appealing, we’ll apply some formatting:

from openpyxl.styles import Font, Alignment

# Bold headers
for col in range(1, 6):
    cell = sheet.cell(row=1, column=col)
    cell.font = Font(bold=True)

# Set column widths
sheet.column_dimensions['A'].width = 15
for col in ['B', 'C', 'D', 'E']:
    sheet.column_dimensions[col].width = 12

# Center-align headers
for col in range(1, 6):
    cell = sheet.cell(row=1, column=col)
    cell.alignment = Alignment(horizontal="center")

# Save the formatted workbook
workbook.save('sales_report_formatted.xlsx')

To deactivate the virtual environment, run:

Once the virtual environment is activated, you can install packages using pip: