Automate Repetitive Tasks with Python: Save 20+ Hours Per Week

10 Tasks Every Employee Can Automate Today

Not all automation requires months of development. These ten tasks are things you can automate with basic Python skills -- many in under an hour. The time savings listed are based on averages from employees who completed the 50+ automation tasks in our course.

File & Folder Automation

File management is the single most common time sink in any office. Renaming files one by one, sorting documents into folders, creating backups -- all of this is dead simple to automate with Python. The os, shutil, and pathlib libraries handle everything you need.

Example: Organize Downloads by File Type and Date

This script watches your Downloads folder and automatically sorts files into subfolders by type and date. No more messy Downloads folder:

import os
import shutil
from pathlib import Path
from datetime import datetime

# Configuration
DOWNLOADS = Path.home() / "Downloads"
ORGANIZED = Path.home() / "Documents" / "Organized"

# File type categories
FILE_TYPES = {
    "Images": [".jpg", ".jpeg", ".png", ".gif", ".svg", ".webp"],
    "Documents": [".pdf", ".doc", ".docx", ".txt", ".rtf", ".odt"],
    "Spreadsheets": [".xlsx", ".xls", ".csv", ".ods"],
    "Presentations": [".pptx", ".ppt", ".key"],
    "Archives": [".zip", ".rar", ".7z", ".tar", ".gz"],
    "Videos": [".mp4", ".mov", ".avi", ".mkv"],
    "Audio": [".mp3", ".wav", ".flac", ".aac"],
}

def get_category(file_extension):
    """Return folder category for a file extension."""
    for category, extensions in FILE_TYPES.items():
        if file_extension.lower() in extensions:
            return category
    return "Other"

def organize_files():
    """Sort all files in Downloads into organized subfolders."""
    moved_count = 0

    for file_path in DOWNLOADS.iterdir():
        if file_path.is_file() and not file_path.name.startswith("."):
            # Get category and date
            category = get_category(file_path.suffix)
            mod_date = datetime.fromtimestamp(file_path.stat().st_mtime)
            date_folder = mod_date.strftime("%Y-%m")

            # Create target directory
            target_dir = ORGANIZED / category / date_folder
            target_dir.mkdir(parents=True, exist_ok=True)

            # Move file (handle duplicates)
            target_path = target_dir / file_path.name
            if target_path.exists():
                stem = file_path.stem
                suffix = file_path.suffix
                counter = 1
                while target_path.exists():
                    target_path = target_dir / f"{stem}_{counter}{suffix}"
                    counter += 1

            shutil.move(str(file_path), str(target_path))
            moved_count += 1
            print(f"  Moved: {file_path.name} -> {category}/{date_folder}/")

    print(f"\nDone! Organized {moved_count} files.")

if __name__ == "__main__":
    organize_files()

Email Automation

The average office worker spends 2.6 hours per day on email (Adobe Email Usage Study). Much of that is sending the same types of messages, forwarding attachments, and filtering through newsletters. Python can handle all of it.

Example: Send Personalized Emails with Attachments from a Spreadsheet

import smtplib
import pandas as pd
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
from email.mime.base import MIMEBase
from email import encoders
from pathlib import Path

