Python Automation Development Tutorials, Guides & Insights

Instead of writing custom scripts for every client, I made a generic scraper that could handle multiple websites. I put it up for sale on Gumroad and Sellix for $19.99, and people started buying it.

I created a tutorial on "How to Scrape Websites with Python" and added an affiliate link to a web scraping API. Every time someone signed up, I got a commission.

In this tutorial, we’ll create a facial recognition-based attendance system using Python. This project combines computer vision, machine learning, and database management to automate attendance tracking for workplaces, schools, or events. By the end, you’ll have a working application that can detect faces, recognize individuals, and log their attendance into a database.

Traditional attendance systems like manual sign-ins or RFID cards are time-consuming and prone to errors. Facial recognition offers a fast, contactless, and reliable solution.

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).

from openpyxl import load_workbook

# Load the workbook
workbook = load_workbook('sales_data.xlsx')

# Select the active sheet
sheet = workbook.active

# Iterate through rows and print data
for row in sheet.iter_rows(values_only=True):
    print(row)

This will output the rows of data as tuples. The first row will contain the headers.