Project managment - Google drive to Notion

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:

  1. Create a corresponding database item in Notion for the new folder.
  2. Dynamically monitor files within that specific folder as they are uploaded.
  3. Creates a new Database in the new Database item I just created monitor the newly created folder
  4. 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!

What types of changes would you like to moniter? Adding/ removing of files, changes to file content, etc.

Yeah mainly, adding and removing files

I want to have synchronized database in my Notion with the actual files in Drive, I need to update the database everytime a change happens (file added,removed, name change)

In the Notion database I need these atributes → Name of the file, URL of the file

Can you help me?

Instead of watching for changes within a folder it might be more efficient to have the changes added to the database when the files are added/removed/renamed through an automation.

Setup a workflow process where any changes to a file is done via automation. T hen within that automation you can have any updates to the file be updated in the database.

Otherwise using the google drive modules your limited to only making updates to the database when a file is added or removed. Not to mention that you will need to watch each individual folder which can rack up alot of operations.

Hope this helps!