← ClaudeAtlas

create-consolidated-okr-metrics-list-for-program-teamslisted

Build a Zap on Zapier that collects every OKR metric record from an Airtable table, removes empty and duplicate record IDs, and returns one comma-separated list for program-team reporting. Use when a product operations team tracks OKR metrics in Airtable and needs a single consolidated ID list for downstream zaps or reports.
zapier/awesome-zaps · ★ 2 · AI & Automation · score 78
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