Search a Google Drive > Get a List of Folders > Check Against Notion > If the Name does Not exist in Notion - Add it as a field value in a drop down list

Hello Makers…
Stuck on this and wondering how i can tackle this

  1. I create a new folder of edit a folder
  2. This triggers a workflow in make to get the name of the folder
  3. Once I capture the name - i want to check in Notion if a drop down has the name of that folder or not
  4. If it does not - then create one
  5. if it got renamed - the update it
  6. if it exists and there is no change - then leave it

The end goal is
when a folder is created or renamed - want this to be a drop down list that has a current list of the folder names.

Hope someone can help :slight_smile:
D

Hi Dharm,
For the Notion part, you could use the “Get a database” module. That will return the database properties, including the dropdown menu. Within the dropdown menu, you will find its “options” (selectable values in Notion). You can compare those options with the folder name, and proceed accordingly.

Then you can use the “Update database property” Notion API endpoint to add a new select option if needed (Update database properties)

THank you SIMO
How do you ompare those options with the folder name, and proceed accordingly.?

You may add a filter in between the Modules that looks like this