MARKETING
Reconcile UTM exports against the registry and log gaps to Postgres
Scans newly uploaded campaign-export files in Google Drive, cross-checks every UTM against the approved registry in Postgres, logs unregistered links as gaps.
How it runs
The automated pipeline, trigger to output.
- TriggerNew UTM export uploaded to Google DriveGoogle Drive
- LogicRead file and extract distinct UTM combinations
- ActionLook up each combination in the Postgres registryPostgres
- LogicIsolate unregistered orphan campaigns
- OutputLog gaps to Postgres and alert team in SlackSlack
What it does
When a campaign UTM export lands in a Google Drive folder, this workflow reads the file, compares each UTM combination against the approved-campaigns registry stored in Postgres, and identifies links that are live in the wild but were never registered. Those orphans get logged as taxonomy gaps in Postgres and the team gets a heads-up so untracked campaigns are reconciled.
When to use it
Use it when campaigns get launched faster than they get registered and you need to catch shadow UTMs — links real users are clicking that have no entry in your source of truth.
How it works
- 1A Google Drive trigger fires when a new export file appears in the folder.
- 2A logic step reads the file and extracts every distinct UTM combination.
- 3A Postgres action looks up each combination in the approved registry.
- 4A logic step isolates the unregistered orphans.
- 5A Postgres action logs the gaps, and a Slack message alerts the team to reconcile.
Set it up
What you configure once, before turning it on.
- 1Connect Google DriveDocs, sheets, slides, files.
- 2Connect PostgresAny Postgres URL — query, write, migrate.
- 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 Marketing workflows
Slack UTM Check: Paste a Link, Get an Instant Verdict
Lets marketers drop a tracking URL into a Slack channel and get an immediate threaded reply that says whether the UTMs are valid, what is wrong, and a corrected suggestion.
Unlinked Brand-Mention Detector with Authority Scoring
Scans the web for fresh brand mentions, filters to ones that name you without linking back, scores the publishing domain's authority.
Agentic UTM Taxonomy Steward: Detect, Explain, and Propose Fixes
An agent reviews the full backlog of campaign links in Airtable, reasons about taxonomy drift beyond rigid rules, drafts standardized replacements for malformed UTMs.
Nudge translators on overdue localization returns and escalate stuck ones
Runs on a daily schedule, scans monday.com translation subtasks for items past their return date that aren't marked Returned, reminds the assigned translator in Slack.
Backlink Outreach Drafter for Verified Mentions
Picks verified, high-authority unlinked mentions from Airtable, drafts a personalized backlink-request email for each.
Source-Authority Verifier for Mention Provenance
Takes a queue of detected brand mentions and runs an agent that verifies whether each source is a legitimate, authoritative publisher versus a scraper or syndication copy.
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.