def send_personalized_emails(spreadsheet_path, attachment_dir=None):
    """
    Send personalized emails to a list from a spreadsheet.
    Spreadsheet columns: Name, Email, Company, AttachmentFile (optional)
    """
    # Read recipient list
    df = pd.read_excel(spreadsheet_path)
    print(f"Sending to {len(df)} recipients...")

    # Email configuration
    SMTP_SERVER = "smtp.gmail.com"
    SMTP_PORT = 587
    SENDER_EMAIL = "you@company.com"
    SENDER_PASSWORD = "your-app-password"  # Use App Password, not real password

    # Connect to server
    server = smtplib.SMTP(SMTP_SERVER, SMTP_PORT)
    server.starttls()
    server.login(SENDER_EMAIL, SENDER_PASSWORD)

    sent_count = 0
    for _, row in df.iterrows():
        msg = MIMEMultipart()
        msg["From"] = SENDER_EMAIL
        msg["To"] = row["Email"]
        msg["Subject"] = f"Monthly Report for {row['Company']}"

        # Personalized body
        body = f"""Hi {row['Name']},

Please find attached the monthly performance report for {row['Company']}.

Key highlights are included on page 1. Let me know if you
have any questions.

Best regards,
Your Name"""

        msg.attach(MIMEText(body, "plain"))

        # Attach file if specified
        if attachment_dir and pd.notna(row.get("AttachmentFile")):
            file_path = Path(attachment_dir) / row["AttachmentFile"]
            if file_path.exists():
                with open(file_path, "rb") as f:
                    part = MIMEBase("application", "octet-stream")
                    part.set_payload(f.read())
                encoders.encode_base64(part)
                part.add_header(
                    "Content-Disposition",
                    f"attachment; filename={file_path.name}"
                )
                msg.attach(part)

        server.sendmail(SENDER_EMAIL, row["Email"], msg.as_string())
        sent_count += 1
        print(f"  Sent to {row['Name']} ({row['Email']})")

    server.quit()
    print(f"\nDone! Sent {sent_count} emails.")

# Usage
send_personalized_emails(
    "clients.xlsx",
    attachment_dir="./reports/"
)

Data Entry & Transfer Automation

Data entry is the most tedious and error-prone work in any office. Copying rows from one spreadsheet to another, updating CRM records, transferring data between systems -- this is exactly the kind of work Python was made to eliminate. According to a Smartsheet survey, employees spend 40% of their time on manual, repetitive data tasks.

The pattern is always the same: read from source, transform, write to destination. Once you understand this pattern, you can transfer data between any two systems. For a deep comparison of how Python handles data versus spreadsheet tools, see our Python vs Excel vs No-Code guide.

For a complete list of data tasks you can automate, including specific code examples for CRM syncing and database imports, check out our 50+ tasks to automate with Python guide.

Document Processing

Document processing is where Python's power becomes undeniable. Merging PDFs, extracting text from scanned invoices, generating Word reports from templates, manipulating Excel workbooks with dozens of sheets -- Python handles all of it with dedicated libraries.

Common Document Automation Workflows

For a complete walkthrough of automated reporting with charts and formatting, see our Python report automation guide. For real-world business examples of document automation ROI, check business automation case studies.

How to Calculate Your Time Savings

Gut feelings about "saving time" are not enough. You need a concrete ROI calculation to justify the learning investment -- to yourself, and possibly to your manager. Here is the framework:

Quick Self-Assessment: How Much Time Can You Save?

Rate each activity based on how many hours you spend on it per week. Be honest -- most people underestimate:

If you checked "3-5 hrs" or "5+ hrs" on two or more activities, Python automation will pay for itself within weeks. Even one or two automations can save you an entire workday per week.

Before vs After: Real Employee Stories

Numbers are convincing, but stories make it real. Here are three employees who automated their repetitive tasks and transformed their workweek. These are based on aggregated data from LearnForge course graduates.

Getting Started: Your First Automation in 30 Minutes

You do not need to study Python for months before automating your first task. Follow these steps and you will have a working automation in 30 minutes -- even if you have never written a line of code.

How to Get Started with LearnForge

If you want to go beyond one-off scripts and build a complete automation toolkit, our Python Automation Course gives you everything you need. It is designed specifically for office employees, analysts, and admins who want to eliminate repetitive work -- not become software developers.

Still deciding whether Python is the right tool for you? Read our Python vs Excel vs No-Code comparison to see where Python fits. Want to understand the skills you will build? Check our Python automation skills guide.

Frequently Asked Questions

Related Articles

Stop Doing Manually What Python Can Do in Seconds

Every hour you spend on repetitive tasks is an hour you could spend on work that matters. Learn Python automation and take back your week.