■Overview
This is a flow to store information of files stored in a specific folder on Google Drive into databases such as Yoom.
■Preparation
・Prepare databases such as Yoom database in advance to store values.
■Creation Method
① Select Google Drive from the app trigger, configure the following settings, and save.
・Trigger Action: When a new file or folder is created in a specific folder
・Trigger Interval: Set to the shortest interval of 5 minutes by default.
・Folder ID: Click the field and select the specified folder from the displayed options.
・Test: Store any file in the target folder once and test to retrieve information.
② Press the + mark under the trigger, select Google Drive from the operations to integrate with the app, configure the following settings, and test/save.
・Action: Download image files or PDF files
・File ID: Embed the output of the file ID obtained in step ① as {{File ID}}.
※ For settings on embedding outputs, please refer here. https://intercom.help/yoom/ja/articles/8223528
③ Press the + mark, select an operation to manipulate/transform data, configure the following settings, and test/save.
・Transformation Type: File name transformation
・Value for File Name Transformation: Select the file obtained from Google Drive from the options.
・Transformed File Name: Embed the output of the file name obtained in step ① as {{File Name}}.
・Output Name: Assign an easy-to-understand output name. (By default, it is labeled as "File after File Name Transformation")
④ Press the + mark, select Yoom from the operations to manipulate the database, configure the following settings, and test/save.
・Action: Add a record
・Project/Database/Table: Select up to the point where the desired table is included from each hierarchy.
・Values for the Record to be Added: Embed the file name or URL obtained in step ① and the file obtained in step ③ according to the displayed item names.