Simple Lead Generation Automation

This is a basic Python automation script designed to collect, organize, and clean lead data automatically. It was created as an assignment for a Python Automation Internship at Jarurat Care.

Features

• Automated Data Fetching: Uses the requests library to fetch real business data via a public API (Open Brewery DB).
• Data Cleaning: Utilizes pandas to remove duplicate entries and handle missing values gracefully.
• Email Generation: Automatically generates a personalized outreach email draft for each collected lead.
• Excel Export: Automatically saves the cleaned and organized data into an Excel file.

Tools & Libraries Used

• Python 3
• requests
• pandas
• openpyxl

How to Run

1. Clone the repository.
2. Install the required libraries: pip install -r requirements.txt
3. Run the script: python lead_generator.py
4. The output will be saved as an Excel file in the same directory (see Sample_Output.xlsx for reference).