← Back to Skills Marketplace
tomgranot

Fix Lifecycle Stages

by TomGranot · GitHub ↗ · v1.0.0 · MIT-0
cross-platform ⚠ suspicious
102
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install fix-lifecycle-stages
Description
Ensure all contacts and companies have appropriate lifecycle stages. Backfills missing stages via API, fixes records stuck at disallowed stages, and creates...
README (SKILL.md)

Fix Lifecycle Stages

Ensure every contact and company has an appropriate lifecycle stage. This includes backfilling missing stages, correcting disallowed stage values, and creating prevention workflows that automatically assign stages to new records.

Why This Matters

Records without a lifecycle stage are invisible in pipeline reports, excluded from stage-based workflows, and cannot be properly segmented. Even a small percentage of missing lifecycle stages corrupts funnel reporting and makes pipeline analytics unreliable. Lifecycle stage data is also a prerequisite for lead scoring models and lifecycle progression workflows.

Prerequisites

  • Phase 1 hygiene processes completed (invalid/deleted contacts removed first)
  • Access to Contacts and Companies with bulk edit permissions
  • Access to Automation > Workflows
  • Understanding of HubSpot's lifecycle stage progression rules (see Critical Concept below)

Critical Concept: Forward-Only Lifecycle Progression

HubSpot has forward-only lifecycle progression by default. The built-in order is:

Subscriber > Lead > MQL > SQL > Opportunity > Customer > Evangelist

To move a record from a later stage (e.g., "Other", "Evangelist") to an earlier one (e.g., "Lead"), you must:

  1. FIRST clear the lifecycle stage (set to blank/empty)
  2. THEN set the new value

A direct set to an earlier stage will be silently rejected — no error, no warning, the value simply does not change. This is the single most common gotcha when fixing lifecycle stages.

# WRONG — silently fails if current stage is "later" than target
api_client.crm.contacts.basic_api.update(
    contact_id=contact_id,
    simple_public_object_input={"properties": {"lifecyclestage": "lead"}}
)

# CORRECT — clear first, then set
api_client.crm.contacts.basic_api.update(
    contact_id=contact_id,
    simple_public_object_input={"properties": {"lifecyclestage": ""}}
)
api_client.crm.contacts.basic_api.update(
    contact_id=contact_id,
    simple_public_object_input={"properties": {"lifecyclestage": "lead"}}
)

Plan

  1. Audit missing and disallowed lifecycle stages (before state)
  2. Define which stages are "disallowed" for your business and map them to correct stages
  3. Fix contacts with disallowed stages (clear + re-set)
  4. Set missing stages to appropriate defaults based on associated company context
  5. Create prevention workflows for contacts and companies
  6. Verify 100% coverage (after state)

Before State

Audit Script

import os
from hubspot import HubSpot
from dotenv import load_dotenv

load_dotenv()
api_client = HubSpot(access_token=os.getenv("HUBSPOT_API_TOKEN"))

# Count contacts with no lifecycle stage
result = api_client.crm.contacts.search_api.do_search(
    public_object_search_request={
        "filterGroups": [{
            "filters": [{
                "propertyName": "lifecyclestage",
                "operator": "NOT_HAS_PROPERTY"
            }]
        }],
        "limit": 0
    }
)
print(f"Contacts missing lifecycle stage: {result.total}")

# Count contacts at each stage
stages = ["subscriber", "lead", "marketingqualifiedlead", "salesqualifiedlead",
          "opportunity", "customer", "evangelist", "other"]
for stage in stages:
    result = api_client.crm.contacts.search_api.do_search(
        public_object_search_request={
            "filterGroups": [{
                "filters": [{
                    "propertyName": "lifecyclestage",
                    "operator": "EQ",
                    "value": stage
                }]
            }],
            "limit": 0
        }
    )
    if result.total > 0:
        print(f"  {stage}: {result.total}")

