| /.# Social Media Post automation - Epic Breakdown | |
| **Date:** 2025-11-22 | |
| **Project Level:** brownfield | |
| --- | |
| ## Epic 1: Multi-Country and Multi-Language RSS Generation | |
| **Slug:** multi-country-multi-language-rss-generation | |
| ### Goal | |
| Enable the LinkedIn post generation system to use user-specific country and language preferences when generating RSS feeds from keywords, supporting both English and French languages for any given country. | |
| ### Scope | |
| Implement user preference collection during registration, modify RSS generation to use country/language parameters, and create logic to merge dataframes from both English and French feeds for the same country. | |
| ### Success Criteria | |
| 1. Users can specify their country and language preferences during registration | |
| 2. System generates RSS feeds based on user's country with both English and French versions | |
| 3. Dataframes from both language feeds are properly merged for content processing | |
| 4. All existing functionality remains intact while adding multi-country support | |
| ### Dependencies | |
| - Existing Supabase database connection with profiles table | |
| - Current RSS source management functionality | |
| - Existing authentication system (JWT tokens) | |
| --- | |
| ## Story Map - Epic 1 | |
| The user journey begins with registration where users specify their country and language preferences. The system then uses these preferences to generate RSS feeds that are relevant to the user's location and language preferences. The content generation process seamlessly handles feeds from multiple languages by merging the dataframes appropriately. | |
| --- | |
| ## Stories - Epic 1 | |
| ### Story 1.1: User Preference Collection During Registration | |
| As a new user, | |
| I want to specify my country and language preferences during registration, | |
| So that the system generates content relevant to my location and language. | |
| **Acceptance Criteria:** | |
| **Given** I am registering for a new account | |
| **When** I fill out the registration form | |
| **Then** I see options to select my country and language preferences | |
| **And** I can select my primary country and language (English or French) | |
| **Prerequisites:** None | |
| **Technical Notes:** Use ISO 3166-1 alpha-2 country codes and ISO 639-1 language codes; store preferences in Supabase profiles.raw_user_meta as JSON | |
| **Estimated Effort:** 5 points (2-3 days) | |
| ### Story 1.2: Update RSS Generation with User Preferences | |
| As a system, | |
| I want to use user preferences for RSS feed generation, | |
| So that the generated feeds are relevant to the user's country and language. | |
| **Acceptance Criteria:** | |
| **Given** A user has specified country and language preferences | |
| **When** The system generates RSS feeds from keywords | |
| **Then** The feeds are generated using the user's country settings | |
| **And** Both English and French feeds are generated for the user's country | |
| **Prerequisites:** User must have preferences stored | |
| **Technical Notes:** Modify generate_google_news_rss_from_string function to accept parameters; generate both language feeds for user's country | |
| **Estimated Effort:** 8 points (3-4 days) | |
| --- | |
| ## Implementation Timeline - Epic 1 | |
| **Total Story Points:** 23 | |
| **Estimated Timeline:** 3-4 weeks | |
| --- |