MARKETING

Pre-launch UTM validator for Google Sheets link plans

Scans a campaign link-plan spreadsheet in Google Drive, validates every UTM parameter against your naming convention, and posts a pass/fail report to Slack before launch.

CategoryMarketing
Enginesim
Difficultybeginner
Triggermanual
Steps6
Setup~5 min

How it runs

The automated pipeline, trigger to output.

  • TriggerOperator starts run and selects the link-plan sheet
  • ActionRead all rows from the Google SheetGoogle DriveGoogle Drive
  • LogicParse UTM params from each tracking URL
  • LogicValidate casing, allowed enums, and campaign pattern
  • LogicSplit rows into passed vs failed with reasons
  • OutputPost pass/fail report to SlackSlack

What it does

Marketing teams stage launch links in a shared Google Sheet (one row per ad, email, or post). This workflow reads that sheet, parses each tracking URL, and checks every UTM parameter against your house naming rules: lowercase only, no spaces, approved source/medium values, and a campaign name that matches your template. It returns a clean pass/fail verdict per row and blocks launch when malformed links slip through.

When to use it

Run it on demand right before a campaign goes live, or when a paid-media manager hands off a link plan for QA. Ideal for teams that lose attribution because someone typed `utm_medium=Email ` with a trailing space or `Spring_Sale` instead of `spring-sale`.

How it works

  1. 1You trigger the run manually and point it at a Drive spreadsheet.
  2. 2It reads every row and extracts the tracking URL column.
  3. 3For each URL it parses the query string and pulls out the five UTM parameters.
  4. 4Rule logic checks casing, allowed source/medium enums, forbidden characters, and campaign-name pattern.
  5. 5Rows are split into passed and failed buckets with a specific reason per failure.
  6. 6A formatted summary (counts plus the exact bad rows) is posted to a Slack channel so the team fixes them before go-live.

Set it up

What you configure once, before turning it on.

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