create-consolidated-okr-metrics-list-for-program-teamslisted
Install: claude install-skill zapier/awesome-zaps
# Create consolidated OKR metrics list for program teams
The Zap's code lives at https://github.com/zapier/awesome-zaps/tree/main/zaps/create-consolidated-okr-metrics-list-for-program-teams. Read the files there if this skill was installed on its own.
## What it does
1. **Start:** no trigger. The Zap runs on demand, started by hand or called from another Zap that needs the list.
2. **Airtable** reads every record from the OKR metrics table, across all pages of results.
3. The Zap drops empty and duplicate record IDs, then returns one comma-separated string of the remaining IDs, with a count.
The Zap only reads from Airtable and never changes the table.
## Ask the user
Each `REPLACE_…` value is set per person. Resolve names to IDs with the user's own connections; don't ask them to paste an ID you can look up.
| Setting | What goes there |
| ---------- | ---------------------------------------------------------------------------- |
| `BASE_ID` | The Airtable base that holds the OKR metrics (its ID starts with `app`) |
| `TABLE_ID` | The table in that base that holds the OKR metrics (its ID starts with `tbl`) |
## Build it
Build with Zapier MCP. If the user wants the Zap kept in their project, copy this folder into `zaps/` there first, then deploy those files. No Zapier MCP tools? Read https://docs.zapier.com/mcp/get-started/quickstart.md and follow the page for the app you are running in to get the u