🔐 Password Checkup

This GitHub Action automates password security reviews by scanning an Excel file for upcoming password review dates and old passwords that haven’t been updated in a while. It sends a styled HTML email summary to configured recipients every 24 hours ( 10:00 AM Romanian Hour ).

Table of Contents

1. Features
2. Project Structure
3. Screenshots
4. Setup Instructions
5. GitHub Secrets Required
6. SMTP Configuration
7. Automation Schedule
8. Email Preview
9. Technologies Used

📋 Features

• ✅ Automatically checks an Excel file daily ( data/data.xlsx )
• ✅ Categorizes passwords:
  • Due within 1 day
  • Due within 3 days
  • Due within 1 week
  • Old passwords that haven’t been updated in over 6 months
• ✅ Sends a beautiful HTML email with all matching entries
• ✅ Built with GitHub Actions, Python, and open-source tools

📁 Project Structure

.
├── .github/workflows/
│   └── reminder.yml             # GitHub Action: daily trigger
├── assets/
│   └── email_preview.gif         # An example of the email you’ll receive
│   └── github_action_run.png     # How it looks when the GitHub Action triggers
│   └── excel_data_preview.png     # How data looks
├── config/
│   └── email_recipients.yaml     # Email list
├── data/
│   └── data.xlsx                 # Main Excel file with password info
├── scripts/
│   └── send_email.py             # Main script that sends the email
├── requirements.txt              # Python dependencies
└── README.md                     # This file that you are reading right now

🖼️ Screenshots

📬 Email Preview

Here’s an example of the email you’ll receive:

⚙️ GitHub Action Run

This is how it looks when the GitHub Action triggers:

⚙️ Excel Data Preview

This is how data in excel looks:

⚙️ Setup Instructions

Reach out to Github Repo for Setup Instructions, link below:

Github Repo - https://github.com/axbecher/PasswordCheckup

🔐 GitHub Secrets Required

Go to Settings > Secrets and variables > Actions and add:

📡 SMTP Configuration

This project allows you to configure the SMTP host.

Go to scripts/send_email.py and update:

🔁 Automation Schedule

This project is set up to allow manual triggering by default via the "Run workflow" button in GitHub Actions.

If you'd like the workflow to run automatically every 24 hours at 08:00 UTC, you need to:

1. Open the file: /.github/workflows/reminder.yml
2. Uncomment the schedule section:

on:
  schedule:
    - cron: '0 8 * * *'  # runs daily at 08:00 UTC
  workflow_dispatch:

💌 Email Preview

The email contains:

• Summary per time frame (1 day, 3 days, 1 week, old passwords ( 90 days / 3 months ))
• Clean table format
• Footer with a link to LastPass Vault

✅ Technologies Used

• Python 3.11
• Pandas
• openpyxl
• GitHub Actions
• SMTP