/master-schedule — Sheet Setup Check

Called automatically by all product skills before reading or writing. Can also be run manually to reconnect or reset.

Template sheet ID:

1mWnExnSWTKJv0vbu1mDnrQFmv_Iz_fNklIeuBYfMB5k

Step 1: Check for canoa.json

cat ./canoa.json 2>/dev/null

Found and valid → Step 2 (verify access)

Not found → Step 3 (auto-setup)

Step 2: Verify Sheet Access

Call

mcp__google-sheets__list_sheets

master_sheet_id

canoa.json

• Success → sheet is accessible. Return silently — the calling skill continues.
• 404 / error → sheet was deleted or moved. Proceed to Step 3 to set up a new one.

Step 3: Auto-Setup

No config found or sheet inaccessible. Set up automatically without asking the user.

3a: Copy the template

Attempt to copy the template sheet using the Google Drive API (

files.copy

drive.files.copy
  fileId: "1mWnExnSWTKJv0vbu1mDnrQFmv_Iz_fNklIeuBYfMB5k"
  title: "Product Library — {today's date}"

If no Drive copy tool is available, fall back to creating a new spreadsheet and writing the header row:

1. Call

   mcp__google-sheets__create_spreadsheet

   with title

   "Product Library — {today's date}"

2. Write the 33-column header row to

   Sheet1!A1:AG1

   using the CSV header from

   ../../schema/product-schema.md

Note in

canoa.json

"setup": "copy"

"setup": "fresh"

3b: Identify the Products tab

Look for a tab named

Products

Sheet1

canoa.json

3c: Write canoa.json

{
  "master_sheet_id": "{new sheet ID}",
  "sheet_title": "Product Library — {date}",
  "sheet_url": "https://docs.google.com/spreadsheets/d/{id}",
  "products_tab": "Products",
  "project_name": "",
  "setup": "copy",
  "created_at": "{ISO timestamp}"
}

3d: Notify the user

✓ Product library created and connected.
  docs.google.com/spreadsheets/d/{id}

  You may want to rename this sheet and set a project name.
  Run /master-schedule to update.

Then return — the calling skill continues.

Manual Run

When invoked directly (

/master-schedule

• If

  canoa.json

  exists and the sheet is accessible, show current status:

Product library connected.

  Project:  {project_name or "(unnamed)"}
  Sheet:    {sheet_title}
  URL:      docs.google.com/spreadsheets/d/{id}
  Tab:      {products_tab}

Options:
  1. Update project name
  2. Connect a different sheet (paste URL)
  3. Reset (create a new copy of the template)

• If user chooses (2), ask for URL, validate, update

  canoa.json

  .
• If user chooses (3), run Step 3 again.

MCP Connection Errors

If any MCP call fails with "tool not found" or auth error, stop and report:

Google Sheets MCP is not connected or not authenticated.

To connect it, add to ~/.claude/mcp_settings.json:

{
  "mcpServers": {
    "google-sheets": {
      "command": "npx",
      "args": ["-y", "@modelcontextprotocol/server-google-sheets"],
      "env": {
        "GOOGLE_SERVICE_ACCOUNT_KEY": "<path-to-service-account-json>"
      }
    }
  }
}

Then restart Claude Code and try again.
Need help creating a service account? Ask for instructions.

Edge Cases

canoa.json

canoa.json

canoa.json

canoa.json

canoa.json