Goal: Collect 50,000 email addresses from NGOs and festivals across countries with strong travel and cultural ties to Uganda.
🌍 Target Countries (10 Total)
- United States
- United Kingdom
- Germany
- Kenya
- Tanzania
- Rwanda
- Democratic Republic of Congo
- South Africa
- Ghana
- United Arab Emirates
🎯 Email Targets per Country
- 500 NGO emails
- 500 Festival emails
- Total: 1,000 emails per country
- Grand Total: 50,000 emails across 50 countries
🔍 Search Method
Use Google with keyword combinations like:
NGOs:
NGO "gmail" "kenya" "facebook.com"
NGO "yahoo" "kenya" "linkedin.com"
NGO "hotmail" "kenya" "instagram.com"
Festivals:
festival "gmail" "kenya" "facebook.com"
festival "yahoo" "kenya" "linkedin.com"
festival "hotmail" "kenya" "instagram.com"
- Use all three email domains: gmail, yahoo, hotmail
- Use all three platforms: Facebook, LinkedIn, Instagram
- Click through all pages of Google results and copy the full content
🧰 Extraction & Cleaning
- Paste into Skymem to extract emails
- Organize in Google Sheets with two tabs per country:
- NGOs
- Festivals
- Use Dedupelist or
=UNIQUE()
in Google Sheets to remove duplicates
✅ Deliverables
- 10 Google Sheets (one per country)
- Each sheet includes:
- Tab 1: 500 NGO emails
- Tab 2: 500 Festival emails
- Total: 1,000 clean, unique emails per country