MARKETING
UTM Audit for Campaign Spreadsheets in Google Drive
Watches a Google Drive folder for new or updated campaign link spreadsheets, lints every URL inside.
How it runs
The automated pipeline, trigger to output.
- TriggerDrive folder detects new or updated spreadsheetGoogle Drive
- ActionDownload and extract URLs from the spreadsheetGoogle Drive
- LogicLint each URL and compile verdicts and reasons
- ActionWrite annotated audit report back to Drive folderGoogle Drive
- OutputSend Slack alert with counts and broken linksSlack
What it does
Monitors a shared Google Drive folder where teams drop link-tracking spreadsheets. When a file lands or changes, it reads every URL, runs the UTM hygiene checks, and produces an audit report file written back to Drive. It then alerts the team in Slack with a count and a list of malformed links.
When to use it
Use it when campaign links live in ad-hoc spreadsheets uploaded to Drive rather than a structured database. It turns a messy shared folder into a self-auditing workspace, so agencies and partners get told exactly which rows are broken without anyone manually eyeballing hundreds of links.
How it works
- 1A Drive file trigger fires when a spreadsheet is added or modified in the watched folder.
- 2The file content is downloaded and every URL column value is extracted.
- 3The linter validates each URL for required params, casing, whitespace, taxonomy, and encoding.
- 4A logic step compiles per-row verdicts and reasons into an annotated audit report.
- 5The report is written back to the same Drive folder as a new file.
- 6A Slack alert summarizes pass/fail counts and lists the malformed links for fast fixing.
Set it up
What you configure once, before turning it on.
- 1Connect Google DriveDocs, sheets, slides, files.
- 2Connect SlackChannels, DMs, threads, mentions.
- 3Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 4Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 5Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Marketing workflows
UTM Link Linter: Block Malformed Tracking URLs Before Launch
Validates every campaign tracking link queued in an Airtable launch table against your UTM naming rules.
Spin up a rush localization handoff from a Slack chat request
A marketer asks the CEO agent in chat to rush-translate a piece of approved copy into specific languages; the agent files the source in Google Drive.
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.
Real-Time UTM Validator API for Link-Building Forms
Exposes a webhook that validates a tracking URL on the fly and returns a structured pass/fail JSON response.
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.
Post a per-locale localization launch-readiness digest each morning
On a daily schedule it pulls every translation subtask for an upcoming campaign from monday.com, computes which locales are complete, in progress, or blocked, and posts a single…
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.