movie-list

star 1

Maintain Ben's movie list Google Sheet. Add movies to Watched or Wishlist, update viewing info, and query the sheet.

kip-claw By kip-claw schedule Updated 5/8/2026

name: movie-list description: Tracks the films Ben has watched and the ones he wants to see. tag: Lists metadata: {"openclaw": {"emoji": "๐ŸŽฌ", "requires": {"bins": ["gog"]}}}

Movie List Skill

Manages Ben's movie list Google Sheet: https://docs.google.com/spreadsheets/d/1AmRHTmZ8i4NPGEDeLoTkanp3Zw3QmhW8lI6W9fFLJcg/edit

Sheet Structure

Watched tab

Columns: Title, Released, Viewing, Venue, Rating, Notes

  • Title: Movie title
  • Released: Year the movie was released (e.g., 2025, 1928)
  • Viewing: Date watched (e.g., 3/14/2026, 2/14/2026)
  • Venue: Where it was watched (e.g., Streaming, Film Forum, Paris, theater name)
  • Rating: ๐Ÿ‘ (liked) or ๐Ÿ‘Ž (didn't like)
  • Notes: Brief review or comment

Wishlist tab

Columns: Likely Title and possibly Released or other metadata (similar to reading list wishlist)

  • Title: Movie title
  • Additional columns may exist but are not required

Commands

Add a watched movie

gog --no-input -a "$GOG_ACCOUNT" sheets append 1AmRHTmZ8i4NPGEDeLoTkanp3Zw3QmhW8lI6W9fFLJcg "Watched!A:F" \
  --values-json '[["Blue Moon","2025","3/14/2026","Streaming","๐Ÿ‘","Ethan Hawke talker set at Sardi\'s"]]' \
  --insert INSERT_ROWS

Add to wishlist

gog --no-input -a "$GOG_ACCOUNT" sheets append 1AmRHTmZ8i4NPGEDeLoTkanp3Zw3QmhW8lI6W9fFLJcg "Wishlist!A:B" \
  --values-json '[["Title","Released"]]' \
  --insert INSERT_ROWS

Query Watched movies

gog --no-input -a "$GOG_ACCOUNT" sheets get 1AmRHTmZ8i4NPGEDeLoTkanp3Zw3QmhW8lI6W9fFLJcg "Watched!A1:F20" --json

Query Wishlist

gog --no-input -a "$GOG_ACCOUNT" sheets get 1AmRHTmZ8i4NPGEDeLoTkanp3Zw3QmhW8lI6W9fFLJcg "Wishlist!A1:B20" --json

Search by title or year

Use gog --no-input -a "$GOG_ACCOUNT" sheets get with a larger range, then filter results in your script.

Workflow Rules

  • Always confirm before adding or moving movies
  • Viewing date: Use the actual date watched (MM/DD/YYYY format)
  • Venue: Ask if not specified; common values: Streaming, Film Forum, theater names
  • Rating: Ask Ben for ๐Ÿ‘ or ๐Ÿ‘Ž; don't assume
  • Notes: Keep brief, like the existing entries (1-2 sentences max)
  • Wishlist โ†’ Watched: When Ben watches a wishlist movie, move it (don't duplicate)

Examples

Add watched movie (2025, streaming, liked)

gog --no-input -a "$GOG_ACCOUNT" sheets append 1AmRHTmZ8i4NPGEDeLoTkanp3Zw3QmhW8lI6W9fFLJcg "Watched!A:F" \
  --values-json '[["Blue Moon","2025","3/14/2026","Streaming","๐Ÿ‘","Ethan Hawke talker set at Sardi\'s"]]' \
  --insert INSERT_ROWS

Add to wishlist

gog --no-input -a "$GOG_ACCOUNT" sheets append 1AmRHTmZ8i4NPGEDeLoTkanp3Zw3QmhW8lI6W9fFLJcg "Wishlist!A:B" \
  --values-json '[["Dune 3","2026"]]' \
  --insert INSERT_ROWS

Read recent watched movies

gog --no-input -a "$GOG_ACCOUNT" sheets get 1AmRHTmZ8i4NPGEDeLoTkanp3Zw3QmhW8lI6W9fFLJcg "Watched!A1:F10" --json

Notes

  • Sheet ID: 1AmRHTmZ8i4NPGEDeLoTkanp3Zw3QmhW8lI6W9fFLJcg
  • Title: "Ben's movie list"
  • Timezone: America/New_York
  • Requires gog with Sheets API access (service-level account context is preconfigured)
Install via CLI
npx skills add https://github.com/kip-claw/skills --skill movie-list
Repository Details
star Stars 1
call_split Forks 0
navigation Branch main
article Path SKILL.md
More from Creator