IT OPS

Daily Dropbox External-Collaborator Drift Digest to Teams

Scans your sensitive Dropbox shared folders every morning, compares the current member list against the last approved snapshot stored in Postgres.

CategoryIT Ops
Enginesim
Difficultyintermediate
Triggerschedule
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerWeekday 8am schedule
  • ActionList members of each watched Dropbox folderDropboxDropbox
  • LogicFilter to external domains, diff vs. last snapshot
  • ActionStore new baseline snapshot in PostgresPostgreSQLPostgres
  • OutputPost drift digest to Teams channelMicrosoft Teams

What it does

Every weekday morning this workflow walks a curated list of sensitive Dropbox shared folders, pulls the full membership of each, and flags any collaborator whose email domain is outside your organization. It diffs today's membership against the snapshot it stored on the previous run, so the Teams digest shows only what actually changed — new external members, not the standing roster.

When to use it

Use it when external sharing is allowed but must stay visible. It gives IT and folder owners a single daily readout of access drift without forcing a hard lockdown, and it keeps a durable audit trail in Postgres for compliance reviews.

How it works

  1. 1A schedule fires each weekday at 8am.
  2. 2For each watched folder, Dropbox returns the current member list.
  3. 3A logic step filters members to external domains and diffs them against the prior snapshot in Postgres.
  4. 4The new-external rows are written back to Postgres as the new baseline.
  5. 5A Teams message posts the per-folder digest of newly added external collaborators, or a clean-day note if none.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect DropboxFiles and folders.
  2. 2
    Connect PostgresAny Postgres URL — query, write, migrate.
  3. 3
    Connect Microsoft TeamsChannels, chats, files.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.