Notify Slack when a HubSpot deal over $50K is created using a Claude Code skill

mkdir -p .claude/skills/large-deal-alert/{templates,references}

.claude/skills/large-deal-alert/
├── SKILL.md                          # workflow guidelines + config
├── templates/
│   └── slack-alert.md                # Block Kit template for Slack messages
└── references/
    └── hubspot-deals-api.md          # HubSpot API patterns

---
name: large-deal-alert
description: Check for recently created HubSpot deals over a threshold amount and post alerts to Slack
disable-model-invocation: true
allowed-tools: Bash, Read
---
 
## Goal
 
Check for HubSpot deals created in a given time window (default: last 1 hour) with an amount exceeding a threshold (default: $50,000) and post a formatted alert per deal to a Slack channel.
 
## Configuration
 
Read these environment variables:
 
- `HUBSPOT_ACCESS_TOKEN` — HubSpot private app token (required)
- `SLACK_BOT_TOKEN` — Slack bot token starting with xoxb- (required)
- `SLACK_CHANNEL_ID` — Slack channel ID starting with C (required)
- `HUBSPOT_PORTAL_ID` — HubSpot portal ID for building deal links (optional)
 
Default lookback window: 1 hour. Default amount threshold: $50,000. The user may request different values.
 
## Workflow
 
1. Validate that all required env vars are set. If any are missing, print which ones and exit.
2. Calculate a cutoff timestamp for the lookback window.
3. Search for deals created after the cutoff with amount exceeding the threshold using the HubSpot CRM Search API. See `references/hubspot-deals-api.md` for the request and response format.
4. For each matching deal, post a message to Slack using the Block Kit format in `templates/slack-alert.md`.
5. Print a summary of how many alerts were posted.
 
## Important notes
 
- HubSpot's CRM Search API expects date filter values as Unix timestamps in **milliseconds** (multiply seconds by 1000).
- The `amount` filter value must be a string (e.g., `"50000"` not `50000`).
- Some deals are created without an amount — the search API's GT filter will exclude them automatically.
- `SLACK_CHANNEL_ID` must be the channel ID (starts with `C`), not the channel name. The `chat.postMessage` API requires the ID.
- The Slack bot must be invited to the target channel or `chat.postMessage` will fail with `not_in_channel`.
- Use `urllib.request` for HTTP calls (no external dependencies required).

# Slack Alert Template
 
Use this Block Kit structure for each large deal alert.
 
## Block Kit JSON
 
```json
{
  "channel": "<SLACK_CHANNEL_ID>",
  "text": "New large deal: <deal_name> ($<amount>)",
  "blocks": [
    {
      "type": "header",
      "text": {
        "type": "plain_text",
        "text": "New Large Deal Created"
      }
    },
    {
      "type": "section",
      "fields": [
        { "type": "mrkdwn", "text": "*Deal:*\n<deal_name>" },
        { "type": "mrkdwn", "text": "*Amount:*\n$<amount>" }
      ]
    },
    {
      "type": "actions",
      "elements": [
        {
          "type": "button",
          "text": { "type": "plain_text", "text": "View in HubSpot" },
          "url": "<hubspot_link>"
        }
      ]
    }
  ]
}
```
 
## Notes
 
- The top-level `text` field is required by the Slack API as a fallback for notifications and accessibility. Always include it.
- The HubSpot link format: `https://app.hubspot.com/contacts/<PORTAL_ID>/deal/<DEAL_ID>` (if portal ID is set) or `https://app.hubspot.com/contacts/deal/<DEAL_ID>`.
- Format the amount with comma separators (e.g., $85,000 not $85000).
- To customize, you can add fields like deal owner, stage, or pipeline name.

# HubSpot Deals API Reference
 
## Search for recently created deals by amount
 
Use the CRM Search API to find deals created after a cutoff date with an amount exceeding a threshold.
 
**Request:**
 
```
POST https://api.hubapi.com/crm/v3/objects/deals/search
Authorization: Bearer <HUBSPOT_ACCESS_TOKEN>
Content-Type: application/json
```
 
**Body:**
 
```json
{
  "filterGroups": [
    {
      "filters": [
        {
          "propertyName": "createdate",
          "operator": "GTE",
          "value": "<cutoff_timestamp_ms>"
        },
        {
          "propertyName": "amount",
          "operator": "GT",
          "value": "<threshold>"
        }
      ]
    }
  ],
  "properties": ["dealname", "amount", "hubspot_owner_id", "createdate", "dealstage"],
  "limit": 100
}
```
 
- `value` for `createdate` is a Unix timestamp in **milliseconds** (multiply seconds by 1000).
- `value` for `amount` must be a string (e.g., `"50000"` not `50000`).
- `limit` max is 100. If there are more results, use the `after` cursor from `paging.next.after` in the response to paginate.
- Filters within the same filter group use AND logic — both conditions must be true.
 
**Response shape:**
 
```json
{
  "total": 2,
  "results": [
    {
      "id": "12345",
      "properties": {
        "dealname": "Acme Corp Enterprise License",
        "amount": "85000",
        "hubspot_owner_id": "67890",
        "createdate": "2026-03-05T14:30:00.000Z",
        "dealstage": "qualificationscheduled"
      }
    }
  ],
  "paging": {
    "next": {
      "after": "100"
    }
  }
}
```
 
## Notes
 
- Deals created without an `amount` property are automatically excluded by the GT filter.
- The `hubspot_owner_id` is a numeric ID. To get the owner's name, call `GET /crm/v3/owners/{owner_id}`.
- `createdate` is set automatically by HubSpot at deal creation time and cannot be manually overridden.

/large-deal-alert

Checking for deals over $50,000 created in the last 1 hour(s)...
  Found 2 large deal(s)
  Posted: Acme Corp Enterprise License ($85,000)
  Posted: Widget Inc Annual Contract ($72,000)
Done. Posted 2 alert(s) to Slack.

# Run every hour on the hour
0 * * * * cd /path/to/your/project && claude -p "Run /large-deal-alert" --allowedTools 'Bash(*)' 'Read(*)'

name: Large Deal Alerts
on:
  schedule:
    - cron: '0 * * * *'  # Every hour
  workflow_dispatch: {}   # Manual trigger for testing
jobs:
  alert:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v4
      - uses: anthropics/claude-code-action@v1
        with:
          prompt: "Run /large-deal-alert"
          allowed_tools: "Bash(*),Read(*)"
        env:
          ANTHROPIC_API_KEY: ${{ secrets.ANTHROPIC_API_KEY }}
          HUBSPOT_ACCESS_TOKEN: ${{ secrets.HUBSPOT_ACCESS_TOKEN }}
          SLACK_BOT_TOKEN: ${{ secrets.SLACK_BOT_TOKEN }}
          SLACK_CHANNEL_ID: ${{ secrets.SLACK_CHANNEL_ID }}