Need help?
Solutions to common issues. Can't find your answer? Contact us
I can't see the right sidebar in Google Sheets.
Click the small arrow at the bottom-right corner of the screen to expand the sidebar. Once it's visible, look for the Sync2Sheets icon to launch the add-on.
I installed Sync2Sheets but can't find it.
You need to have a Google Sheet open first. Look for the add-on icon in the sidebar on the right side of the screen and click it to launch Sync2Sheets.
I can't find a database when searching.
Two things to check:
- Share with Sync2Sheets: The database must be connected with the Sync2Sheets integration in Notion.
- Wait a moment: After connecting, the Notion API may take a minute to index the database.
I'm getting a general error when using the add-on.
Try opening Sync2Sheets in a fresh spreadsheet:
- Go to sheets.new in your browser.
- Give the sheet a name and launch the add-on again.
If the issue continues, contact us with details about the error.
Can I sync the same database to multiple spreadsheets?
Each database can only be synced to one spreadsheet. To access the data elsewhere, use Google Sheets' IMPORTRANGE formula:
=IMPORTRANGE("spreadsheet_url", "sheet_name!A1:Z1000")Replace spreadsheet_url with the URL of the sheet where the database is synced, and adjust the range as needed.
My roll-up properties are missing.
Roll-ups that go through multiple levels of relations (a roll-up from a related relation) may not appear via the Notion API. Roll-ups only work one level deep.
Workaround: Create a formula property in Notion that points to the roll-up: prop("Rollup Property Name"). This often forces the API to return the value.
My sheet doesn't update when roll-up values change.
Roll-ups reference other pages. If a roll-up value changes but no other property on the page is updated, the Notion API doesn't detect the change, so Sync2Sheets isn't notified.
Solutions:
- Run a full database scan to refresh all rows.
- Alternatively, sync the related databases into Sheets and rebuild the logic using spreadsheet formulas.
A relation property is missing from my database.
For relations to sync correctly, both databases need to be shared with Sync2Sheets:
- The database you're syncing must be shared.
- The related database must also be shared.
If either is missing, relation values won't load. Share both, then retry the sync.
A people property shows missing users or empty values.
Users marked as guests in your Notion workspace are not exposed by the Notion API. Only full workspace members appear.
Workaround: Create a formula property that references the people field: prop("People Property Name"). This can sometimes surface the name even when the API doesn't include it directly.