Auto deletion behavior

Overview

Addsync includes an automatic deletion feature that automatically removes the corresponding row or page when deleted from Notion or Google Sheets. However, its behavior depends on the type of sync flow you set up.

When all set to "import":

When you set all column mappings to "import," deletion works in a one-way manner. If you delete a page or row in Notion, the corresponding row in the Sheet will also be deleted. However, the reverse is not true—deleting rows in the Sheet will not remove anything in Notion.

Note: If you delete rows in the Sheet when all are set to "import," the deleted row will not be re-initiated in Google Sheets again in the current Addsync version. This is a feature, not a bug. You can sync one-way and then delete unnecessary rows to create a filtered dataset, which will update when you modify values in Notion. Let us know what you think about it.

When all set to "export":

When you set all column mappings to "export," deletion works in a one-way manner. If you delete a row in Google Sheets, the corresponding row/page in Notion will also be deleted. However, the reverse is not true—deleting rows in Notion will not remove anything in Google Sheets.

Note: If you delete rows in the Sheet when all are set to "export," the deleted row will not be re-initiated in Notion again in the current Addsync version.

When both "import" and "export" are set:

When you set some column mappings as "import" and others as "export," deletion works in a two-way manner. If you delete a row in Google Sheets, the corresponding row/page in Notion will also be deleted, and vice versa.

When any set to "2-way":

Deletion works in both directions, similar to when you use a mix of "import" and "export."

Why is there a delay in deletion when there are more than 500 Notion database rows?

Due to Notion API limitations, only 100 rows can be retrieved per request, and each request takes approximately 4-6 seconds. If your database contains 1000 pages, it would take around 10x6 = 60 seconds to fetch all rows. The more pages you have, the slower the sync process becomes. To mitigate this, Addsync performs partial data fetches regularly. A full fetch occurs after a few minutes to hours, depending on the database size.