aggregate-topic-videos-into-a-searchable-content-tablelisted
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