πŸ“Š

Email Validator

Validate email addresses in bulk with syntax check and optional MX record verification.

Excel ⭐⭐ Intermediate ⏱️ 5 minutes

😫 The Pain Point

Your marketing list has 5000 emails. Before spending on email campaigns, you need to verify they’re real. Typos like β€œgmial.com” waste money. Invalid domains bounce.

πŸš€ Agentic Solution

A Multi-Level Email Validator that checks syntax and mail server existence.

Key Features:

  • Syntax Check: Valid format (user@domain.com).
  • Domain Check: Does the domain exist?
  • MX Record Check: Does the domain accept email?

βš”οΈ Phase 1: Commander (Quick Fix)

For quick validation.

Prompt:

β€œI have an Excel emails.xlsx with column β€˜Email’. Write a Python script using dnspython to:

  1. Syntax Check: Validate email format with regex.
  2. MX Check: Verify domain has MX records.
  3. Classify: Valid, Invalid_Syntax, Invalid_Domain.
  4. Output: Save with β€˜Status’ column.

Print validation summary. Handle timeouts gracefully.”

Result: Clean email list with bad addresses flagged.

πŸ—οΈ Phase 2: Architect (Permanent Tool)

For Digital Marketers.

Engineering Prompt:

**Role:** Python GUI Developer (PyQt6 Specialist)
**Task:** Create "Bulk Email Validator" Desktop App

**Objective:** A desktop tool to clean email lists by verifying syntax, domains, and MX records.

**Tech Stack:**
* Language: Python 3.10+
* GUI Library: PyQt6 (Cross-platform)
* Network: dnspython
* Packaging: PyInstaller

**Functional Requirements:**
1.  **UI Layout (PyQt6):**
    *   **Input:** Excel/CSV File Loader + Email Column Selector.
    *   **Settings:** Checkboxes for "Syntax Check" (Fast), "DNS Check" (Medium), "MX Check" (Slow/Strict).
    *   **Dashboard:** Counters for "Valid", "Invalid", "Unknown".

2.  **Core Logic:**
    *   **Level 1:** Regex validation.
    *   **Level 2:** `dns.resolver.resolve(domain, 'A')`.
    *   **Level 3:** `dns.resolver.resolve(domain, 'MX')`.
    *   **Threading:** Critical. Use `QThread` pool to parallelize checks (e.g., 10-20 workers).

3.  **Deliverables:**
    *   `main.py`: Complete source code.
    *   `requirements.txt`: Dependencies.
    *   **Build Instructions:**
        *   Windows: `pyinstaller --onefile --noconsole main.py`
        *   macOS: `pyinstaller --windowed --noconsole main.py`

🧠 Prompt Decoding

  • MX Records: Mail eXchanger records indicate a domain can receive email.

πŸ› οΈ Instructions

  1. Install: pip install dnspython
  2. Copy Prompt β†’ Run.

Related Workflows

Explore other categories

πŸ“¬

Get Started with Agentic Working

Subscribe to receive updates from AgenticWorking.io

πŸ“– Free eBook Guide πŸ“¦ 7 Ready-to-use Scripts πŸ”” Weekly Tips

No spam, unsubscribe anytime. Join 1,000+ subscribers.