← ClaudeAtlas

add-new-uploaded-videos-to-content-planning-sheetlisted

Build a Zap on Zapier that logs each new video dropped into a staging folder as a row in a content planning sheet, with its file name, upload time and link. Use when a marketing or content team uploads social videos to a shared folder and wants them listed in a planning sheet for scheduling and approval without manual entry.
zapier/awesome-zaps · ★ 2 · AI & Automation · score 78
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