Hi everyone,
I’m working on an automation project where I want to dynamically monitor files in newly created folders within Google Drive and sync them with Notion. The process starts with monitoring a parent folder for newly created subfolders (e.g., folders with a date), then I need to:
- Create a corresponding database item in Notion for the new folder.
- Dynamically monitor files within that specific folder as they are uploaded.
- Creates a new Database in the new Database item I just created monitor the newly created folder
- Sync each file (name, URL, etc.) to the new Notion database, each file is a new database item
The main challenge I’m facing is dynamically setting up file monitoring for each newly created folder. After detecting and logging the new folder, how do I set the automation to monitor only the files within this newly created folder (instead of a static folder) and ensure it runs dynamically for every new folder I create?
Any suggestions or best practices would be greatly appreciated!