Frequently Asked Questions
Can't find what you're looking for? Get in touch and we'll help you out.
Is Sync2Sheets a full 2-way sync?
Yes. Sync2Sheets syncs Notion databases and Google Sheets in real time, in both directions. You pick the direction for every column at first sync, and you can change it any time afterwards:
- Notion Sheets: the default. Edits in Notion appear in Sheets within seconds.
- Sheets Notion: the column is driven from Sheets. Great for formulas like =GOOGLEFINANCE or VLOOKUP.
- Both ways: edits in either tool flow to the other.
Pages created in Notion show up in Sheets. Rows added in Sheets can create new pages in Notion (if you enable page creation). Deleting a page in Notion removes the row from Sheets; deleting a row in Sheets does not delete the Notion page.
How fast is 2-way sync?
Real-time on all plans. Edits on either side show up on the other within seconds.
A reconciliation pass also runs every 10 minutes as a backstop, in case a push notification gets dropped.
Can I reorder, rename, or hide columns in my sheet?
Yes to all three. You can reorder columns, rename them, hide them, and add your own columns between synced ones. Sync2Sheets tracks columns by internal IDs, not by position or name, so nothing breaks.
How often do block updates and table blocks sync?
Block updates and table blocks run on a schedule that depends on your plan:
- Starter: every 2 hours
- Advanced: every 30 minutes
- Business: every 15 minutes
This is separate from the database column 2-way sync, which is real-time on every plan. If your plan includes manual syncs, you can also trigger one anytime from the add-on.
My relations show a Page ID instead of the page title. How do I fix that?
Add a rollup column in Notion:
- Create a new property with the Rollup type.
- Point it to your relation.
- Select the Title property.
- Set the calculation to Show original.
The page title will now appear next to the relation in your sheet.
Where can I find my invoices?
Invoices are sent to the email you used when purchasing. If you can't find them, contact us and we'll resend them.
How do I trigger a manual sync?
Open the Sync2Sheets add-on in Google Sheets and click Run Sync Now. This triggers an immediate reconciliation in both directions.
Why don't the columns match the order I see in Notion?
The Notion API doesn't expose column order from views. Columns appear in the order the API returns them, which may differ from what you see in Notion. The Notion team has acknowledged this and is working on it. In the meantime, you can reorder columns in Sheets freely.
Why are my pages in a different order than in Notion?
This usually happens with databases copied from templates. When pages are duplicated, they often share the same creation timestamp, which causes the API to return them in an unpredictable order. You can sort the data in Google Sheets after sync.
Can I delete columns from the sheet?
You can hide any column you don't need. Just don't delete the Page ID column. Sync2Sheets uses it to map rows to Notion pages. If it's removed, the sync will stop working for that sheet.
If I add a new property in Notion, does it appear in Sheets automatically?
Yes. New Notion properties are added to your sheet automatically on the next sync, starting with the Notion Sheets direction. You can switch them to Sheets Notion or Both ways from the column settings.
How are date ranges handled?
Notion date ranges are split into two columns in Sheets: Start date and End date. This makes them easier to use with formulas, filters, and charts.
How are multi-select properties handled?
Since Google Sheets doesn't have a multi-select type, all selected values are combined into a single cell separated by commas. You can split them using the SPLIT() formula if needed.
If I delete a page in Notion, is it removed from Sheets?
Yes. Deleted pages are automatically removed from your sheet.
Are hidden columns still synced?
Yes. Hiding a column in Sheets doesn't stop the sync. All Notion properties are synced regardless of column visibility.
My formula cells are blank even though the data exists in Notion. What's wrong?
Make sure every Notion database referenced by your formulas, relations, or rollups is shared with the Sync2Sheets integration. If a referenced database isn't shared, those cells will appear empty.
What types of columns can be Sheets to Notion or Both ways?
Most property types support every direction: Title, Rich Text, Number, Checkbox, URL, Email, Phone, Select, Multi-select, Status, Person, Date, Relation, and Icon (emoji).
A few types are always Notion Sheets because they have no writable round-trip: formulas, rollups, created time, created by, last edited time, last edited by, unique ID, button, verification, and files.
What's the difference between Sheets to Notion columns and block updates?
A Sheets Notion column writes a Sheets value into a Notion database property in real time. Useful for formulas, calculated fields, or anything Notion formulas can't do. (This is what used to be called editable columns.)
Block updates link a single Sheets cell to a Notion block (heading, paragraph, callout) and run on your plan's schedule. Useful for dashboards and KPIs.
Both are optional and can be combined in the same database.
What happens if I rename a sheet tab?
Nothing breaks. Sync2Sheets tracks sheets by internal IDs, not by tab name. Rename freely.
What happens if I delete or duplicate the sheet?
Deleting the sheet stops the sync for that database or table. Duplicating the sheet doesn't copy the sync configuration. You'll need to set it up again in the add-on.
Can I sync a Notion view instead of the full database?
Not currently. The Notion API doesn't support views, so Sync2Sheets always syncs the entire database. You can filter or sort the data in Google Sheets after it syncs.