[leanzubrezki]

It is a mix between Sheets and Notion.

From Notion side webhooks could help, getting notified when a page in a database changed so we can update Sheets right on time. If that notification tells which properties changed even better. Moreover that will let us offer real time updates.

From Sheets side, I have tried with the different triggers that Apps Script provides and they are not 100% reliable in how they get executed and the parameters you get. There are some bugs opened in Google issue tracker waiting to be fixed that should address some of the problems, but I don't have a lot of hope as they have been opened for years.