FAQ - Notion2Sheets
If you have a question that it is not answered here, please contact us.
My relations show only the id, how can I show the page title instead?
The solution is simple, you just need to add a new column of type rollup and configure it to point to the relation, select the title as property and then in calculate select “Show original”. Now you will have the relation column with the ids, and a new rollup column with the names.
The order of the columns is different from Notion, why is that?
The Notion API does not currently support views or any way of knowing the order of the columns in your database. We create them in the way that they are returned from the API. The Notion team is currently working on alternatives.
Why is the order of the records not the same as in Notion?
When you copy a template or a database, the created time of all the new records is the same, so when getting them from the Notion API the order is random and does not match the one in Notion.
Can I remove columns from the sheet?
Notion2Sheets needs the Page ID column in order to find the correct place to update the records in your sheet. That is the only column that you can’t remove, if you do, the synchronization will stop working. In case there are columns that you don’t want to see, we recommend hiding instead of removing.
Can I change the order of the columns in my sheet? Will everything still work?
You can reorder the columns as you wish, you can hide them, you can change the names and you can add new columns in between. Everything will keep working as we uniquely identify each column. Changing the order of the columns will not affect Notion.
If I add a new column in Notion, will it appear in my sheet?
Notion2Sheets does not currently support synchronization of structural changes, if you add a new option to a select or multi select property or if you add a new column in Notion, that information will not appear in the sheet. For now.
In that case you can remove the connection and do the synchronization process again.
How does Notion2Sheets handle range dates properties?
In order for you to be able to work with those dates correctly in Google Sheets, we split them in two different columns. Start date and end date.
How does Notion2Sheets handle multi select properties?
Currently in Google Sheets there is no concept of multi select. We join the selected options together by a comma, in case you want to do something different with that data you can always use formulas to split the options and work with them.
If I delete a page in Notion, will it be deleted in my sheet?
Unfortunately right now there is no way for Notion2Sheets to know that you have deleted a page from your Notion database, so the page will remain in your sheet and you will have to manually remove that row if you want. Fingers crossed the Notion API will sooner or later support webhooks that will enable this to properly work without manual intervention.
Are hidden columns synchronized as well?
Yes, all columns from your Notion database are synchronized. In case you want you can hide those columns in the sheet.
I have some blank fields with formulas that reference another database, what can I do to make them appear?
Make sure you are sharing the database used in the formula with the integration, the same applies for relation and roll ups. All databases related need to be shared with Notion2Sheets.