# Repeat for companies
result = api_client.crm.companies.search_api.do_search(
    public_object_search_request={
        "filterGroups": [{
            "filters": [{
                "propertyName": "lifecyclestage",
                "operator": "NOT_HAS_PROPERTY"
            }]
        }],
        "limit": 0
    }
)
print(f"\
Companies missing lifecycle stage: {result.total}")

Define Disallowed Stages

Decide which lifecycle stage values should not exist in your database. The table below shows common examples -- your disallowed stages and their correct mappings will depend on how your organization uses the CRM. Review your own stage distribution and decide what makes sense for your business:

Example Disallowed Stage Common Reason Example Correct Stage
(empty/blank) Invisible to reports Lead (default)
Subscriber Often misapplied when not used for newsletter-only contacts Lead
Other Meaningless catch-all Lead
Evangelist Rarely used correctly in most organizations Customer (if actual customer) or Lead

These are starting-point examples only. Your mapping will differ based on your sales process, integrations, and how stages are currently used. Define your specific mapping before executing.

Execute

Step 1: Fix Contacts at Disallowed Stages

For contacts at "Subscriber", "Other", or "Evangelist" that should be moved to "Lead":

# Pattern: Clear then set (required for backward movement)
DISALLOWED_TO_LEAD = ["subscriber", "other", "evangelist"]

for stage in DISALLOWED_TO_LEAD:
    # Search for contacts at this stage
    # Paginate through all results
    # For each batch:
    #   1. Clear lifecycle stage (set to "")
    #   2. Set lifecycle stage to "lead"
    # Use batch API for efficiency (100 per call)
    pass

Important: The clear-then-set must happen as two separate API calls. You cannot clear and set in one call.

Step 2: Set Missing Contact Stages with Context

Do not set all missing contacts to "Lead" blindly. Check their associated company context:

  1. Contacts at Customer companies -> set to "Customer"
  2. Contacts at Opportunity companies -> set to "Opportunity"
  3. All remaining contacts -> set to "Lead"
# Pattern for context-aware assignment:
# 1. Search for contacts with no lifecycle stage
# 2. For each, get their primary associated company
# 3. Check the company's lifecycle stage
# 4. Set the contact's stage to match (or "lead" as default)

Manual approach via lists:

  1. Create a list: Lifecycle stage is unknown AND Associated company lifecycle stage is Customer -> bulk edit to "Customer"
  2. Create a list: Lifecycle stage is unknown AND Associated company lifecycle stage is Opportunity -> bulk edit to "Opportunity"
  3. Remaining contacts in the "no lifecycle stage" list -> bulk edit to "Lead"

Step 3: Fix Companies Without Lifecycle Stage

  1. Check companies with associated deals:
    • Companies with closed-won deals -> set to "Customer"
    • Companies with open deals -> set to "Opportunity"
  2. All remaining companies without a stage -> set to "Lead"

Step 4: Fix Stuck Records

Some records may fail to update due to the forward-only progression rule. Run a "fix stuck" script:

# Pattern: Find records that should be at a stage but are not
# For each:
#   1. Read current lifecycle stage
#   2. If current stage is "later" than target, clear first
#   3. Set the target stage

Step 5: Create Prevention Workflows

Contact prevention workflow:

  1. Go to Automation > Workflows > Create workflow
  2. Select Contact-based > Blank workflow
  3. Name: AUTO-FIX: Set Default Lifecycle Stage (Lead)
  4. Enrollment trigger: Contact property > Lifecycle stage > is unknown
  5. Enable re-enrollment
  6. Action: Set contact property > Lifecycle stage > Lead
  7. Activate and enroll existing contacts

Company prevention workflow:

  1. Create another workflow: Company-based > Blank workflow
  2. Name: AUTO-FIX: Set Default Company Lifecycle Stage (Lead)
  3. Enrollment trigger: Company property > Lifecycle stage > is unknown
  4. Enable re-enrollment
  5. Action: Set company property > Lifecycle stage > Lead
  6. Activate and enroll existing companies

