SECOPS
Reconcile OAuth Grants Against the Vendor Allowlist
Daily, compares the live set of OAuth apps authorized in Google Workspace against an approved-vendor allowlist in Airtable and reports apps that are unapproved, newly added…
How it runs
The automated pipeline, trigger to output.
- TriggerDaily reconciliation schedule fires
- ActionList authorized OAuth apps and scopes from WorkspaceGoogle Drive
- ActionRead approved-vendor allowlist from AirtableAirtable
- LogicDiff into unapproved, newly added, and unused buckets
- ActionUpdate Airtable rows with last-seen statusAirtable
- OutputSend three-bucket digest to security SlackSlack
What it does
This workflow keeps your real OAuth footprint honest against your approved-vendor list. Each day it pulls the apps actually authorized in Workspace, diffs them against the allowlist of record in Airtable, and produces three buckets: unapproved apps holding access, newly approved apps that just appeared, and approved apps no one has used recently and could be retired.
When to use it
Use it when you maintain a formal approved-SaaS allowlist and need to know where reality has drifted from policy. It catches both the unsanctioned app that slipped in and the stale approval that should be cleaned up to shrink your attack surface.
How it works
- 1A daily schedule starts the reconciliation.
- 2The flow lists all currently authorized OAuth apps and scopes from Workspace.
- 3The flow reads the approved-vendor allowlist from Airtable.
- 4A logic step diffs the two sets into unapproved, newly added, and unused buckets.
- 5The flow updates Airtable rows with last-seen status for each app.
- 6A Slack digest delivers the three buckets to security for action.
Set it up
What you configure once, before turning it on.
- 1Connect Google DriveDocs, sheets, slides, files.
- 2Connect AirtableBases, tables, views, automations.
- 3Connect SlackChannels, DMs, threads, mentions.
- 4Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 5Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 6Test, 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.