AI & RAG

Weekly audit of Loom SOP coverage gaps and stale walkthroughs

On a schedule, compare your process registry against the indexed Loom library to find procedures with no walkthrough and videos that are outdated or rarely retrieved.

CategoryAI & RAG
Enginesim
Difficultyadvanced
Triggerschedule
Steps6
Setup~25 min

How it runs

The automated pipeline, trigger to output.

  • TriggerWeekly schedule fires
  • ActionLoad process registry from AirtableAirtableAirtable
  • ActionPull Loom inventory + retrieval stats from PostgresPostgreSQLPostgres
  • LogicMatch processes, flag missing and stale videos
  • ActionRank gaps and draft backlog with OpenAIOpenAI
  • OutputPost prioritized gap report to SlackSlack

What it does

Keeps your Loom SOP library honest. On a weekly cadence it reads your process registry from Airtable, cross-references it against the indexed Loom transcripts, and flags two problems: documented processes that have no walkthrough at all, and walkthroughs that are stale (old recording date, or low retrieval traffic in your RAG logs). It ranks the findings by importance and posts a recording to-do list to Slack.

When to use it

Use it when ownership of SOP video is fuzzy and coverage silently rots. Enablement and ops leads get a recurring, prioritized backlog of exactly which walkthroughs to record or re-record.

How it works

  1. 1A weekly schedule triggers the audit.
  2. 2The flow loads the canonical process list from Airtable.
  3. 3It pulls the current Loom transcript inventory and retrieval stats from Postgres.
  4. 4Logic matches processes to walkthroughs, marking missing coverage and stale or unused videos.
  5. 5OpenAI ranks the gaps by priority and drafts a concise recording backlog.
  6. 6The prioritized report is posted to a Slack channel for the SOP owners.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect AirtableBases, tables, views, automations.
  2. 2
    Connect PostgresAny Postgres URL — query, write, migrate.
  3. 3
    Connect OpenAIModels, embeddings, files.
  4. 4
    Connect SlackChannels, DMs, threads, mentions.
  5. 5
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  6. 6
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  7. 7
    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.