mcp-sheet-cache-bridge
Keep Zapier Tables or another MCP-connected record store as the source of truth while Google Sheets-based tools read an event-driven cache tab.
npx skills add zapier/gtm-cheat-codes --skill mcp-sheet-cache-bridge --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# MCP Sheet Cache Bridge Use this skill when a team wants Zapier Tables to be the source of truth but still needs Google Sheets-based tools, scripts, dashboards, or exports to read a simple tab. ## What This Skill Does 1. Designs a cache tab schema that mirrors only the fields downstream tools need. 2. Builds an event-driven sync pattern from the source record store to Google Sheets. 3. Uses create, update, and delete logic keyed by a stable record ID. 4. Points legacy consumers at the cache instead of direct API reads. 5. Documents the field map and cutover plan so the sync stays maintainable. ## When You Need This Pattern - A team replaced a multi-tab spreadsheet with Zapier Tables but still has Apps Script, Looker Studio, formulas, or exports reading Google Sheets. - A Slack pinned digest or daily report needs fresh rows without running a scheduled full refresh. - Scheduled syncs would create too many unnecessary tasks. - Existing tools can read Google Sheets easily but do not have direct access to the source record store. - The team wants one source of truth with a cheap, stable read path. ## Architecture ```text Zapier Tables source of truth -> event-driven cache sync on recor
- What This Skill Does
- When You Need This Pattern
- Architecture
- Required Connections Through Zapier MCP
- Cache Sync Rules
- Cache Tab Columns
- Task Budget Pattern
- Zapier MCP And SDK Role
- Guardrails
- Inspired By
What does the mcp-sheet-cache-bridge skill do?
Keep Zapier Tables or another MCP-connected record store as the source of truth while Google Sheets-based tools read an event-driven cache tab.
How do I install it?
Run `npx skills add zapier/gtm-cheat-codes --skill mcp-sheet-cache-bridge --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From zapier/gtm-cheat-codes, a repository with 318 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.