How to get the UUID of a Notion table item via the item name alone?

How To
,
1

Hello, Make.com community,

I am in the process of creating a Finance Tracker that imports my Transactions from a Google Sheet. When adding my transactions, I want to add them to a Notion table (Expenses, Revenue, Transfers) and assign them to the correct month (a relation to the Month table).
image

I have successfully used the Make formula to always generate the correct name for the Notion table item. However, it stated that I need the UUID.
image

Is there a way to map the month?
image

I can’t think of another way to ensure that my Make scenario remains consistent when adding future months for different years moving forward.

The goal with this project is for it to be entirely automatic other than the few things I need to do to get the data onto the Google Sheet (which I am working on converting from semi-automatic to automatic).

Advice duly appreciated!

2

Hi,
Since “Monthly Tracker” is a relation property, it only accepts a page ID.

So, you could use a “Search objects” module to retrieve the correct Month from your “Monthly Tracker” database, and then map the page ID into the relation property shown in screenshot #2

2 Likes
3

Hi Simo,

I’m currently using Search Objects to get the table “Expenses” and in future Revenue & Transfers. Each will have its pipeline similar to the expenses shown below:

image
image1290×717 66.3 KB

(The reason I get the Expenses Table is to cross-check for duplicate values)

Would I have to use Search Objects on the “Month” table on each pipeline, or is there a way I can do it once at the start before branching into each pipeline to save operations?

Once again, many thanks.

4

I think you can do it once before the router without any issues