MARKETING
Scheduled UTM Sweep Across the Campaign Tracker Sheet in Drive
Runs nightly over a shared Google Drive campaign-tracker spreadsheet, audits every UTM link in the sheet.
How it runs
The automated pipeline, trigger to output.
- TriggerNightly schedule fires
- ActionRead campaign-tracker spreadsheet from Drive folderGoogle Drive
- LogicValidate UTM params per row and detect cross-campaign duplicates
- LogicCompile per-row verdicts and pass/fail/warning summary
- OutputWrite dated compliance report file to Drive folderGoogle Drive
What it does
This is a batch auditor for teams who keep all their campaign links in one master spreadsheet on Google Drive. On a nightly schedule it reads the entire sheet, validates the UTM string on every link row, scores each as compliant or not with a specific failure reason, and writes a dated compliance report back into the same Drive folder for the morning standup.
When to use it
Use it when many people add rows to a shared campaign tracker throughout the day and nobody validates them in real time. The overnight sweep means every link is checked by morning without anyone running a manual review.
How it works
- 1A scheduled trigger fires nightly at a set hour.
- 2The workflow locates and reads the campaign-tracker spreadsheet from the configured Google Drive folder.
- 3A logic step iterates the rows, parsing and validating UTM parameters and flagging duplicates across campaigns.
- 4It compiles per-row verdicts plus a summary count of pass, fail, and warning.
- 5The finished compliance report is written as a new dated file back into the Drive folder.
Set it up
What you configure once, before turning it on.
- 1Connect Google DriveDocs, sheets, slides, files.
- 2Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 3Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 4Test, 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.