Optional: Disallowed stage correction workflows:

If contacts keep getting set to disallowed stages (e.g., by imports or integrations):

  1. Create a workflow: Trigger = Lifecycle stage changed to "Subscriber" (or other disallowed value)
  2. Action 1: Clear lifecycle stage (set to blank)
  3. Action 2: Set lifecycle stage to "Lead"

This prevents disallowed stages from recurring.

After State

# Re-run the before-state audit
result = api_client.crm.contacts.search_api.do_search(
    public_object_search_request={
        "filterGroups": [{
            "filters": [{
                "propertyName": "lifecyclestage",
                "operator": "NOT_HAS_PROPERTY"
            }]
        }],
        "limit": 0
    }
)
print(f"Contacts missing lifecycle stage: {result.total} (should be 0)")

result = api_client.crm.companies.search_api.do_search(
    public_object_search_request={
        "filterGroups": [{
            "filters": [{
                "propertyName": "lifecyclestage",
                "operator": "NOT_HAS_PROPERTY"
            }]
        }],
        "limit": 0
    }
)
print(f"Companies missing lifecycle stage: {result.total} (should be 0)")

Verification checklist:

  1. 0 contacts with missing lifecycle stage
  2. 0 companies with missing lifecycle stage
  3. 0 contacts at disallowed stages (Subscriber, Other, Evangelist, or whatever you defined)
  4. Spot-check contacts from Customer sub-list -> their lifecycle stage is "Customer"
  5. Spot-check contacts from Opportunity sub-list -> their lifecycle stage is "Opportunity"
  6. Test the prevention workflow: create a test contact with no lifecycle stage, wait a few minutes, confirm it gets set to "Lead". Delete the test contact.
  7. Funnel reports now show all records with no "unknown" bucket

Key Technical Learnings

  • Forward-only progression is the biggest gotcha. Direct API updates to an "earlier" stage are silently rejected. You MUST clear first, then set. This applies to both API and workflow actions.
  • "Lead" is the safest default. It is early in the progression and will not block forward movement from workflows or deal progression. "Subscriber" is NOT a good default unless you know the contacts subscribed to a newsletter.
  • Context-aware assignment matters. Setting a contact at a Customer company to "Lead" instead of "Customer" degrades data quality. Take the time to check associated company context.
  • Prevention is more important than cleanup. The prevention workflows ensure the problem never recurs. Without them, new records from imports, integrations, or manual entry will immediately re-create the gap.
  • Lifecycle stage and deals interact. HubSpot can automatically advance lifecycle stage when deals are created or won. Your prevention workflows will not interfere because they only trigger when lifecycle stage is unknown.
  • Batch edit limitations. The UI may time out on very large bulk edits. Process one page at a time, or use the API approach for large volumes.
  • The sub-list approach is important. Do not skip context-aware assignment and set everyone to "Lead". Contacts associated with Customer or Opportunity companies deserve the correct stage.
