Brevo Master List Migration, Contact Segmentation & WordPress Integration

I run an very small massage school with international projection, and have a growing mailing list of approx. 1,800 contacts currently spread across 15+ Brevo (Sendinblue) lists. These lists are segmented by:
* Countries or macro-regions of interest (e.g., Spain, Italy, Portugal, or grouped regions like Greece, Balkans, Turkey, etc.)
* Preferred communication language (EN, ES, FR, PT, IT)

My goal is to *clean and consolidate these contacts into a single master list* in Brevo, using custom attributes and dynamic segments for better targeting. I also want to *connect and update my WordPress subscription and contact forms* to feed contacts directly into Brevo with proper segmentation data.

I maintain an Excel database of all past course participants (10+ courses). I need a script or routine to:

* Identify new contacts and add them to Brevo
* Update existing contacts’ education levels and course history

---

Deliverables

1. Brevo Contact Database Restructure

* Merge all current Brevo lists into a single master list
* Create custom attributes:
* `countries_of_interest` (multiple-choice)
* `preferred_languages` (multiple-choice)
* `student_level` (category/text: new lead, basic, intermediate, advanced)
* `courses_taken` (multiple-choice or text)
* Deduplicate contacts (based on email)
* Format and import data from Excel into Brevo

2. Brevo Dynamic Segments

* Create segments combining:
* Countries/macro-regions
* Languages
* Student levels
* Courses taken / not taken

3. Excel Sync Script / Automation

* Script or routine (manual or automated) to:
* Detect new students in the Excel file
* Add or update their profile in Brevo (including course and level info)
* Ideally use Python, Google Sheets API, or Make.com

4. WordPress Integration
* Review and enhance Brevo plugin subscription forms
* Add multi-select fields for country/region and languages
* Map fields to Brevo attributes
* Connect WPForms contact forms to Brevo
* Add new leads automatically
* Tag by form source
* Ensure GDPR compliance and responsive design

----

Requirements

The ideal freelancer has:

* Experience with Brevo (Sendinblue) contact management and segmentation
* Strong WordPress experience (Brevo plugin and WPForms integration)
* Skills in Excel / Google Sheets for contact data cleaning and formatting
* Familiarity with automation tools like Make.com
* Optionally, scripting in Python or Google Apps Script
* Attention to detail and respect for data privacy

---

What I Will Provide

* Sample or full contact database (Excel/Google Sheets)
* List of courses, countries, and segmentation logic
* Access to Brevo account (via secure sharing)
* Access to WordPress admin
* Examples of how segmentation should work

---

To Apply

Please share:

* Your experience with Brevo and CRM list management
* WordPress form integration experience (Brevo plugin and/or WPForms)
* Suggested approach for syncing Excel with Brevo
* Timeline and budget estimate (closed price - preferred or hourly rate + estimated nr. of hours)