This val summarizes recent events on Attio lists on Slack

This project receives Attio webhooks, verifies and processes them, and stores events, messages, and list entry state data in SQLite. A scheduled cron job uses then periodically sends summaries with these stored messages to Slack.

1. Remix this val
2. Get a Slack webhook & set it as SLACK_WEBHOOK_URL in this val's Environment variables in the left sidebar
3. Get an Attio Access Token (with all read & write permissions) & set it as ATTIO_API_KEY in this val's Environment variables in the left sidebar
4. Set config.workspaceName in config.ts to the name of your Attio workspace
5. For each list you want to get notifications about, add an object to the config.lists array in config.ts. This object must contain a listId, notificationHeader, and objectName.
   1. To find your list's id, navigate to the list and copy the path segment after collection: https://app.attio.com/<workspaceName/collection/<listId>.
   2. The notificationHeader is the header that will appear in slack.
   3. objectName is the singular name of the object that list entries in the target list are a instances of. If you're unsure, navigate to the record for one of the list entries and copy the path segment after your workspace's name: https://app.attio.com/<workspaceName/<objectName>/<record_id>
6. Go to setup.ts and click run to set up the events database and Attio webhook
7. Go to alert.ts and click run to set up the cron job
8. Go trigger some Attio events and see the message in Slack!

If you want to get notifications about more than one list from your workspace, simply add another listConfig object to the lists array in config.ts the same way as you did in step 5, above.

Then, go to add-list.ts](./scripts/add-list.ts) and run the script. This will initialize the list in SQLite.

attio-slack-summaries/
├── webhook.ts                    # Main HTTP endpoint - receives Attio webhooks via Hono framework
├── config.ts                    # Configuration - workspace name & list IDs for different CRM lists
├── README.md                    # Documentation - setup instructions & file explanations
├── services/
│   ├── alert/
│   │   └── alert.ts            #  Cron job - processes recent events & sends Slack summaries
│   ├── attio/
│   │   ├── webhook.ts          #  Attio webhook management - creates/stores webhook configs
│   │   └── utils.ts            #   Attio API utilities & helpers
│   ├── auth.ts                 #  HMAC signature verification for webhook security
│   └── webhook/
│       └── handle-webhook.ts    #  Webhook event processing logic
├── shared/
│   ├── slack.ts               #  Slack integration - message formatting & webhook sending
│   ├── format.ts              #  Message formatting utilities for human-readable text
│   ├── enrich-entry.ts        #  Data enrichment for CRM entries
│   └── initialize-entries.ts  #  Entry initialization logic
│
├── types/
│   ├── index.ts              # Core application types
│   └── webhook.ts            #  Attio webhook payload type definitions
│
├── database/                  #  Data persistence layer
│   ├── schema.ts             #   SQLite table definitions (events, messages, entries)
│   └── sqlite.ts             #  Database operations - CRUD for webhook events & messages
│
└── scripts/
    ├── setup.ts              # One-time setup - creates DB tables & Attio webhook
    └── add-list.ts           #  Add new CRM list configuration