The regular sync process, which runs every 15 or 60 minutes depending on your plan, captures only the changes that have occurred since the last sync. However, there are situations where you might need to refresh the entire database. This is typically necessary to retrieve the most current values of formulas or rollup properties, or when a new column has been added in Notion that you also want to reflect in Sheets.
A full database scan retrieves all pages from your Notion database and updates the entire sheet. This feature allows you to choose whether to incorporate any new columns you’ve created in Notion, eliminating the need to delete and re-sync the database each time you add additional columns.