Contact person: Automated Supplier Email Parsing and Client Distribution System

Phone:Show

Email:Show

Location: Street, United Kingdom

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"1. Project Overview
The project aims to build an automated system that processes product information received from multiple suppliers via email and makes this data available to clients through a secure web-based dashboard. Additionally, the system integrates with the Brevo API to send product updates via email campaigns to selected client contact lists.
This solution leverages AI-driven parsing to extract structured data (product info, supplier details, attachments) from incoming supplier emails, reducing manual effort, improving accuracy, and ensuring timely distribution of product updates. The system is designed to handle large-scale data processing, with some attachments containing over 1,000 product records.

2. Objectives
* Automate the collection and processing of supplier product emails.
* Extract structured product and supplier data using third-party AI services, even from large files containing 1,000+ products.
* Store extracted data in a central database with timestamps for tracking.
* Record and retain timestamps of all emails received to track historical product price trends.
* Provide an admin dashboard to manage product listings, price history, and oversee client access.
* Enable clients to sign up/sign in to view updated product information and price trends.
* Facilitate bulk communication through automated email campaigns using the Brevo API.

3. System Workflow
* Supplier Input
Suppliers send product information and attachments via email to a designated inbox.
* Email Capture
System continuously monitors Marco’s inbox for new supplier emails.
Captures both the email metadata (including timestamp of receipt) and attachments.
* AI Processing
Email content and attachments are forwarded to a third-party AI service.
AI analyses and returns structured data (product name, details, price, supplier info, etc.).
The AI service is designed to handle attachments with 1,000+ products, ensuring scalability for bulk data.
* Database Storage
Parsed product and supplier information is stored in a central database.
Database logs:
Product details
Supplier information
Email timestamp (for trend tracking)
This allows historical trend analysis of product prices.
* Dashboard & Access
Website admin has access to the dashboard to review/manage product listings.
Clients (via sign-up/sign-in) can view updated product information and historical price trends.
* Email Campaign Distribution
The system pulls all updated product info daily.
Connects to Brevo API to send product updates.
Admin selects target contact lists (or all contacts) for campaign distribution.

4. Key Features
* Automated Email Parsing – AI-driven extraction of structured product and supplier data, scalable to 1,000+ records per file.
* Timestamp Collection – Every supplier email is timestamped to build a price history dataset.
* Centralised Database – Stores supplier, product, and timestamped update history.
* Web Dashboard – Provides admin and client access to updated product information and price trends.
* Secure Authentication – Clients can sign up/sign in for controlled access.
* Brevo API Integration – Enables targeted bulk email campaigns to clients.
* Daily Update Workflow – Ensures clients always have access to the latest product data.

5. Stakeholders
* Suppliers – Provide product details via email.
* Marco (Inbox Owner) – Designated inbox receiving supplier communications.
* Third-party AI Provider – Service used for parsing and structuring email content, capable of processing large datasets.
* Website Admin – Manages dashboard, data validation, and client access.
* Clients – End users who view product information, receive updates, and analyse price trends.

6. Expected Outcomes
* Reduced manual data entry and improved data accuracy.
* Faster product information dissemination to clients.
* Centralised platform for supplier-client communication.
* Ability to track product price trends over time for greater client insight.
* Scalable system that can handle large supplier datasets.
* Enhanced marketing efficiency via automated, targeted product campaigns.

7. Technical Components
* Email Integration – Inbox monitoring and capture.
* AI Service – Third-party integration for email and attachment parsing, scalable to large datasets.
* Database – Centralised structured storage of supplier/product data and timestamps.
* Web Application – Dashboard for admin and clients, including trend visualisation.
* Authentication – Client sign-up/sign-in module.
* Brevo API – Email campaign automation." (client-provided description)