Brevo API Data Processing with CSV

This project automates sending data from a CSV file to the Brevo API for double opt-in confirmation.

Features • Requirements • Setup • Usage • Explanation • Logs • Security • Notes • Diagrams •

---

Features:

Iterates through a CSV file, extracting email and other relevant data. Constructs a payload dictionary based on extracted data. Sends POST requests to the Brevo API endpoint for each row in the CSV. Logs successful API connections and sent data to a text file. Uses python-dotenv to securely manage API key and base URL from a .env file.

Requirements:

• Python 3.x
• requests library (pip install requests)
• python-dotenv library (pip install python-dotenv)

Setup:

1. Create a virtual environment (recommended) for isolated project dependencies.
2. Install required libraries: pip install requests python-dotenv
3. Create a CSV file with headers matching the data extraction logic (e.g., email, FNAME, LNAME).
4. Create a .env file in your project directory and add the following lines, replacing placeholders with your actual values:

BREVO_API_KEY=your_api_key
BREVO_API_URL=https://api.brevo.com

Usage:

Replace your_data.csv in the script with the path to your CSV file. Run the script:

python main.py

Explanation:

The script iterates through each row in the CSV file, extracts data like email, first name, and last name. It then builds a payload dictionary according to the Brevo API specifications and sends a POST request using the requests library.

Success Log:

The script logs successful API connections with email addresses and the corresponding sent data to a file named api_success_log.txt.

Security:

This version uses python-dotenv to store sensitive information like the API key and base URL in a separate .env file, which is not included in version control.

Note:

Modify the script's data extraction logic to match your specific CSV format. Error handling is included for catching potential request exceptions. This project provides a basic framework for sending data from a CSV file to the Brevo API. You can customize it further based on your specific needs.

Diagrams