just spent the past 5 hours working on and trying/learning everything here. absolutely worth all the time. First time to use Relay First time to use AI to extract data from an image and automatically update a notion database Not the first time doing formulas on Notion but this definitely taught me several things Excited to implement this fully in our team. Thanks! :D
@@mfreihaendig Thank you so much! I would love to see an automation to the onboarding process. Creation and sending of contract and creation of a portal in Notion related to the CRM client.
Incredibly helpful and I intend to use it for a long time if I can get it fully up and running. My hurdle at the moment is the 100 iterations per run and a credit card statement. Would you be able to share the simplest or a recommended workaround?
So you have statements with more than hundred entries at a time? Any easy way to increase the frequency of statements? Otherwise, I‘d probably set up a local automation to split the pdf into several entries 💪🏻
Question - Can i used a similar formula (referencing 5:57 secs) to list out different results from another database conditional to the month listed in the row? somehting like a If november then column x (from "b" database) if September then column y (from "b" database). Thanks in advance.
Loved this tutorial! Will I have to create a new month for each year so I can categorise the total expenses by Year? So in the Month View, have 'January: Duration 1/1/2025 - 31/12/2025' and another 'January: Duration 1/1/2026 - 31/12/2026'? Thanks :)
I forgot to show one step in the video 😅 You need to add the value that it retrieves during the search into the month property when it creates the new entry 💪🏻
Great Video, thanks! I feel like I'm going to want to put the Year in the Month Name to keep things straight year over year. Is there something I'm missing that will help differentiate row September from row September?
Hi Matthias, I was wondering why you used the Find Page in Months part in the video? My thought was that you included it to find the page in the month's database that correlates to the transformed text and add that relation page to the database item but i didn't see it in the video. I'm having trouble on my side as I test it.
Yeah I somehow forgot to show that the part where we map it 😅 Just add the page found during the search step in the relation property when creating the new entry 💪🏻
Hi Matthias, excelent video. Now we are in 2025, could you expand on how we should do to automatically connect to the 2025 corresponding month instead of the first one he finds?
On the months db, you can either connect it to a year db or use a select property - then, you can update the search in relay to check first the name and then that it matches 2025 💪🏻
@@mfreihaendig which means it's not fully automated right? You still have to manually download the statements. Any idea how to automate this in Europe? I've seen many websites that use plaids to transfer transactions, but plaids do not feature European banks... All I've found is qonto for business, which has a native notion integration and I think bunq has some integration as well. But It's pricy just for these features.
Is it also possible to have the link to the invoice in google drive be the value in a Google Drive Property in Notion or would the link not be generated that quickly? Alternatively, can it be uploaded to an image property through the same method?
Great video, I have been watching lots of videos and finding Notion a great tool. Now i will be add Relay to automate repetitive inputs and make it even more valuable. Can you advise if it is possible to add the oiginal file to the database page as an image etc so itcould show inthe Gallery view
Currently not, since you can’t upload files to Notion via the api - but you could add it as a link on the cover image for the page which achieves nearly the same result 😇
Hey Matthias. Have you tried this use case for scanned receipts into your Google drive? I’m wondering if Google Drive’s OCR will be able to extract the data such as the store name and the absolute total of the receipt vs other prices found on the receipt
I downloaded your template and followed this video but I am having trouble with all my credit card statements being added and being categorised please help
Again, thank you so much for this! Today I tried to replicate this automation (in my case for a credit card statement). And it works! But Relay only runs 25 outflows, and in my PDF statement in the Driver's folder there is 39 outflows. (Actually we have 60 transactions but 39 outflows) I already tested Chat GPTs prompt with the file and it recognizes all the 39 outflows, but Relay doesn't. Just 20, 25. Do you know why? Thanks a lot!
Hi, do you know why I am getting an error "Unable to extract data from PDF Files" it worked when I uploaded an invoice but not when uploading a credit card statement. I tried it in chat GPT with JSOn and it worked fine it just seems to not be working in Relay.
@@mfreihaendig When they will implement the email login, they will have me in; meanwhile, Google has already too much information of mine. Giving them access to my financial transactions is way too much, to be flooded with ads and whatsoever.
@@cives actually no, that’s not how these oauth providers work - it just simplifies the app building process since now you don’t need to store accounts and pw yourself. There‘s no data sharing (this isn’t the old Facebook pixel)
Great video. Why do we need the additional databases? The total month's income and expenses can be displayed as a chart. I think there is no need for both the month and year databases, Am I missing something?
If you’d like to see your month-over-month performance as a more stationary, semi-spreadsheet view it’s still nice to have it separate 😇 Plus, over multiple years it will be a bit easier - but you could remove them if you want to simplify it 💪🏻
@@mfreihaendig Yes, their is an API. I just didn't like using Notion which is why I ask and I'm only technical enough to follow instructions, not troubleshoot if there's coding involved
Hi Matthias, you've explain very well the process although I'm still learning some basic stuff. That's why I'd like to understand why you use the formulas instead the the rollups in the month database? I'm asking you that because I thought I got the usage of rollups and now I'm a little bit confused. Thanks
You could rollups here as well - in this case, the functionality is the same! Rollups vs formulas is sometimes a relevant decision (for example, you currently can’t filter for a specific result of a formula - but you can for a rollup), but in this case you can use whatever you prefer 😇
@@mfreihaendig Another question: in months I'd like to add January, Feb, March, etc,,, but 2023. What should I do? I added another list of months and i changed the YEAR colum but I guess it's not done properly. Thanks
I'm trying to do something a little different. I have a Categories database, which in the case of the video would be equivalent to the "Months" database you created. In my prompt, I tell it that depending on the concept, it should tell me which category the concept falls into, and I give it a list of categories to choose from. For this reason, I skip the data transformation step because the AI already gives me the text as I need it. Then in the find page step, it makes a perfect match. That is, if the concept of my expense was for a hamburger, the artificial intelligence classifies it as food and from there finds the page called food in my categories database. Then in the last step it adds the page to my expense database, but when I go to check, it doesn't relate that the expense was for food. Am I skipping any step? I don't see that in the video you do anything else to connect them, just with the Find page and then add the item to the database. Could you please help me?
Yes, that is something that I actually forgot to show in the video - thanks a lot for highlighting it! In your last step, the one where you add the new entry, you need to map the page found in the search step in the category field - then it will properly create the relation 😇
Looks nice, thanks but I don't understand how to modify the file from the bank. I don't understand the data transfer...which columns must the exported file from the bank have? Ich habe 4 unterschiedliche Banken und weiss nicht wie ich die Daten in Notion bekomme…ich kann Excel Files Downloaden…und dann?
This method works with pdfs, so no need to export a csv - and in terms of columns, that depends on what you want to see 💪🏻 Payee, amount and date would be the standard 😇
@@eMotionFlowing It's free! But the template only involves the Notion part, since it's currently not possible to share the relay flow as a template unfortunately - so you'd need to use the video step-by-step to replicate it 😇 Definitely not the easiest one - if you're new to automations, I recommend you start trying to build this instead: th-cam.com/video/DGn1hQxShTg/w-d-xo.html
Hi! My category formula doesn't seem to work... I've copied the formula from the video and adapted it to my data --> prop("Items").filter(and(current.prop("Type")=="Outflow",current.prop("Category")=="Hogar")).map(current.prop("Amount")).sum() It's weird because it doesn't give back an error message, it give sa 0.00€ amount, although I already have Items with the "Hogar" category in them. Do you know what may be going wrong? The Total spent formula is working though! Thank you!!!
![TIMETHAI - ไม่อยากให้เป็นเขา (Why tho?) [OFFICIAL MV]](http://i.ytimg.com/vi/o2qYlGVVtOw/mqdefault.jpg)
Tack! Danke! Sitting in a coffee shop and enjoying following your excellent video step-by-step.
So happy to hear that! Thanks a lot 😇
great video, thanks!
Happy to hear that 😇
just spent the past 5 hours working on and trying/learning everything here. absolutely worth all the time.
First time to use Relay
First time to use AI to extract data from an image and automatically update a notion database
Not the first time doing formulas on Notion but this definitely taught me several things
Excited to implement this fully in our team. Thanks! :D
Amazing, glad to hear it’s been helpful! 😍
Thank you! It was so helpful
Happy to hear that! 😍
okay i will attempt this one more time... i am a super beginner... i hope it works!
Let me know how it goes! And If there‘s anything else that’s confusing afterwards 💪🏻
This is incredible content man. so helpful
Glad to hear that! 😇
That's amazing!! Thank you so much for this video. Pleaseeee make more videos about Notion automations, like onboarding or follow up. 🙏🏼🙏🏼
Oh yes, will do! 😍 anything specific that you‘d love to see for the follow up flow? 💪🏻
@@mfreihaendig Thank you so much! I would love to see an automation to the onboarding process. Creation and sending of contract and creation of a portal in Notion related to the CRM client.
Amazing tutorial. Thank you
Ohhhh really happy to hear that! 😇
Incredibly helpful and I intend to use it for a long time if I can get it fully up and running. My hurdle at the moment is the 100 iterations per run and a credit card statement. Would you be able to share the simplest or a recommended workaround?
So you have statements with more than hundred entries at a time? Any easy way to increase the frequency of statements?
Otherwise, I‘d probably set up a local automation to split the pdf into several entries 💪🏻
Question - Can i used a similar formula (referencing 5:57 secs) to list out different results from another database conditional to the month listed in the row? somehting like a If november then column x (from "b" database) if September then column y (from "b" database).
Thanks in advance.
Hi Matt! Super helpful, but for me, it doesnt automatically allocate the expenses to the month, even though I followed your steps :/
Forgot to show one step in the video - you need to map the result from the search to make sure it connects
Loved this tutorial! Will I have to create a new month for each year so I can categorise the total expenses by Year? So in the Month View, have 'January: Duration 1/1/2025 - 31/12/2025' and another 'January: Duration 1/1/2026 - 31/12/2026'? Thanks :)
Yes that would be the process 😇 or you add another db with years and simply connect the month to the corresponding year 💪🏻
Hey is there a tutorial for make as the setup is slightly different
Not yet unfortunately, hopefully in the future 😇
So good! Thanks for the info
Glad you like it 😇
can i check why my month won't update automatically from relay, i need to manually choose the month
I forgot to show one step in the video 😅
You need to add the value that it retrieves during the search into the month property when it creates the new entry 💪🏻
@@mfreihaendigInstructions?😌🤝
Great Video, thanks!
I feel like I'm going to want to put the Year in the Month Name to keep things straight year over year.
Is there something I'm missing that will help differentiate row September from row September?
Just the year property relation - by which you can filter and create views accordingly 💪🏻
But you can ofc also add it directly to the property name 😇
Hi Matthias,
I was wondering why you used the Find Page in Months part in the video? My thought was that you included it to find the page in the month's database that correlates to the transformed text and add that relation page to the database item but i didn't see it in the video.
I'm having trouble on my side as I test it.
Yeah I somehow forgot to show that the part where we map it 😅
Just add the page found during the search step in the relation property when creating the new entry 💪🏻
Hi Matthias, excelent video.
Now we are in 2025, could you expand on how we should do to automatically connect to the 2025 corresponding month instead of the first one he finds?
On the months db, you can either connect it to a year db or use a select property - then, you can update the search in relay to check first the name and then that it matches 2025 💪🏻
Great, thanks!
So how do you get you finance into google drive inf the first place?
When you download your statements, simply save them to one of the automatically syncing gdrive folders on your machine 😇
@@mfreihaendig which means it's not fully automated right? You still have to manually download the statements. Any idea how to automate this in Europe? I've seen many websites that use plaids to transfer transactions, but plaids do not feature European banks... All I've found is qonto for business, which has a native notion integration and I think bunq has some integration as well. But It's pricy just for these features.
Is it also possible to have the link to the invoice in google drive be the value in a Google Drive Property in Notion or would the link not be generated that quickly? Alternatively, can it be uploaded to an image property through the same method?
No you can easily get the share link 💪🏻
Uploading to Notion won’t work since the api doesn’t allow for file uploads atm
Great video, I have been watching lots of videos and finding Notion a great tool. Now i will be add Relay to automate repetitive inputs and make it even more valuable.
Can you advise if it is possible to add the oiginal file to the database page as an image etc so itcould show inthe Gallery view
Currently not, since you can’t upload files to Notion via the api - but you could add it as a link on the cover image for the page which achieves nearly the same result 😇
Hey Matthias. Have you tried this use case for scanned receipts into your Google drive? I’m wondering if Google Drive’s OCR will be able to extract the data such as the store name and the absolute total of the receipt vs other prices found on the receipt
Yes that should work! Just gotta give it some instructions on what to look out for 💪🏻
I downloaded your template and followed this video but I am having trouble with all my credit card statements being added and being categorised please help
What’s the issue you‘re running into?
@@mfreihaendig Only 5 of the 9 pdf statements are showing up in the data, all the formats are the same, when I run the test it asks me to pick a file
Hi what is the name of the app you use i heard it as "related app?
Relay.app 😎
Again, thank you so much for this! Today I tried to replicate this automation (in my case for a credit card statement). And it works!
But Relay only runs 25 outflows, and in my PDF statement in the Driver's folder there is 39 outflows.
(Actually we have 60 transactions but 39 outflows)
I already tested Chat GPTs prompt with the file and it recognizes all the 39 outflows, but Relay doesn't. Just 20, 25.
Do you know why? Thanks a lot!
Hi, do you know why I am getting an error "Unable to extract data from PDF Files" it worked when I uploaded an invoice but not when uploading a credit card statement. I tried it in chat GPT with JSOn and it worked fine it just seems to not be working in Relay.
Hmmm sounds like a bug - have you contacted their support? 💪🏻
Really great video, super thorough and clear!
Thank you! 😇
Awesome explanation. Hopefully they offer a login via email at some point. I hate logging in socially
Same! Will share the feedback with the team 😇
Me too. That's their price. They "sell" your contact to Google or Microsoft, in this case, under the disguise of simplifying the connection for you.
@@mfreihaendig When they will implement the email login, they will have me in; meanwhile, Google has already too much information of mine. Giving them access to my financial transactions is way too much, to be flooded with ads and whatsoever.
@@cives actually no, that’s not how these oauth providers work - it just simplifies the app building process since now you don’t need to store accounts and pw yourself. There‘s no data sharing (this isn’t the old Facebook pixel)
Great video. Why do we need the additional databases? The total month's income and expenses can be displayed as a chart. I think there is no need for both the month and year databases, Am I missing something?
If you’d like to see your month-over-month performance as a more stationary, semi-spreadsheet view it’s still nice to have it separate 😇
Plus, over multiple years it will be a bit easier - but you could remove them if you want to simplify it 💪🏻
Why can't they just be properties in the database? Like a display month or display year formula from date?
Do you think this could be done with Obsidian instead of Notion?
Does obsidian have an api for you to use? 😇 it’s been forever that I played around with it 😅
@@mfreihaendig Yes, their is an API. I just didn't like using Notion which is why I ask and I'm only technical enough to follow instructions, not troubleshoot if there's coding involved
Hi Matthias, you've explain very well the process although I'm still learning some basic stuff. That's why I'd like to understand why you use the formulas instead the the rollups in the month database? I'm asking you that because I thought I got the usage of rollups and now I'm a little bit confused. Thanks
You could rollups here as well - in this case, the functionality is the same!
Rollups vs formulas is sometimes a relevant decision (for example, you currently can’t filter for a specific result of a formula - but you can for a rollup), but in this case you can use whatever you prefer 😇
@@mfreihaendig Thanks Matthias.
@@mfreihaendig Another question: in months I'd like to add January, Feb, March, etc,,, but 2023. What should I do? I added another list of months and i changed the YEAR colum but I guess it's not done properly. Thanks
I'm trying to do something a little different. I have a Categories database, which in the case of the video would be equivalent to the "Months" database you created. In my prompt, I tell it that depending on the concept, it should tell me which category the concept falls into, and I give it a list of categories to choose from. For this reason, I skip the data transformation step because the AI already gives me the text as I need it. Then in the find page step, it makes a perfect match. That is, if the concept of my expense was for a hamburger, the artificial intelligence classifies it as food and from there finds the page called food in my categories database.
Then in the last step it adds the page to my expense database, but when I go to check, it doesn't relate that the expense was for food. Am I skipping any step? I don't see that in the video you do anything else to connect them, just with the Find page and then add the item to the database.
Could you please help me?
Yes, that is something that I actually forgot to show in the video - thanks a lot for highlighting it!
In your last step, the one where you add the new entry, you need to map the page found in the search step in the category field - then it will properly create the relation 😇
Looks nice, thanks but I don't understand how to modify the file from the bank. I don't understand the data transfer...which columns must the exported file from the bank have? Ich habe 4 unterschiedliche Banken und weiss nicht wie ich die Daten in Notion bekomme…ich kann Excel Files Downloaden…und dann?
This method works with pdfs, so no need to export a csv - and in terms of columns, that depends on what you want to see 💪🏻
Payee, amount and date would be the standard 😇
@@mfreihaendig Thanks…I don't quite understand it yet. It's very complex. 😅 Is the template available for purchase?
@@eMotionFlowing It's free! But the template only involves the Notion part, since it's currently not possible to share the relay flow as a template unfortunately - so you'd need to use the video step-by-step to replicate it 😇
Definitely not the easiest one - if you're new to automations, I recommend you start trying to build this instead:
th-cam.com/video/DGn1hQxShTg/w-d-xo.html
Hi! My category formula doesn't seem to work... I've copied the formula from the video and adapted it to my data -->
prop("Items").filter(and(current.prop("Type")=="Outflow",current.prop("Category")=="Hogar")).map(current.prop("Amount")).sum()
It's weird because it doesn't give back an error message, it give sa 0.00€ amount, although I already have Items with the "Hogar" category in them. Do you know what may be going wrong? The Total spent formula is working though! Thank you!!!
Is "Hogar" 100% spelled the same? Trailing space, emojis, capitalisation? That's the most likely culprit