MARKETING
Scheduled UTM Sweep of Campaign Spreadsheets in Drive
Runs on a schedule, scans campaign-link spreadsheets in a Google Drive folder, audits every URL's UTM parameters.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily schedule before the send window
- ActionList and read campaign spreadsheets in Drive folderGoogle Drive
- LogicExtract URLs and parse UTM parameters
- LogicFlag malformed, missing, or duplicate tracking
- OutputPost grouped issue digest to SlackSlack
What it does
On a recurring schedule, this workflow opens each campaign spreadsheet in a designated Google Drive folder, reads every URL, and audits its UTM parameters. It produces a consolidated report of every offending link grouped by file.
When to use it
Use it when campaign links live in shared spreadsheets that many people edit and no single tool owns. A nightly or pre-send sweep catches drift across all of them at once instead of relying on per-row checks.
How it works
- 1Schedule trigger fires daily before the morning send window.
- 2A Google Drive action lists and reads the spreadsheet files in the target campaign folder.
- 3A logic step extracts all URLs and parses their UTM parameters.
- 4A logic step flags rows with missing required params, spaces, mixed case, or duplicate utm_campaign values across sheets.
- 5A Slack output posts a digest naming each file, the row, and the exact issue, with a clean-vs-flagged count summary.
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
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.
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.
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.
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.
Weekly Brand-Mention Provenance Digest to Notion
Aggregates the week's tracked mentions from Airtable into a single summarized report covering new opportunities, authority distribution, and outreach progress.
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.