Pre-Launch UTM Linter for Airtable Campaign Links

Scans an Airtable view of campaign links awaiting launch and lints each URL's UTM parameters against your house rules: required keys present (source, medium, campaign), lowercase enforced, no spaces, allowed-value lists for source and medium, and no stray or duplicate params. Clean rows are marked `Approved`; bad rows are marked `Blocked` with a human-readable reason, and a launch-readiness summary lands in Slack.

Run it before any campaign push when links are drafted by multiple people across paid, email, and partner channels. It catches the typos that silently fragment your attribution reporting weeks later.

1. 1A scheduled trigger fires each morning over the Airtable "Ready to Launch" view.
2. 2The flow fetches all rows where status is `Pending Review`.
3. 3A lint step parses each URL, normalizes case, and checks every UTM rule, building a pass/fail verdict and reason per row.
4. 4A branch splits clean links from violations.
5. 5Airtable is updated: clean rows to `Approved`, violations to `Blocked` with the failure reason written back.
6. 6A Slack message reports counts, the worst offenders, and whether the batch is safe to ship.