Security operations centers produce a steady stream of reports: shift logs, incident summaries, officer performance metrics, alarm response times. Downloading, reviewing, and distributing these reports manually takes hours per week. We automated the entire pipeline—from report retrieval to AI-generated summary delivery—using Python and a weekly schedule.

The Manual Process

The starting point: a web-based reporting portal requiring an authenticated session, a multi-step download flow for each report type, and no API access. Generating a full picture of operations across multiple time periods meant navigating the UI multiple times, downloading individual PDFs, and manually comparing numbers across periods. Total time per week: 2–3 hours.

The Automation Approach

The portal had no public API, but it did have a predictable session-based download endpoint. By analyzing the authentication flow, we identified a session-scoped token that could be extracted from the page source and reused for subsequent downloads within the same session. The automation script:

  • Authenticates to the portal and extracts the session token
  • Downloads all required report PDFs for the current period
  • Retains the last four weeks of reports with automatic rotation
  • Passes the current and previous period reports to an AI system for change-focused analysis
  • Delivers an email summary highlighting what changed, what’s up, and what’s down

The entire pipeline runs on a weekly schedule with no human intervention.

The AI Summary Layer

Raw report data is dense and hard to scan quickly. The AI summary layer transforms it: instead of comparing two PDFs manually, the recipient gets a narrative summary that calls out meaningful changes. “Incident response times improved by 18% compared to last week” is more actionable than two tables of numbers that need to be mentally subtracted.

The summary is delivered by email to the relevant stakeholders automatically. No one needs to remember to run the report, no one needs to interpret raw data—the weekly summary just appears in the inbox.

Generalizing the Pattern

This pattern—authenticated scraping of a session-based portal + AI-powered change summary + scheduled delivery—applies to any operational system that produces regular reports without an API. ERP systems, HR platforms, billing portals, field service tools: if you can authenticate to it and it generates downloadable data, this pattern works. The setup time is typically one to two days. The ongoing time savings are measured in hours per week.

Ready to put this to work in your business?

Applied Intelligence helps San Diego and Southern California businesses automate workflows, reduce manual work, and grow without adding headcount. The first conversation is free and takes 20 minutes.

Book a Free Discovery Call →