SECOPS
Daily Cloudflare WAF Cluster Digest to BigQuery and Notion
Each morning it loads the prior day's blocked Cloudflare requests into BigQuery, clusters them into the top recurring attack patterns.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily morning schedule
- ActionExport yesterday's blocked requests from CloudflareCloudflare
- ActionInsert rows into BigQueryBigQuery
- LogicCluster and rank recurring signatures
- ActionWrite digest with candidate rulesOpenAI
- OutputPublish digest to Notion review pageNotion
What it does
It gives the security team a daily, durable record of what the WAF blocked and which patterns are worth a permanent rule. Raw blocks land in BigQuery for long-term analysis, and the human-readable summary with rule suggestions lands in Notion.
When to use it
When you want a calm daily review rhythm rather than real-time alerts, plus a queryable warehouse of block history for trend analysis and audits.
How it works
- 1A schedule fires once each morning.
- 2Export yesterday's blocked requests from Cloudflare.
- 3Insert the rows into a BigQuery table for retention and querying.
- 4Run a clustering query that ranks the top recurring signatures by volume and growth.
- 5An LLM step writes a digest summarizing each cluster with a suggested candidate rule and confidence.
- 6Publish the digest to a Notion page dated for the team's morning review.
Set it up
What you configure once, before turning it on.
- 1Connect CloudflareWorkers, Pages, R2, KV — the edge stack.
- 2Connect BigQueryDatasets, queries, schemas.
- 3Connect OpenAIModels, embeddings, files.
- 4Connect NotionPages, databases, comments.
- 5Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 6Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 7Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More SecOps workflows
Post-Revocation Verification and Audit Logging
After a key is revoked, it confirms the old credential actually fails, verifies the replacement works.
Page on-call when a WAF rule mass-blocks legitimate traffic
On demand or every few minutes, it detects a single Cloudflare WAF rule suddenly blocking a broad spread of ASNs and paths (a likely false-positive storm).
PII Content Scan on New Dropbox External Share
When a file gets an external Dropbox link, it reads the file content, uses an AI classifier to detect PII or secrets.
Compile a weekly WAF tuning review with trends to Confluence
Every week an agent rolls up Cloudflare WAF block clusters by rule and ASN, compares them to prior weeks for trend direction.
Sensitive Dropbox Link Owner Remediation Loop
When a newly created Dropbox shared link points to a sensitive file, this workflow DMs the file owner, gives them a deadline to justify or revoke it.
GitLab Push Secret Detection to Block and History Purge
On a GitLab push that contains a detected secret, it revokes the exposed credential, opens a tracking issue with git-history purge instructions.
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.