How to synchronize data between two Notion databases
Use case overview
Even though Notion's databases are very flexible, there's a gap in the ability to synchronize databases and impose view and edit permissions to specific users to certain rows and columns.
Using resynced.io, you can sync two Notion databases. This functionality helps share specific information and maintain consistency across multiple databases and even between different Notion accounts.
You can now have all specific data in one place and communicate parts of the data with your clients or vendors without sharing the entire database with them.
Prepare your data
Ensure both databases have columns you want to sync. resynced.io does not create columns automatically. The column names don't have to be identical.
Add necessary values for select-type fields (e.g., Status, Select). resynced.io does not automatically create these either.
Select a platform, accounts, and a source
To sync two Notion databases within the same account or between two Notion accounts, select Notion on both sides.
Click "Add new connection" and select the pages you want to sync. Ensure you include all databases you might need later, this will let you reuse the connection for future syncs. To sync databases between two different Notion accounts, connect each account separately in resynced.io.
Then, pick the Notion database to sync. If you just created a connection with access to many databases, Notion's API may take a few minutes to load them. If your database isn't visible, wait 5–10 minutes and click "Refresh".
Filters (optional)
By default, resynced.io syncs all items. Use filters to sync only specific items.
Select the column you want to filter, set filters like "equals" or "does not equal," and enter a value.
Always match the values exactly as they appear in the source. Pay attention to capitalization. For example, if the status is "Done," filtering by "done" won't work as expected.
Item creation and deletion
By default, item creation is enabled only for the left source. New items added in the left source will appear in the right source. You can change this setting to allow item creation in both directions. You can also enable item deletion for one or both apps.
Map fields, sync direction, start synchronization
Map corresponding fields between two databases.
Ensure column types align to avoid errors. You can sync identical column types (e.g., number to number, text to text, date to date) or convert most column types into text (e.g., number to text, date to text, checkbox to text). However, some conversions, like syncing a Date column into a Numbers column, won't work and will cause an error. If the types don't match, the sync will fail, and you'll see an error message.
The Formula column is read-only, so you can't sync a formula column to another formula column. If you need to sync a Formula column in Notion, ensure you specify the data type it produces (e.g., number, text, date). You can then sync it as a text number or date accordingly.
More information about supported column types can be found here.
If you add a new status or select option in one Notion database, you must manually map it in resynced.io to ensure it syncs correctly. New options won't be mapped automatically. For example, if you add a new status like "In Review" in one database in Notion, resynced.io won't sync it unless you go into the mapping settings and match it to a status in the other database. If you skip this step, the new status won't transfer properly.
You can also set the sync direction one-way or two-way for each column.
Click "Save and Run" to begin. Syncs run automatically every 10 minutes, or you can trigger a sync manually by clicking Sync Now in resynced.io.
Was this guide helpful?
Let us know at hi@resynced.io
Similar guides
How to synchronize data between two Notion accounts
How to synchronize Notion database and monday.com board
How to synchronize Notion database with Google Sheets
