MARKETING

Bulk-audit a campaign URL list and auto-correct fixable UTMs

On demand, ingests a Google Drive CSV of campaign URLs, validates every link's UTMs, auto-normalizes safely fixable issues (casing, spacing), and writes a corrected file…

CategoryMarketing
Enginesim
Difficultyintermediate
Triggermanual
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerManual run against a target CSV
  • ActionRead campaign URL list from Google Drive CSVGoogle DriveGoogle Drive
  • LogicClassify each link: clean, auto-fixable, or needs-review
  • ActionNormalize auto-fixable UTMs and rebuild URLs
  • OutputWrite corrected CSV + review list back to DriveGoogle DriveGoogle Drive

What it does

This processes a whole spreadsheet of campaign URLs at once. It reads a CSV from Google Drive, validates each link against your UTM convention, and automatically repairs the mechanical problems it can fix safely — lowercasing mediums, trimming whitespace, replacing spaces with hyphens in campaign names. Links with judgment-call errors (unknown source, missing required content) are left untouched and flagged for a human.

When to use it

Use it when you inherit a backlog — a migration export, an agency handoff, or a legacy tracking sheet — and need to clean hundreds of links fast without hand-editing each one.

How it works

  1. 1A manual run starts the audit against a target Drive CSV.
  2. 2The workflow reads and parses every row's URL into UTM fields.
  3. 3Validation logic classifies each link as clean, auto-fixable, or needs-review.
  4. 4Auto-fixable links are normalized and the corrected URL is rebuilt; needs-review links are recorded with their reason.
  5. 5A corrected CSV and a separate review list are written back to Google Drive for the team.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect Google DriveDocs, sheets, slides, files.
  2. 2
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  3. 3
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  4. 4
    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.