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.
- Automated Data Fetching: Uses the
requestslibrary to fetch real business data via a public API (Open Brewery DB). - Data Cleaning: Utilizes
pandasto 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.
- Python 3
requestspandasopenpyxl
- Clone the repository.
- Install the required libraries:
pip install -r requirements.txt - Run the script:
python lead_generator.py - The output will be saved as an Excel file in the same directory (see
Sample_Output.xlsxfor reference).