Client
The European External Action Service (EEAS)
Context
The project aimed to explore daily public online discussions related to specific topics of interest. They wanted a simple way to receive short daily summaries—while also building a searchable archive with trend charts and quick-reference data for internal use.
Our Approach
We developed a streamlined reporting system powered by Google Apps Script and AI-assisted labeling.
The workflow included:
- Keyword Setup
- Worked with the client to define specific keywords and content categories
- Targeted public Arabic-language content on platforms like Facebook and Telegram from community pages and News agencies.
- Applied filters to ensure only relevant posts were included
- Worked with the client to define specific keywords and content categories
- Daily Reporting
- Reviewed content manually and with LLM support to extract key themes
- Compiled daily reports in a structured format with links and source notes
- Used Google Apps Script to parse highlights into a dynamic dashboard feed
- Reviewed content manually and with LLM support to extract key themes
- Dashboard Features
- Searchable archive of daily summaries
- Auto-generated trend charts showing changes in topic frequency
- Filters by theme, date, and platform
- PDF report download and inline content reference
- Searchable archive of daily summaries
- Prompted Alerts
- Media monitoring relevant to the client’s list and reputation
- Real-time reporting and early detection of a crisis
Outputs & Results
This setup gave the client fast daily updates and long-term visibility. The integration of Apps Script automation with AI-enhanced tagging reduced manual work and kept the system consistent, searchable, and easy to maintain.
Demo
[View Dashboard Sample] (link placeholder)
