Google Drive + Zapier Tables + Google AI Studio (Gemini) + Looping by Zapier + Formatter by Zapier
Extract Film Clapper Information to a Zapier Table
Anytime a new video file in folder is created in Google Drive, send prompt in Google AI Studio (Gemini), extract the following information, and log it in a Zapier Table.
Anytime a new video file in folder is created in Google Drive, send prompt in Google AI Studio (Gemini), extract the following information, and log it in a Zapier Table.
- When this happens...New File in Folder
Triggers when a new file is created within, moved to, or uploaded directly to a specific folder (but not its subfolders).
- automatically do this...Send Prompt
Sends a prompt and generates a response.
- then do this...Create Loop From Text
Creates a new Loop from text value(s) with a specified delimiter. This is an advanced action!
- then do this...Text
Work with text data to find & replace, capitalize, remove HTML, and more (with line-item support).
- then do this!Create Record
Creates a new record on a table.
- Free forever for core features
- 14 day trial for premium features & apps
About Google Drive
Google Drive is Google's file sync app that lets you store all of your files online alongside your Google Docs documents, and keep them synced with all of your devices.
Related categories
Similar apps
Dropbox
File Management & Storage
Box
File Management & Storage
OneDrive
File Management & Storage, Microsoft
About Zapier Tables
Zapier Tables is a no-code database built for automation.
Related categories
About Looping by Zapier
Looping by Zapier is a helper app to repeat Action(s) in you Zaps a variable number of times for sets of values.
Related categories
About Formatter by Zapier
Data isn't always in the format you need. Perhaps a date is in International format, but your app needs it in American format. Or maybe you need to Title Case a subject, truncate text for a Tweet, or turn Markdown text into HTML for your blog. Zapier's Formatter tool can help.