AI Event Aggregator – Suffolk (Via RSS Feed)

Project Overview An automated, AI-driven event aggregation pipeline built on Pabbly Connect. The workflow monitors regional RSS feeds for raw event listings, processes and enriches the data using OpenAI's response models, normalizes dates and timestamps, and posts the structured payload directly to a target application or database via API.

Workflow Breakdown & System Architecture

1. Data Ingestion

RSS Trigger: Listens for new items published to the designated Suffolk regional RSS feed.

Payload Capture: Automatically extracts unstructured event text, titles, links, and raw timestamps upon feed update.

2. AI Extraction & Processing

Initial OpenAI Processing: Evaluates incoming RSS feed items to extract key event details (such as event titles, descriptions, venues, and schedules).

Secondary OpenAI Structuring: Runs structured text transformation to refine the output into consistent JSON/key-value pairs for downstream use.

Asynchronous Delay & Polling: Implements a time delay to handle longer AI processing jobs, followed by an OpenAI retrieval step (Get Response By ID) to safely collect complex batch responses.

3. Date & Time Standardization

Date Formatting: Formats string timestamps into standardized ISO/date formats (Format Date Only).

Current Date Alignment: Pulls dynamic reference points to calculate event timing relative to execution time (Modify Current Date).

Time Operations: Runs date math to handle timezone adjustments and standardize event start/end windows (Add/Subtract Time).

4. External Integration & Dispatch

API Delivery: Sends the clean, AI-enriched event payload via standard HTTP API requests (API Module) to populate external dashboards, custom websites, CRMs, or event calendars.

Key Tools & Technologies

Automation Engine: Pabbly Connect

AI Processing: OpenAI (ChatGPT Response API)

Data Handling: RSS Feed Integration, Custom Date/Time Formatters

Integration Protocols: REST API (JSON payload dispatch)