I keep a list of YouTube videos I’ve watched and found worth remembering — with a short summary and tags so I can find them again.
The list is maintained in a Google Sheet. The sheet must be shared so “Anyone with the link can view”. The site is static (e.g. GitHub Pages): the sheet is fetched at build time and saved as data/youtube-videos.json. Run npm run sync-youtube-videos before generate (or rely on the build script). Share the sheet so anyone with the link can view, and set NUXT_PUBLIC_GOOGLE_SHEET_ID_VIDEOS in your env (e.g. GitHub Actions secrets).
Sheet columns:
- Title — video title
- Video URL — full YouTube link
- Channel — channel name
- Summary — short summary (Markdown supported: **bold**, lists, links, etc.)
- Tags — comma-separated (e.g. productivity, coding)
- Watched Date — when you watched it (any date format)
Sheet ID is in the URL: .../d/SHEET_ID/edit. See docs/youtube-videos-google-sheet-setup.md for full setup.