Updating a Notion Relation Field from Google Sheets

You have two Notion databases and have created a Relation field between them. Now, you want to update or change the Relation field data from Google Sheets. This tutorial will guide you through the process.

Step 1: Grant Notion Database Permissions to Addsync

Due to how Notion permissions work, you must grant access to both databases so that Addsync can read and write data to the Relation field. Without this permission, Relation and Rollup fields will not be visible on the Mapping page.

Here is a quick way to Grant Permission to Addsync:

1. Navigate to your Notion database page.

2. Click the three dots in the top-right corner.

3. Select "Connections", find "Addsync" (if it’s not visible, search for it), then click "Confirm".

Step 2: Create a Relation Column in Google Sheet

If you are creating a new sync connection with an empty Google Sheet, you can skip this step because Addsync will automatically create the column for you.

First Open your Google Sheet and add a new column for the Relation field, You can name the column anything (e.g., "Relation").

Open the Mapping window by clicking the "Edit" button.

Now from the Mapping Page map the two fields and select the flow direction "export" or "2way", so that when you change data in Google sheet it get reflected in Notion.

Click "Next", then "Done" to save the changes.

What to Enter in the Google Sheets Relation Column?

In Notion, when you create a Relation Field column, the values in that column are the other linked database's pages.

Here is an example of the other Notion Database, linked to a database which has an active connection to Google Sheets.

Here is what it looks like in the Main Notion Database. As you can see, the relation items are the pages of the other database.

Here is what it looks like in Google Sheets. Those weird-looking IDs are the page IDs of the other Notion Database.

To simplify, you have to write the page IDs of the other database in Google Sheets' "Relation" column so that the relation field in Notion updates accordingly.

Supported Data Formats in Google Sheets:

• Comma-separated Page IDs

  • Example: 1b483f3d-0c99-8087-bad1-d067045ed6a0

• Comma-separated Page URLs

  • Example: https://www.notion.so/Page-1-Row-1-1b483f3d0c998087bad1d067045ed6a0?pvs=4

How to Get a Page Link from the Other Database?

• Open the linked database in Notion.

• Click the six-dot icon in front of a page row.

• Click "Copy link" to get the page URL.

Note: Currently this process works perfectly if "the other Notion database" have less than 500 rows/pages. If you need to sync a larger database, contact us to discuss potential solutions.