Usage Guidance
This skill appears to actually do what its description says (audit and fix HubSpot lifecycle stages), but there are important inconsistencies you should address before using it: - Environment variable mismatch: the repository scripts expect a HUBSPOT_ACCESS_TOKEN (scripts) while SKILL.md examples reference HUBSPOT_API_TOKEN; the registry lists no required env vars. Confirm which env var the runtime will provide and update the skill or your environment accordingly. - Token scope and placement: the scripts load a .env file from the project parent directory. Ensure that file only contains the token intended for this script and no unrelated secrets. Use a least-privilege HubSpot token that only includes the scopes needed (CRM read/write and any workflow scopes required), and prefer a test/dev HubSpot account first. - Packaging/installation: there is no install spec. You will need Python (>=3.10) and to manually install dependencies (requests, python-dotenv) before running. Review and run the scripts locally or in a sandbox before giving the token to any automated system. - Backup and safety: the script performs bulk updates. It has a SAFETY_THRESHOLD (50,000) and rate-limit handling, but you should back up data and run the 'before' audit on a copy or limited subset first to validate behavior. - Audit outputs: the scripts write CSV audit trails into the scripts directory. Inspect these files and their storage location to avoid leaking sensitive contact data. If you decide to proceed: verify and rename or harmonize the expected env var, test in a non-production HubSpot account, limit the token scopes, and inspect the code to ensure the token is used only for the HubSpot API calls shown.
Capability Analysis
Type: OpenClaw Skill Name: fix-lifecycle-stages Version: 1.0.0 The skill bundle is a data hygiene tool for HubSpot CRM designed to audit and correct lifecycle stages for contacts and companies. The scripts (before.py, execute.py, and after.py) use standard HubSpot API endpoints to identify records in disallowed stages and perform bulk updates using a documented 'clear-then-set' pattern to bypass HubSpot's forward-only progression rules. There is no evidence of data exfiltration, malicious execution, or prompt injection; the code is well-structured, includes safety thresholds, and aligns perfectly with the stated purpose in SKILL.md.
Capability Assessment
Purpose & Capability
The name/description and the scripts all target HubSpot lifecycle-stage fixes — that is coherent. However, the registry metadata declared no required environment variables or primary credential, while every script expects a HubSpot API token. This mismatch is unexpected and should be resolved (the skill cannot operate without the token).
Instruction Scope
SKILL.md and the three scripts restrict actions to HubSpot's CRM API (search, batch update) and local CSV outputs. They read a .env file and an environment variable for the API token and write CSV audit files in the scripts directory. They do not call unknown third-party endpoints or attempt to read unrelated system files, but they do explicitly load a parent .env file which may contain other secrets — verify what will be present in that .env before running.
Install Mechanism
There is no install spec even though the package includes three Python scripts with dependency comments. That means the skill is instruction-only but ships runnable code; there's no automatic installation of dependencies. This is a packaging inconsistency you should be aware of (you'll need to install Python and the dependencies yourself before running).
Credentials
The scripts require a HubSpot token, but the registry lists no required env vars. Additionally, SKILL.md example code uses HUBSPOT_API_TOKEN while scripts use HUBSPOT_ACCESS_TOKEN — the env var name mismatch is a concrete inconsistency that could lead to misconfiguration or accidental token leakage. Aside from HubSpot, no other credentials are requested, and the token requirement is proportionate to the task if the token's scope is properly limited.
Persistence & Privilege
The skill does not request elevated platform privileges, does not set always:true, and does not modify other skills or global agent settings. It runs as an on-demand script and writes only local CSV audit files.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install fix-lifecycle-stages
  3. After installation, invoke the skill by name or use /fix-lifecycle-stages
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
- Initial release of fix-lifecycle-stages skill. - Audits and backfills missing lifecycle stage data for contacts and companies. - Fixes records stuck at disallowed or backwards stages using correct HubSpot progression logic. - Provides API scripts and manual list-based methods for context-aware stage assignment. - Includes guidance for creating prevention workflows to stop future lifecycle stage gaps.
Metadata
Slug fix-lifecycle-stages
Version 1.0.0
License MIT-0
All-time Installs 0
Active Installs 0
Total Versions 1
Frequently Asked Questions

What is Fix Lifecycle Stages?

Ensure all contacts and companies have appropriate lifecycle stages. Backfills missing stages via API, fixes records stuck at disallowed stages, and creates... It is an AI Agent Skill for Claude Code / OpenClaw, with 102 downloads so far.

How do I install Fix Lifecycle Stages?

Run "/install fix-lifecycle-stages" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is Fix Lifecycle Stages free?

Yes, Fix Lifecycle Stages is completely free, licensed under MIT-0. You can download, install and use it at no cost.

Which platforms does Fix Lifecycle Stages support?

Fix Lifecycle Stages is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created Fix Lifecycle Stages?

It is built and maintained by TomGranot (@tomgranot); the current version is v1.0.0.

💬 Comments