/.# 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
- Users can specify their country and language preferences during registration
- System generates RSS feeds based on user's country with both English and French versions
- Dataframes from both language feeds are properly merged for content processing
- 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