CRM
Nightly Attio Relationship-Decay Scorer
Every night, recomputes a relationship-strength score for each Attio company from how recently you last touched it across email, Slack, and calls.
How it runs
The automated pipeline, trigger to output.
- TriggerNightly schedule fires
- ActionFetch active companies from AttioAttio
- ActionQuery latest touch per channel in PostgresPostgres
- LogicCompute decayed score and assign tier
- ActionWrite score + tier back to AttioAttio
- OutputLog run summary to PostgresPostgres
What it does
This workflow keeps an honest, always-current relationship-strength number on every Attio company. It pulls the most recent interaction across each channel, applies time-based decay so stale relationships visibly cool off, and writes a single 0-100 score plus a tier (Hot / Warm / Cooling / Cold) back to Attio.
When to use it
Run it when your CRM's "last activity" field lies — it only reflects one channel, or it never decays so a deal from six months ago still looks active. Use this to get a defensible, multi-channel freshness signal that pipeline reviews and territory planning can trust.
How it works
- 1A nightly schedule fires the run.
- 2Pull all active companies from Attio with their linked person records.
- 3Query the interactions table in Postgres for the latest email, Slack, and call timestamp per company.
- 4Compute a decayed score: each channel contributes weighted points that halve over a configurable window, then sum and clamp to 0-100.
- 5Map the score to a tier and write both fields back to each Attio company.
- 6Log the run summary to Postgres for trend tracking.
Set it up
What you configure once, before turning it on.
- 1Connect AttioReal-time CRM with structured data + powerful views.
- 2Connect PostgresAny Postgres URL — query, write, migrate.
- 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 CRM workflows
Backfill Intercom conversation topics onto stale HubSpot contacts
Finds HubSpot contacts with no recent Intercom topic, pulls their conversation history from Intercom, classifies the dominant topic with OpenAI.
Daily orphaned-opportunity sweep with manager Slack digest
Each morning this scans Salesforce for open opportunities owned by inactive users and posts a per-manager digest in Slack listing the orphaned deals that need a new owner.
AI-Personalized Dormant Account Win-Back
On a dormancy anniversary, an agent researches the account's history and recent public signals, drafts a genuinely personalized win-back email.
Dormant Account Anniversary Re-engagement Email
Each day, finds Attio accounts whose last activity was exactly N months ago and sends each owner's contact a personalized re-engagement email from Gmail.
Dormant Account Check-In Call Scheduler
On the anniversary of an account's last touch, books a tentative check-in call on the owner's Google Calendar and emails the contact a scheduling invite.
Weekly Dormant-Anniversary Cohort Digest
Every week, groups dormant Attio accounts by which last-touch anniversary they hit that week, builds a prioritized digest.
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.