3/17/2024 0 Comments Airtable zapier one drive![]() This triggers on any new File added to Google Drive. In other words, if I added a folder of five parts, the Zap would not trigger.įor my workflow, I used the New File trigger. The catch here is that the Zap will only trigger on files added to that specific folder, it will not trigger on subfolders. If you’d like to trigger on a specific folder, you can select New File in Folder. The first step is to create our Google Drive trigger. ![]() I created a Zap that triggers on a New File in Google Drive, parses the part details from the file name, creates new Records in Airtable, and pings our group Slack so we can manually add finer details to the newly created records. I created a new folder in Google Drive for our music library, and I would add the files for the database to that folder. The database also contains a Works record for each piece, and details attributes like work length and musical style.Įntering this information manually would take, for lack of a better term, FOREVER. We decided to create an Airtable database that contains a single record for each part with a direct link to the Google Drive file. The challenge with a large library is that it can be difficult to browse and find results that match a given set of attributes. ![]() This is an arrangement of a popular ballad, from a movie, about 3 minutes long, etc. For example, let’s think about “Somewhere Over the Rainbow”. We keep a folder with the title of the work, and each folder contains five PDF files for each part.Īny given work also has a number of attributes that are impossible to capture in a single file name. ![]() So for a standard brass quintet, there will be five “parts” for each work: Trumpet 1, Trumpet 2, Horn, Trombone, and Bass Trombone (Tuba). A “work” (a song) consists of parts for each member of the group. Or have you thought about doing a file reorganization project, and wondered if there’s a way to automate a record of which files have been added to the new folder?įolks with large collections of video files, audio files, or other libraries of information often try to use nesting folders in a Drive to keep things organized, but it can be hard to browse through items that meet certain criteria.įor example, my brass quintet has a large library of sheet music. Background Infoĭo you have a lot of files in your Google Drive, but you can never find what you’re looking for? Hi there, this is Erin Oz from the Premier Support Team with a workflow idea to share. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |