Automating Excel Reports with Python and OpenPyXL

Eventually, I turned my script into a web app with Flask and hosted it on Heroku. I charged $9/month for unlimited scraping, and within a few months, I had over 50 active users paying for access.

• Simple ideas can be profitable. You don’t need to build the next big startup to make money.
• Marketing is just as important as coding. I promoted my work on Reddit, Twitter, and Discord developer communities.
• Automate where you can. Instead of writing a new script for every client, I built a reusable tool and sold it multiple times.

To get started, install the necessary Python libraries:

pip install opencv-python dlib face-recognition sqlite3

import smtplib

# Email configuration
EMAIL_ADDRESS = "your_email@example.com"
EMAIL_PASSWORD = "your_password"

def send_email_alert(product, price):
    subject = "Price Drop Alert!"
    body = f"The price of '{product}' has dropped to ${price}. Check it out here: {URL}"
    message = f"Subject: {subject}\n\n{body}"

    # Connect to the email server and send the email
    with smtplib.SMTP("smtp.gmail.com", 587) as server:
        server.starttls()
        server.login(EMAIL_ADDRESS, EMAIL_PASSWORD)
        server.sendmail(EMAIL_ADDRESS, EMAIL_ADDRESS, message)

    print("Email alert sent!")

Use the schedule library to run the script periodically (e.g., every hour).