Data Comparison and Email Script

Overview

This Python script is designed to perform the following tasks:

1. Make an API call to retrieve JSON data.
2. Compare the JSON data with an Excel file.
3. Print the differences in the console.
4. Send an email containing values present in the JSON but not in the Excel file.

You can install these packages using pip3:

pip3 install pandas openpyxl python-dotenv requests


To run the file
python3 main.py