Need help? - Notion2Sheets

Solutions and workarounds to common issues.

The START SYNC button is disabled!

Notion2Sheets requires both Created time and Last edited time properties to be part of your database, please add them, save in Notion and refresh. The start sync button should be enabled now!

I can’t see a database when searching.

If a specific database does not appear during search, please make sure you are sharing it with Notion2Sheets. Once shared give it a couple of minutes before searching again as the Notion API takes some time to index it in the results. image

My roll ups properties are missing.

Depending on how your roll ups are configured, the results would not appear in Notion API if you have multiple relations nested from other databases. Right now roll ups and relations can only go one level deep. If those values rely on other values (for example the relation you are mapping to requires values from another database as well), then those value would not appear.
One possible solution for you to try:
Create a new formula property that just points to your roll up property like this, prop("Rollup property name") and check if that does the trick.

A relation property is missing from my database.

For relation properties to be available, both the database and the related database needs to be shared with the integration. Please make sure your related database is shared with Notion2Sheets and try the synchronization again.

I installed Notion2Sheets but can’t find it anywhere.

To open Notion2Sheets you need to first have a Google Sheet opened. Then on the right you should see a sidebar with Notion2Sheets icon, click to open the add-on. If you can’t see the sidebar it means it is probably hidden, there should be a button at the bottom right that allows you to show it again.

The Sheet is not updated with changes in my roll ups.

Roll ups are special properties in Notion databases that are not data that belongs directly to the page but reference to other pages data. If the only thing that changed in your page was the value of a roll up, the Notion API won’t return that page as updated, so Notion2Sheets won’t be able to update the value in the Sheet. You can manually update your pages, for example checking and unchecking a checkbox, so the next time the updates run Notion2Sheets will get the pages from the Notion API as updated and update all your data.

You can always sync multiple databases and mimic your Notion roll ups with Google Sheets formulas!