add-new-uploaded-videos-to-content-planning-sheetlisted
Install: claude install-skill zapier/awesome-zaps
# Add new uploaded videos to content planning sheet
The Zap's code lives at https://github.com/zapier/awesome-zaps/tree/main/zaps/add-new-uploaded-videos-to-content-planning-sheet. Read the files there if this skill was installed on its own.
## What it does
1. **Trigger:** a new file appears in the staging folder in Google Drive (`google-drive`, `file_in_folder_v2`). Subfolders are not searched.
2. **Filter:** the file continues only if its MIME type starts with `video/`. Anything else stops the run and writes nothing.
3. **Google Sheets** looks for a row whose title column already holds the file name. If one exists, the run stops, so a file is never logged twice.
4. **Google Sheets** creates a row: the file name in the title column, the upload time in the date column, and the file link in the asset location column.
The Zap only adds rows to the sheet. It never changes or moves the file in Drive.
## 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 | Where | What goes there |
| ------------------- | --------------------------------------------------------- | ----------------------------------------------------------------------------------------------------- |
| `STAGING_FOLDER_ID` | `config.ts`, and `folder