Unable to update relation in notion database

Hey, very new to n8n… So i am trying to make an automation so that when a google meeting is booked it automatically creates a “Meetings” database page in notion. This is happening no issue, the issue comes when i try and update that new meetings database page to have a relation related to the corresponding contact in my “Contacts” database. In the properties tab, i add in the relations property but i cannot see the contact to update.

What is the error message (if any)?

Currently no items exist

Please share your workflow


Information on your n8n setup

  • **n8n version: 1.80.3
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • **Running n8n via n8n cloud
  • **Operating system: Edition
    Windows 11 Home
    Version 23H2
    OS build 22631.4890
    Experience Windows Feature Experience Pack 1000.22700.1067.0

Hey @Bk33,

When trying to update a relation field in Notion you have to provide the ID of the related page. (In your case the Contact ID)

From your screenshot it is not clear what value you are putting but if it’s a contact name or email it is not going to work. To get the Contact ID you can add a search:Database node before the update to lookup the Contact ID by email, name etc.

Also for the relationship update to work make sure the Notion Integration you created for n8n has permissions for the Contacts as well.

Here is an example of how a create > lookup > update workflow.

If this doesn’t help please share your workflow I might be able to help more.

You can do that by selecting your nodes in n8n copying them and pasting them in your comment in a code block like this

Hey, Thanks!

I fixed that, but I am using the IF node to make it so that if a contact is already in the contacts database it is true, and then i have actions to create a new contact in the contacts database if it is false. My problem is that even if the contact already exists in the database it still continues down the false path and creates a new contact. here is my workflow:

That is my workflow, I am having a new problem now.

I made an IF node so that if the contact that is attending the meeting is already in my contacts database then it continues down the tue path. and if the contact that is attending the meeting is not in my contacts it continues down the false path which creates a new contact in the contact database. Right now though it continues down the false path no matter what. Even if the contact already exists in the database.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.