How to synchronize Notion database with Google Sheets
Use case overview
Sync Notion and Google Sheets to keep data up-to-date in both. Analyze with formulas, pivot tables, and charts in Sheets while maintaining a central Notion database. External stakeholders can work in Sheets without Notion access, and changes sync automatically—no manual updates, no discrepancies.
Select a platform, accounts, and a source
In resynced.io, select Notion and Google Sheets as the apps to sync.
If it's your first time, authorize both accounts. For Notion, 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.
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."
Click "Add new connection" for Google Sheets and grant the requested permissions. Then, select the file and sheet you want to sync.
Filters (optional)
By default, resynced.io syncs all items. Use filters to sync only specific items.
For Notion, select the column you want to filter, set filters like "equals" or "does not equal," and enter a value.
In Google Sheets each cell in a column can contain different data types. Select the column you want to filter, then set your filter conditions, including data type, such as "Text equals or doesn't equal," "Number equals or doesn't equal," "Checked or unchecked," and enter a filter value. For example, a Budget column might contain numbers stored as text in Google Sheets, and if you filter the Budget column by 'Number equals,' the filter won't work, and no items will be updated.
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
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 numbers, text, dates, etc.
Once everything is configured, click "Save and Run" to start the synchronization.
Was this guide helpful?
Reach out to us at hi@resynced.io, and let us know if you have any additional questions.
Similar guides
How to synchronize Notion database and monday.com board
How to synchronize data between two Notion accounts
How to synchronize data between two Notion databases
