MARKETING

Pre-Launch Scan of Campaign Assets in a Google Drive Folder

On a schedule, it scans a Google Drive launch folder for new or changed campaign creatives, extracts embedded UTM links, flags any that fail your tagging rules.

CategoryMarketing
Enginesim
Difficultyintermediate
Triggerschedule
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerScheduled scan (weekday mornings)
  • ActionList recently changed files in Drive launch folderGoogle DriveGoogle Drive
  • ActionRead each file and extract UTM-tagged URLsGoogle DriveGoogle Drive
  • LogicValidate every link's UTM parameters and naming
  • LogicBranch: separate clean files from files with issues
  • OutputPost consolidated QA summary to SlackSlack

What it does

Watches a designated Google Drive 'Launch Ready' folder and audits the campaign assets sitting in it. It reads each document or creative brief, pulls out every UTM-tagged link, checks the tags against your standard, and produces one consolidated report of which files are clean and which need fixes — delivered to the team channel before anyone hits publish.

When to use it

Use it when creative and copy live as files in Drive rather than rows in a database, and you want a recurring sweep that catches broken UTMs before launch day instead of after the campaign is live.

How it works

  1. 1A schedule (for example each weekday morning) triggers the run.
  2. 2The flow lists files in the Drive launch folder modified since the last scan.
  3. 3It reads each file's content and extracts all UTM-tagged URLs.
  4. 4A validation step checks every link for required, well-formed parameters and consistent campaign naming.
  5. 5A branch separates clean files from files with issues.
  6. 6A single Slack summary is posted listing each file, its status, and the specific UTM problems found.

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.