MARKETING
Sync Engagement-Decay Subscribers Into a HubSpot Suppression List
Twice weekly, identifies subscribers whose combined open and click engagement has decayed past a churn threshold in BigQuery and adds them to a HubSpot active list so marketing…
How it runs
The automated pipeline, trigger to output.
- TriggerTwice-weekly schedule
- ActionPull recent open/click activity per subscriberBigQuery
- LogicScore engagement and flag decayed subscribers
- LogicDiff flagged set against current list membership
- OutputSync additions and removals to HubSpot listHubSpot
What it does
This workflow keeps a HubSpot list continuously in sync with who is going cold. It computes a blended engagement score per subscriber from recent open and click behavior in BigQuery, identifies those whose score has decayed below your churn threshold, and pushes them into a designated HubSpot list. From there, your existing HubSpot automation can reduce send frequency or enroll them in a recovery sequence — no manual exports.
When to use it
Use it when HubSpot is your system of record for campaigns and you want decay signals to drive list membership automatically. Useful for protecting deliverability by quieting sends to disengaged contacts before they hurt your sender reputation.
How it works
- 1A twice-weekly schedule starts the run.
- 2BigQuery returns each subscriber's recent open and click activity over the scoring window.
- 3A logic step computes a blended engagement score and flags those past the decay threshold.
- 4A logic step diffs the flagged set against current list membership to find additions and removals.
- 5Flagged subscribers are added to the HubSpot active list, and recovered ones are removed, keeping the list accurate.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect HubSpotCRM, deals, marketing, support.
- 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.