Notion & Make : Formula, Roll Up and Relation

[caporali]

Hello,

I am using notion with Relation and roll up to get some numbers from my notion dash board → see pic 1

I want to retrieve the value of those numbers to use them in excel (or else)
All the numbers from pic 1 come from formula, relation or roll up)

How can I do that (using make / integromat) ?

When I try to do it on make, the output is the formula / the relation (not the value) → see pic 2
Thanks a lot

[Simo]

Hello, in Make, instead of using the “Get a database” module, use the “Search Objects” module. This will output the values for each property of your Notion pages in picture 1

[caporali]

Hello Simone

Thanks for your quick response.

However, I just tried what you proposed me and I did not work properly (see picture attached)

Thanks

Here is the link of the scenario

https://eu1.make.com/341731/scenarios/1746505/edit

[Simo]

I see - that might be because Rollup values are often not output properly by the API, especially if they reference other Rollups/Formula values within the Notion database. Here is a good explanation of this limitation of the Notion API.

So, in this case, your best option may be to “recalculate” your Rollups/Formulas within Make. This would require you to query (“Search Objects” module) the original databases where your rolled-up values are stored, and perform any necessary calculations within the modules in Make

[caporali]

Hello Simone,

Thanks for your quick response again.

I watched the information you gave me and it looks complicated to me (and to do)

The idea of using make is to make things simple !!

This is not good news for me because I was going to change plans to be able to use make with higher volume…

I just had an idea but not sure if it’s possible

Can make download (on a regular basis) a page in PDF or CSV and then use the number inside ?

That would be much easier in my case (see attachment)

Thank you simone

CA Capo Conseil 672f227a9d9742d39209ccaf18617ad4.pdf (25.8 KB)

[Simo]

I believe so if you upload the PDF/CSV to a file storage service you can query via Make/API. CSV is probably best, since the file would be more structured and you may be able to retrieve the numbers more easily.

For example, you may experiment with uploading the CSV to a specific Google Drive folder, then using the dedicated module to retrieve the new file, then get the file content in a subsequent step through the dedicated GDrive module (e.g., “Search for files/folders”), and finally adding all the other steps needed.

This is only a first idea that came to mind but haven’t tested it myself - so if anyone else has other ideas or approaches, they are welcome

[caporali]

Hello simone,

Thanks for this quick response.

Is there a special module to make a query from notion to upload a CSV file ?

I will try that in the next few days.

Thanks

[caporali]

Hello Simone,

I would like make to make the query on my database so it can download it on a specific drive location and then I know how to handle the following steps,

Can you help me on that ?

Thanks

[Simo]

Hello, to make a query on a Notion database, you can use the “Watch database items” or “Search objects” modules in Make

[caporali]

Hello

I think I did not ask my question properly.

What I would like to do is :

From a notion Data base,
1/ get (on make) a CSV export of the notion data base (I do not know which module to use)
2 / put that in sheet file
3 / etc

Step 1 is giving trouble because I am not sure which module to use, when I use get data base, it returns the formula, relation, and roll up not the value

Thanks

[Simo]

I see - and what is the difference between “get a CSV export of the notion data base” and just creating the Google Sheets directly in Make through the “Search objects” Notion module + “Add rows” GSheets module, where each page from Notion becomes a row in GSheets?

[caporali]

Hello Simo, thanks again for your quick answer.

Ideally I would prefer using all notion modules in make like “Search Objects” and “Get DB” etc but when I do they return me wether the formula / relation (not the value) - or the value 0 in that case - but the real value is not 0 (see 2 pictures)

Nicolas

[Simo]

This may be happening because you are using multiple levels of relations/rollups for your formulas in Notion. The API outputs wrong values when you use several layers like it looks like is the case in your database. So, you can solve this issue by doing your calculations directly in Make, exactly like you have them in Notion

[caporali]

I do not know how to do the calculation directly on make

Since they come from a very high numbers of line

Client A - 6 hours - 560 euros - month July 23 - service A
Client A - 7 hours - 760 euros - month July 23 - service A
Client A - 8 hours - 870 euros - month august 23 - service B
Client B - etc
client B -etc
Client C

I need the total hours and euros / client
and euros and hours / month
euros and hours / service

Not sure how to do that.

[Simo]

I see, since this is a rather unique and advanced situation, it is difficult to solve it just in a community post because it requires a deeper understanding of your data structure, automation needs, and technical knowledge of the Notion API. At this point, I believe it may be best if you reach out to someone who is an expert directly or hire someone to help you

[caporali]

Hello Simone

Yes I understand that but I can not do the calculation in make if I do not retrieve the relation (relation is not something you can calculate)

I set a quick and easy example with 2 data base (Invoice and Client)

Both are in pictures

What would be the steps to retrieve the relation (and the values of the calculation if possible)

Thanks

[Simo]

1. Watch database items (Invoices)
2. Search objects (Clients) - filter for “Invoice” “relation - contains” "{{pageID}} (from #1)
3. Sum (using the dedicated module in “Tools” in Make) - {{Montant 1}}, {{Montant 2}}
4. Add any additional modules as needed

[caporali]

Thanks for your answer but my goal is to be able to see from make the relation in the Data base “Client”

I want the module to retrieve the relation “Invoice 2” for line 1 named “Amnéo” and “Invoice 1” for line 2 named “Valentin”

And it does not work on (see picture)

Thanks

[Simo]

Okay - then, for the second/third module, use “Search Objects” and select the Invoices database. In this case, then, it sounds like you don’t need the trigger as “watch DB invoice”

[caporali]

Hello

Thanks for your quick answer as usual.

My goal is to see in make where each relation of each line points to : for exemple, “Invoice 1” should let me see in the the property Value “Valentin” and it does not even with your proposition.

Do you understand What I want ? (see picture)

Thanks