Hello Make.com Community! It is an absolute pleasure to do my first post with you guys!
I am currently facing an issue regarding the addition of Notion items to my Google Sheet! I am trying to make a Rota system which updates automatically, however, within my Notion systems, I do use a lot of relations to other tables and rollups which upon checking the forums is an issue due to Notion limitations.
I am a firm believer that when there’s a will, there’s a way so I’m adamant that this can be resolved. It appears that regardless of what Notion module I use, it is not accurately fetching the results from my Notion Rollup properties.
I have given make.com full access to my Notion so I do not think it is a matter of it not knowing the data, however, I believe that I may need to add some form of filter which can decipher the Notion language to Make.com.
Hi! For correctly getting the values of relations and rollups, it may be best to use “Get database item” modules to retrieve the related database items, and then use the original data from those related database items in subsequent steps. This way, the data is correct
What the coder in me wanted to do initially was minimise the size of my system, however, I found that it wouldn’t work unless I used the “Get Database Item” for every independent item. If that is the way it is meant to be done then perfect! Otherwise, any advice is appreciated again.
This is how my table ended up eventually looking like:
Ah I totally see your point! You may also look at the “Seach objects” module to see if that can simplify your scenario. Other than that, in my experience, that’s the only reliable way to go with the Notion API at this time (to get reliable rollup values), so I don’t have any other advice unfortunately
I have been experimenting with Search Objects and this definitely solves the issue I was having. It’s a great way of looping through a Notion table and returning the values of everything when unfiltered.
