How to synchronize Notion database with Google Sheets

Overview

By enabling two-way sync between Notion and Google Sheets, teams can keep all critical data up-to-date and accessible across both platforms. This allows for powerful analysis and reporting in Sheets—complete with formulas, pivot tables, and charts—while maintaining a central database of records in Notion. External stakeholders can interact with data in Sheets without needing direct access to Notion, and any changes are automatically reflected back in Notion. Overall, it eliminates manual data transfers, prevents discrepancies, and ensures consistent information for everyone involved.

Connect your accounts

In resynced.io, select Notion and Google Sheets as the apps to sync.

If it is your first time setting sync for Notion and Google Sheets in resynced.io, you need to authorize the platform to both your accounts.

In order to authorize Notion, you need to click "Add new connection", and select pages in Notion you'd like to give access to. When selecting pages, select all databases in Notion you potentially would like to sync in resynced.io. It would help you to reuse this connection in all subsequent syncs.

Pick the Notion database you'd like to sync. If you just created a connection, and the connection received access to lots of Notion databases, it will take some time for Notion API to provide a list for all databases. Thus, you may not immediately see the desired database in the list. Wait for 5-10 minutes and click "Refresh".

To authorize Google Sheets, click "Add new connection" as well, and give the requested permissions. Don't worry, resynced.io won't get access to your entire Google Drive, only to those files that you will select later when setting your sync. After that, select the file you'd like to sync and the sheet in it.

Match your data

In the “match by” section, select a field that contains unique values to match data between the apps. This is like a unique ID that helps the system know which items in monday.com correspond to the records in the Notion database. Every value in this field needs to be unique. If two items have the same value, synchronization will not run, but your data will not corrupt. The system will notify you and show you where the problem is.

If you don't want to automatically create new items in the Notion database but only in Google Sheets and you have an empty spreadsheet, a good idea is to create a column in Google Sheets and call it something like "Notion Page ID" and match it with "Page ID" field in Notion. Then, the system would bring all records from Notion to Google Sheets, will keep those in sync, and create new rows whenever needed.

For all other use cases, pick non-read-only fields for the sync.

Enable item creation or deletion

By default, item creation and deletion are turned off. You can enable resynced.io to:
· Create new records in the Notion database when they are added to Google Sheets, vice versa, or both.
· Similarly, you can define whether resynced.io should delete records in Google Sheets or Notion when they were deleted in another app.

Map your fields

In the “Synchronize” section, decide which columns in Notion correspond to columns in Google Sheets. You can also set the sync direction—one-way or two-way. If you need to sync the formula column in Notion, ensure that you specify the data type it should produce, since it can output number, text, date, etc. Please refer to the screenshot below:

Start synchronization

Once everything is configured, click “Save and Run” to start the synchronization.
For a detailed, step-by-step guide, check out the Quick Start guide.
An example of the setup is provided below:

Similar guides