E-Mail-Warnungen für ablaufende SSL-Zertifikate aus Google Sheets

## 🔐 SSL Expiry Notifier (No Paid APIs) ### 👤 Who is this for? This workflow is designed for IT admins, DevOps engineers, and web professionals who need to monitor SSL certificate expirations across multiple domains — without relying on paid APIs. --- ### 🧩 What It Does 1. Daily Trigger runs the workflow every morning. 2. Google Sheets Integration fetches the list of website URLs to monitor. 3. Free SSL API Check (ssl-checker.io) is used to retrieve certificate validity data. 4. Certificate Details (valid from, valid till, days left) are updated back into the same Google Sheet. 5. If Condition checks if the SSL certificate expires in ≤7 days. 6. Email Alert is sent automatically for soon-to-expire certificates. --- ### ⚙️ Setup Instructions 1. Google Sheets: - Clone the sample sheet or use your own. - Update the Sheet URL in the Fetch URLs and Update Sheet nodes. - Ensure it contains a URL column. 2. Credentials: - Connect your Google account (for Sheets) and SMTP credentials (for email notifications). 3. Customize: - Change the alert threshold in the IF node (currently set to 7 days). - Modify recipient list and message style in the Send Email node. --- ### 🧠 Notes - Uses ssl-checker.io, a free public API — no paid services needed. - Flexible and self-hosted monitoring solution. - Ideal for small teams managing multiple domains.