← ClaudeAtlas

aggregate-topic-videos-into-a-searchable-content-tablelisted

Build a Zap on Zapier that watches YouTube for new videos matching a topic and adds each matching video as a row in a Zapier Tables content table, so the library stays searchable for tagging and editorial scheduling. Use when you curate videos on a topic and want them collected in one searchable table instead of saved by hand.
zapier/awesome-zaps · ★ 2 · AI & Automation · score 78
Install: claude install-skill zapier/awesome-zaps
# Aggregate topic videos into a searchable content table The Zap's code lives at https://github.com/zapier/awesome-zaps/tree/main/zaps/aggregate-topic-videos-into-a-searchable-content-table. Read the files there if this skill was installed on its own. ## What it does 1. **Trigger:** YouTube, New Video by Search (`youtube`, `video_search`). It fires for each new video uploaded that matches your topic search string. 2. **Filter:** the run continues only if the video title contains your keyword. Other videos are skipped without writing anything. 3. **Zapier Tables** creates one record in your content table with the video's title, channel name, permalink, publish date and description. ## 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 | | --------------- | ------------------------------------------------------------------------------------------- | | `TOPIC_QUERY` | The search string the YouTube trigger watches for new uploads: your topic | | `TITLE_KEYWORD` | A word the video title must contain for the video to be kept. Usually the same as the topic | | `TABLE_ID` | The content table in Zapier Tables that receives rows | The content table needs columns for title, channel, permalink, publish dat