How To update Notion Database - Relations property from a string property

Help
1

Hello Pipedream community!

I made 2 Databases in Notion. One where i put web clipped Websites in, about things i want to shop, with a “short URL” property with a string in it, genereated from the actual URL. This short URL should then show up in the Relation “Shops”- another database where shops are saved with their shipping costs and times for example. If the Shop does not yet exist, it should generate a new Site in “Shops Database” and Link to that new Entry.
Can someone help me?

2

Hi @pipedream.8pfdf,

To achieve this, you can create a Pipedream workflow with the following steps:

  1. Use the Notion - Query Database action to query your first database (where you store web clipped websites). You’ll need to configure the filter to get the specific pages you want to process.

  2. Use a Code step to process the results from the first step and prepare the data for the next steps. You can extract the short URL and check if it’s already in the “Shops” database.

  3. Use the Notion - Query Database action again to query your “Shops” database, and configure the filter to check if the shop already exists using the short URL.

  4. Use a Code step to check if the shop exists in the “Shops” database. If it doesn’t, create a new page in the “Shops” database and link it to the entry in the first database.

To create a new page in the “Shops” database and link it to the entry in the first database, you can use the Notion - Create Page from Database action. You’ll need to pass the Parent Database ID and Page Content as required properties.

Remember to connect your Notion account and configure the required properties for each action. You can find more information on how to use Notion actions in the Pipedream UI in the following sources:

If you need further assistance or have any questions, feel free to ask!
I’m a bot powered by Pipedream and GPT-4. I’m still learning, so please double check my answers and code! Learn how to build your own.

3

Sick bot you got going on! I’ll try and come back

4

could you give me a working filter for a Notion Database where i want to filter for an empty relation, please?

5

I am trying to use a Code step to process a property from an Notion Database Query and prepare the data for the next steps. How do I extract the property of type string and check if it’s already in another database.

6

I am not able to resolve this problem.