# Community Hangout, August 2024: Workflow Showcase

## Метаданные

- **Канал:** n8n
- **YouTube:** https://www.youtube.com/watch?v=oKuNcc_nWRM
- **Дата:** 26.08.2024
- **Длительность:** 1:02:44
- **Просмотры:** 1,981

## Описание

Community Hangout, August 2024: Workflow Showcase

This month, we invited the community to share their most interesting workflows.

​As always, we started off with community and product updates, and we’ll wrap up with a round of questions and answers.

Chapters:

01:04 Agenda
02:50 Community Updates
13:53 Product Updates
24:57  Job Updates
27:56 Workflow Showcase: Guilherme Salomão: "2-way sync between Notion and Google Calendar"
35:38 Workflow Showcase: Andy Slack: "AWS Domain Redirects"
42:56 Workflow Showcase: Jim Le: "Survey Insights with Qdrant, Python and Information Extractor"
51:18 Workflow Showcase: Jörg Zastrau: "Calendar-based room temperature reduction"
57:10 Workflow Showcase: Liam McCarrigle: "A Smart Installer Script for n8n"

Links:

- Sign up for future n8n Community Hangouts: https://n8n.io/community/events
- Sign up for the n8n Community Newsletter: https://n8n.io/newsletter/

## Содержание

### [1:04](https://www.youtube.com/watch?v=oKuNcc_nWRM&t=64s) Agenda

co-hosting format absolutely um as always we'll start uh this hangout with an overview of some Community updates some stuff we've worked on over the last month and that will be happening next month we have uh a couple of job openings for you that we'd like to share there are product updates there some really cool ones well there's even one that we discovered just today that blew our mind really excited yeah that's the interesting thing of working here sometimes we have surprise releases that we didn't see nice thing we're growing right so you got all these cool teams working on great features and then you see the release change L wow amazing this be ready for that and after that we are uh moving over to the workflow showcase where we have five community members showcasing something really cool that they built yeah fantastic are you looking forward to that very much so again seeing what people building out in the wild kind of inspires us and also helps understand like where the product should go right yeah for sure yeah it's always like it's kind of difficult when you build a platform to be like an Innovative user yourself I think I noticed in a lot of people's Journeys you know automation is this thing it's a muscle that you grow over time so at first you might think okay I can create this kind of automation but as you go through in your whole world you see opportunities to automate so it's always nice to see you know folks who are deeper down the rabbit hole in NN who have that strong muscle to see all the kinds of things that they're automating yeah also I'm St to see people like hacking around limitations on N kind of kind presentation about that today as well all right let's just move on to not hang out too much I cover these things um at the end of the show we'll have the community chats and so there's if you have anything unrelated that you want to share or ask there's space for that as well right yeah please keep them coming in the comments section yeah perfect so on the community

### [2:50](https://www.youtube.com/watch?v=oKuNcc_nWRM&t=170s) Community Updates

side of things we had quite a busy month uh you know the community meetups have really kicked off we have our ambassador program in place now we have 10 ambassadors uh who are actively organizing events and as a result we had a meet up in St Louis where our ambassador Nate Haskins was hosting an n8n Grill uh Festival that sounds fun yeah and the pictures look really great it looked like they had a lot of fun uh turnout was still rather small but it's early days so I'm confident that this will grow in the future as well I think when you're running an event right the first one it's it worked people showed up you know you didn't forget your slides or something and then you grow from there you're just Happ to be it works ex that's true yeah uh we had a meet up in sou Paulo which lasted all day it started at 9:00 a. m. and last until till 6 wow okay our ambassador Louis he rented the space and people were able to like give presentations and workshops and I think there were over 40 people present there dur during the day it's like an offsite almost like huge yeah so it's really uh big um the one in war show that was supposed to happen yesterday got can but we'll be replanning that in next month or October so we'll be back on that and then we had our event in Berlin yesterday which was hosted by our ambassador uh Gexa uh and he co-hosted this with the no code Apes group uh did you know them already I didn't know so we got to get acquainted with them which is always nice to meet some other low Cod no code folks in the local city because I'm based soon in Berlin so excited to kind of they've got a lot more events coming up and yeah I think they're doing a lot of cool stuff to evangelize and you know show all these cool things that people could do that a couple years ago you'd have to be developer for yeah the organizer Matias he told me he'd been doing this since the beginning of this year and they already grew to 600 members wow so this is picking up speed real fast yeah and the cool thing there was you know there was some power users as we discussed but I think it's always exciting when you get newbies that don't no evented even or just started they see some sort of use case and they get inspired I could do this as well that's what we're about yeah and the whole concept of like automating and connecting processes it's super interesting I think it's very addictive too you know you look at probably all of us who are here right you see that FL what's that I think that seems accessible right but um so we had about 45 people show up it was a really nice place uh that we found um at link and Co it we had like drinks and we had snacks and everyone was having a great time uh our founder Yan opened with a little like retrospect on how the company started and where we're heading and then the floor was yours yeah I gave a little demo showing off some of our new Advanced a ey features so I was uh I think I may have ran a little over my slot time but in about 15 20 minutes we built a an AI agent that can check your calendar availability your Google calendar availability and actually book a session with you all through chat so we live built that from scratch um and that was really impressive you know if you asked me a year ago hey can you 15 minutes build this in Ed I would said yes it's possible but you know how long it might take yeah so yeah that's the new HP flexibility and the queries to keep can send it it's amazing and I think the really cool thing there was also showing how like you can uh constrain what the AI is allowed to manipulate and what it can't so doesn't hallucinate you kind of get some guard rails you know when I was in San Francisco a few weeks ago the topic of AI guard rails was coming up a lot right because these tools are non-deterministic they're very flexible but how do we control them because usually most jobs to be done at work you want to have a nice predictable outcome so I think that was a pretty cool demo of that it was yeah and people were very impressed and we had a lot of nice conversations about both Ai and non- AI related workflows in NM yeah uh some really surprising ones and yeah for me that it's really energizing to be talking to actual users and see how they use our platform absolutely and actually what I'm going to post here in a second is there's a version of that demo that I gave on the workflow template Library so if it's something you want to check out um this is the one I gave in San Francisco it's very similar but you can check out that template and explore it's got a few examples and also we recorded the talk last night so we'll try and get that up on our YouTube channel at some point as well right yeah exactly so you can enjoy that later right and so after you were done we had our rockar community member osar yeah and he was going over what uh basically the things around making your end web into an API so kind of showing you know there's the basics for API but then there's things like rate limiting and all the other things you need to really productize that and turn that into sort of a serious product and he showed how pretty quickly with NN and was it called tick yeah was it tick. yeah tick. you can basically as a single individual ship a low code no code API end point that's production ready open source tool so you can try it out yeah it looked really powerful yeah I'm definitely going to have a peek at that on some of the sort of product I know you have a couple of weird ideas coming up always nice also when Max and I arrived at venue yesterday we climbed out of our Uber and we ran straight into Oscar who was walking on the basement and it was pretty wild to just meet a Community member like that and he's one of these folks I remember when he first started making his videos I was like Wow who is this guy he's making these really high quality videos for NN and so I was a bit of a fanboy I must say were yesterday a little bit awesome all right so uh after Oscar's talk there was a break and then there was a presentation on creative thinking and product design using AI by really interesting very different angle but really cool to see how she used AI as well um and after that we all well not all like 20 of us or something like that yeah conversion we left the venue and we met at the local beer garden for drinks and for some snacks and well some stayed longer than others but it was a really nice evening yeah it was um a first meet up in Berlin right so I think ending in a beer garden was with some nice pills and it was uh very topical yeah it was amazing yeah and I think the really cool thing is um you know they had been at the Meetup talking about this and even into I think at 1: a. m. there was still some folks just still nerding out about Ai and Automation and stuff like I don't know for me it was a dream I kep out by them I'll just trust you yeah um just this morning we also received uh Mario Haron Gexa and Oscar in our office for a quick coffee we had a really nice chat very cool they were here just in time to uh to be in our original office and that's the photo right there right with the three of them very cool funny detail the logo you see in the back it's but it's lit but we kind of forgot how to turn it on and then they figured it out so yeah so it's funny when we got this sign it was uh some years ago in end we ordered it of Alibaba and it comes with this power supply unit and I had to rig it up to 240 volts with like electrical tape we ran it for a few days like you know maybe it's best enough to kill one you join us so we haven't turned it on most of the time oh my God okay anyway we're had a great time as you can tell so we're definitely going be going to do it again probably not time this year um but yeah I think user meetups is what we really need to connect with each other and with our local community absolutely I think it's inspiring for the team as well I heard some of our Engineers saying how nice it was to talk with you know the people yeah yeah all right cool looking at the clock I have to continue um right now we have one upcoming event it's next month in Prague uh Prague happens to be oleg's hometown so he offered to uh to host this one for us uh Liam one of our ambassadors happens to be around there at that time as well so you can meet him there yeah I'll be traveling down there and maybe we can see you there see if I can squeeze in it' be nice to cool yeah it's uh yeah that's uh it's going to be focused not focused we'll definitely have uh presentations on AI obviously you can ask oh like anything you like about that yeah he made most of the feature today so if you can't answer it it's forget about it yeah um any new events you can always follow our event calendar on n. i communityevents um but for now that's it um then quick shout out that we're still looking for new ambassadors right now we're focusing on London Paris and the San Francisco Bay area so if you are an excite enthusiastic NN user if you enjoy organizing events or like meeting people Etc uh get in touch with me please uh and we can see if we can work with you and support you uh we are uh like we are me mentoring our ambassadors we're helping you set up these events uh we have rewards like swag but also free Pro accounts free enterprise licenses for everyone so you can try out every angle of our products uh and enjoy it and learn about it yeah some cool perks there yeah and we're like we'll expand the perk program again uh Mexico and Kenya we don't have um ambassadors there yet I do have to say right now we try to focus mostly on Europe and uh North America although we do uh use other regions as well so if you are uh interested in doing this you can still reach out and uh we'll see what we can do for you okay and then uh my last Community update we are experimenting with some new uh swag uh we had these t-shirts and beanies Etc in our store for quite a long time and it's time for some refreshing these are some ideas that we're playing around with um we would be really interested in hearing from you what you're interested in as well so what is the kind of Ann swag that you would wear with pride all day uh what would you well I've got for the last year some folks that might know me know that I've been trying to push the concept of flow grammar that where flow grammar's in so i' love a hat that says flow grammar on it or t-shirt so if that's something you're interested in get some comments in there maybe we can make my pipe tream come true what I'm really excited about if you seen this mock up here is the PIN with the's face on it I'm putting that every way on I made that one for fun but it's my most successful one all right so yeah this is gonna take a while because we need to test out these things and see the quality is nice see the young pin will be awarded after instance reaches 1 million executions I like that real yeah have a lot of people setting up a schedule trigger real fast I like it all right thanks um I'm gon to reload and see if there's any questions lis no not at the moment few people interested on more events in the region but yeah we're hiring a lot of ambassadors so if you want to happen event in your region probably you can apply as an ambassador yourself yeah please do yeah just go to that page and ambassadors and you will find all the information and the sign up form and I'll get back to you to set up quick interview see what you want to do make it happen cool all right well with that

### [13:53](https://www.youtube.com/watch?v=oKuNcc_nWRM&t=833s) Product Updates

it's time for our product updates and that's your quite exciting updates we were looking at this today and we're kind of having these oh no way sort of moments finally what we're going to do is do you want but before we go to those um there's a launch we had yesterday we're really excited about and we launched the self-hosted AI starter kit so what this is n ol Lama quadrant and postgress all in one Docker setup so you can basically run one command it installs it all locally um it creates the credentials automatically within edit for o l and quadrants you can basically it even has a demo work loaded in there so it's probably the easiest it's ever been to set up all these Fantastic Tools together and get building AI Solutions locally now uh if you don't have a super fast computer you can also uh in the GitHub read me there there's some content around how to set this up with runp pod or something so you could rent a GPU so if you want to try some of the more powerful models even if you want to try you know the 45b model you could do that today you could delete that instance afterwards so if you're working with pi or the sensitive information you unblock to try that out um but even if you don't have some sort of strict business requirements it was a trip uh you know setting up and seeing hey I running on my own computer well that's and of course now you have like full control over the privacy of your information yeah it's not leaking anywhere anymore and even if it's not something you need to do for your business you know my own calendar and whatnot that's information I'd like to keep private and away from open AI for example so yeah you have that option now in terms of cost is it like an interesting way of experimenting and like running like a lot of llm stuff absolutely yeah with AMA you can get a lot of these different models set up and test them I think one thing when you're building AI workflows the first thing I recommend if you're having a problem swap with a different model you know I was one use case I was working on gp4 couldn't handle it uh anthropic could Claude could so I just ran with Claude didn't have to fix anything else other than swap it obviously at production you might want to optimize there but once you're sort of getting going with proen Concept really nice yeah I think that's important to point out that this started kit is meant for like experimen and it's not necessarily production right yeah so I think anyone who's sort of is in devops and whatnot knows that it depends on your custom you know requirement for production but it's a nice Baseline to set that up and I would say I'm a script Kitty you know I'm not a developer and I was able to get it installed on my MacBook so that's pretty cool for sure um and in that GitHub there's lots of work for templates and that sort of thing we've also launched it on product hunt so when you're checking it out we'd love if you give us a little up foot in there if you like what we're doing there I think Bart's going to post a link to that chat window on my computer and this is just the first version of this right so the more engagement we get with it the more downloads and GitHub Stars the more we can get a signal from you guys that you want us to expand it out and perhaps um yeah basically build it out over time no sure um so while Bart shares that I'll keep moving because we got so many cool updates so uh one that a lot of folks have been I think waiting for a while and great job from our nodes team is we've now added some improvements to the merch node so what you can do is you see in the screenshot is configure how many inputs you're getting so there's a number of inputs that you can Define there which is great because you know we would see a lot of users having these kind of clusters of merge nodes to merge to remerge you can all do that in one node uh so it's simpler and you can also run SQL queries on those so you get all these different inputs going in there and then you can um basically uh have SQL query applied on that and then output there so a lot of possibilities with that I think that's something commun been asking for a long time yeah and for my brain this is going to work a lot better too because I'm always fighting with the options in the merge not and I think this is much more like developer absolutely and imagine with um the power of GPT or a new AI uh co-pilot that's going to be launching at NM somewhat soon um this is going to be really powerful stuff nice right um and so the next thing uh it's got a new OCTA node so if uh OCTA is something you're using in your stack there's some new actions for user management basically the crow ones create Delite get many and update so that's in version 1. 55 but next uh we must save the best for last we've got some updates to the form trigger and to dragging and dropping data and expressions so I prepared a little work for to quickly show that off because I think we're all really excited about this um so let's open that up yeah okay so most of you probably familiar with the form trigger Let's test this and show you what we've got new so there's two new form inputs we've got email which is validating and doing all the stuff you need for a correct email right so if I just do that it's handling all that validation for you so let's type in a an email there see validation and we also accept files now as well so if I upload a file here let's see I should have a CSV test here okay you're limited it to CSV only in this case no so I'll show you but it's really cool so upload that in my workflow we can see we've got the data in there and in the form itself I can Define if I want to upload multiple files or single file and accepted file type so I could remove this to allow any kind of f but here we can filter that in full control super useful yeah um and there's a few other features uh on the form trigger as well but I'll go over those in a moment because I really want to get to what we've done now um with some of the Cor core functionality in working with your data once you've gotten it in so if I go over to Jason here for example um let's say we want to create a summary um so we have been able to in Ed enter drag and drop right so if I drag and drop here um and let's say we want to say that this is the file name right but what we haven't been able to do previously and let's say we want the M type and let's see we want the size as well if I wanted to drag and drop previously it would have pen it just in the end now I can drag and drop in place I know that's something a lot of users been waiting for a while so that's really this was such a pain it always appears in the wrong spot yeah and especially when you're working with a big uh let's say input and you don't know what it is and it goes yeah so if you thought that was cool we've also completely refactored the expression editor or the sort of the full screen and this was probably the oldest view in NN it had the a little dodgy modal button on the corner still so Julio and Elias see part of your data exactly so they they've brought that into the fold now as you can see here that's all accessible in here as well so I can drag that in there um so very exciting stuff um and you're also seeing the results and then when you have multiple items you can cycle through those to check that it's all mapping properly so that's super useful for uh just the ux this um and you can also uh search these different inputs so and if we had multiple nodes it would be filtering through all those nodes so again really making it faster to map dat this is a huge difference if you have a lot of nodes with a lot of fields defines your property very fast yeah and when you're working in a real use case you know very often we we're sending back the payload you're getting from the API so there could be hundreds of keys definitely helpful um so great job the nodes team there and I think but there's a few other small uh things on these um features as well let's see make sure missing and yeah so we have also the possibility to pre-populate the form fields from URL query parameters uh that's for the form trigger yeah um placeholder text but input texts or for input Fields um we can add some basic authentication to this form as well so great if this is something you're doing internally or perhaps just generally you want it to be protected um some Styles improvements and coming up soon on the road map of the form Trigg is also multi-step forms so that's probably going to allow a lot of flexibility it's really cool to see how this little node has expanded and grown we got a lot of feedback on the form trigger node as well so I'm really happy that we are able to deliver these things now yeah absolutely for me personally the like prefilling with the URL that that's huge that's going to make like doing like Mass mails and collecting data Etc so much easier and so I think Julio is also here from the notes team so if you have any questions for this feature something specific make sure to ask them because we can get those answered also any requests since they've already AC crewing a roadmap for this um I'm sure you can uh you can get your request in here so that the notes team is aware of that yeah all right um with that let me go back to my screen and see which questions we have here we go Liam he wants to know if there's a way to set up a specific AI worker on Q mode one GPU server don't want to host the main host on that server it would be great to have a dedicated working for us yeah so I think ol gave some context this but basically um o Lama is going to be running separate from NN so NN worker is not running that so if in a local setup like this you would need some sort of perhaps load balancer and that running in your own um cluster of something there that's not part of the N part I would imagine um in the O ecosystem that comes up a lot hey I need to have this run a multiple pods and distributed sure there's open sour Solutions around that I think it's a great example of why we need your feedback on the self-hosted AI St because if we get people engaging with that uh we see that you guys like it that's something we can invest in and perhaps you know add some guidance on those kind of stuff yeah maybe also this is a question that's a bit beyond the starter kit uh for now right it just helps you like quickly boot up uh projects if you have specific requirements like that you can already install a Lama on a different machine and just connect to that from your uh your open AI node most definely yeah so okay let me just see if there's any more questions no that appears to be it folks um again uh one thing I was able to get set up and there's a tutorial on it in the read me is runp POD it's pretty simple to spin up a GPU if you do want to be testing things that are beyond the limitations of your computer today and then you can also delete it so then the data kind of it can be encrypted so even though being sent to the Run pod you could still sort of eviscerate that super nice well that's nice for my little potato laptop to run stuff like that as well yeah brilliant okay um all right that was it for the product updates yeah wow some really powerful stuff and you could tell like we were excited about it yeah definitely awesome um I'm going to speed up a little bit because we have half an hour left and some really cool stuff to share um on the side of job

### [24:57](https://www.youtube.com/watch?v=oKuNcc_nWRM&t=1497s) Job Updates

updates we have 10 job openings right now wow we're growing fast it's like almost every week we see new faces here right now and it's kind of hard to keep track yeah at the next offsite we're definitely going to need some name tags but yeah we will and actually so max mentions that in in October we'll be spending a couple of days with the entire team in Italy yeah tusy yeah it's such a hard job someone's got to do it yeah true yeah no but that's like if you're not aware N1 is a like fully remote company we have a tiny office here in Berlin that people can travel to uh but we have a team distributed over Europe we have two team members in the US as well on the East Coast but we try to keep everything within EU time zones just to make the collaboration smoother um but yeah if you're fully remote you need to come together every now and then and just like share a meal share a drink get to know each other or few or more than one yeah but yeah so but the the main roles that I want to highlight today are these three we're looking for a new head of support uh for engineering we're looking for two product managers uh on the integration side that means like you you'll be working on the strategy for the development of nodes like prioritizing which new nodes we need which existing nodes need more attention so that's like an important thing for us to understand our user needs there and work on the right thing and it's really the heart of the product right imagine a canvas with no notes it's a rather sad C oh yeah true but it's also like sometimes really easy for us like some uh you have like a vocal minority where like sometimes you hear a few people complain about the small problem and we need to have like proper insight into the data and say like okay how many people actually run into this like yeah if we spend a day of work on something how can we make sure it's affects the most users yeah I think an analytical mind is going to be super helpful for that role definitely yeah um and then on the AI feature set we need a senior product manager as well to help us map out our strategy there how is our AI support going to grow how is AI used within NN going to uh to continue yeah that's going to be a really interesting role with a lot of great challenges and I think you know you're building the future basically fast moving very fast moving yeah um if you're interested in uh in working for n check out N. C careers and you find the full list and like bit about our company culture and our values and our team spirit Etc so um so yeah I think that brings us to the main part of this show worklow showcase yes H we had five people lined up for you um who are going to show very different types of uses of N1 actually four and one application for n bonus yeah very cool unexpected thing so it's going to be very cool um we're going to take you through them one by one and they're going to show their work they all have about five minutes to uh to show what fantastic yeah all right and we're kicking off yeah so the first one's from G here

### [27:56](https://www.youtube.com/watch?v=oKuNcc_nWRM&t=1676s) Workflow Showcase: Guilherme Salomão: "2-way sync between Notion and Google Calendar"

it's a two-way sync between notion and Google Calendar so notion has added a new calendar product notion usually has very thoughtful designs it's fantastic I haven't I used it too much myself but usually they build very high quality features at the same time probably got a lot of people that still want to be operating in Google Calendar or switching between the two so we showing how to do a two-way sync between them and the thing about two-way syncs I think oneway syns you know a lot of our competitors well show a lot of one-way sinks two-way syns are much more complicated Beast right you have to identify uniqueness in the source and Target system and they're both source and Target and managing all that so I think it's going to be really uh interesting workflow and like showing a really sort of meaty powerful problem that you might not do in a Meetup yeah uh let's see how G fix that yeah so G are you ready to show us your float yeah I'm ready I'm going to share my screen here fantastic take it away okay are you guys seeing my screen right now we do yes okay so since I started using ocean I've always wanted it to sync tasks and meetings with Google Calendar and they promised this feature a long time ago but instead they delivered notion calendar which still doesn't fully sync with Google so here's the workflow that solves that and it can sync multiple notion databases to your Google calendar and it works both ways that's a two-way sync right um so I'm going to demonstrate here real quick so we can have enough time for it to sync it takes a minute to sync I'm going to drag this test meeting to the next day so on the 23rd and I'm going to transform this test task into a full day event on the 24th so here we have um the test meeting here on the 22nd and it's going to change to the 23rd and it was less edited by na10 so here's one thing that I do to try to make the 2-way sync work because we have to know if the last change was made by the bot by the automation or by a user so this is one way to make that possible and here on the tasks we have August 24th which I think has already changed yeah so this one already happened I'm going to change it a little again so you can see it working okay so this one's going to change and this is the workflow here uh so we have part yeah it's huge because it it's not very process heavy it's just it just has like many conditions and I wanted to make the more user friendly so the conditions are here instead of inside a code node which could be a smaller workflow but it wouldn't be as user friendly as this one and here on the upper part we have notion to Google and on the lower part we have Google to notion and um we also have another feature here which is very interesting uh we can click and view the page in notion very quickly so this is a feature I got from the notion calendar that's where the idea came from and here what makes possible for syncing multiple databases is the globals here we can Define the relationship between a database and a calendar you can make all your notion databases sync with only one Google Calendar that's an option but if you can also separate them like I did here I have my meetings and my tasks right so that's an option you can choose where to sync them and this is the the ID of the na10 user it's like notion treats a connection an integration as a user that's why it shows up here as last at dead bu any 10 okay and you can give it a name give it a logo like I did um the way I tried to the way I did for the automation to differentiate if the user and the automation did the changes is by using extended properties in the Google API so you can here you can Define uh like variables inside the event and you can Define uh the last time it was changed so by doing that I can check if the last change was made only two seconds ago and then I would know it was made by the bot otherwise I would end up with an infinite Loop the change being made by the automation it being detected Again by the trigger and that's how we have to stop the infinite loot for from happening and this is the workflow is so big because we have to deal with different uh situations here notion and Google treat States differently so sometimes I have to add one day to the end date like I do here and for each situation here like one date two dates one date with time two dates with times each situation needs a different treatment so this is the workflow it's available for purchase here on the on na10 and that's how I buil a chway sync between notion and Google Calendar respect cool I think one of the things that's really use as you find it as you have automations running in your system is the who was made by n because usually when using these impersonation accounts yourself like well I didn't do that which of my fles which of yeah so super useful thing smart mechis too to use that user as an indicator of it hasen't been updated already yeah thanks G this was awesome yeah uh please send that link to us as well so we can add it to the show notes later okay can I send it here in the chat yeah of course yeah right there was one question from Liam uh he asked if there's a case if there's conflicting edits which could happen if you change both notion and Gmail Google Calendar at the same time I'm sorry I didn't understand the question uh what happens if you change something in notion and Google Calendar at the same time um it will probably get the last uh updated time and make the last change you made so if you change like in one at the same minute before the automation runs uh it will probably get the last updated time but that's not a test I have done because uh it's for personal use not for like Enterprise use so there's no reason you're going to change the time you'll have to try real hard to make two changes at once yeah in one minute in less than one minute sometime sometimes brilliant okay thank you so much this was a really great use case yeah um cool um I will uh let me take a look our next presentation is you could share your that screen there yeah I'll oops oh we'll be sh yeah I'll be sharing the other host soon next up is Andy

### [35:38](https://www.youtube.com/watch?v=oKuNcc_nWRM&t=2138s) Workflow Showcase: Andy Slack: "AWS Domain Redirects"

who's going to show us how we set up AWS and Cloud front domain redirect uh in combination with bubble so he use an as the back end and bubble. io as the front end for his project Andy are you ready hey guys yeah I'm ready let me just share my screen um cool so before I share just a little use case um so I wanted to see how bubble uh well how n could interact quite nicely with no code low code Builders like bubble w wler and things like this um and I had a use case where I had very infrequently but often needed to redirect um secure domains from one to another or redirect a secure domain to another URL um and doing it by hand or in the graphical interface of AWS is a real pain because you have to remember all the different steps the different things that you need to go through to do it so I thought okay perfect use case to see how we could connect an NA workflow with a uh with an app front end so I'll just share this now um so basically what we have is we have this website effectively this is the bubble interface where I can put in a domain name where the one I want to Red redirect from and where I want it to go to so I just set up this example demo. jua. com to redirect Google and then choosing the infrastructure putting in your keys so basically you can use your own infrastructure your own AWS account to create this redirect um and then when you create the redirect this is sending a web a post into the n workflow basically so I don't know if we're going to get the whole thing to complete within 5 minutes but we'll see um but as you can see it's basically now performing the uh redirect and it's um interface is nice with AWS and it's looping through all the steps which I'll show you in a minute in Na and depending on the outcome of the work the the task it will write back to bubble and say whether it was completed successfully or whether it errored um so we're creating the SSL certificate at the moment me just switch to the workflow and if we look at the executions we can see we won't to see it because it's kind of running um but if I show you here what's happening is it's this is the original web hook request uh it's doing a few bits and Bobs it's actually so it passes the ID and then it goes to Bubble to verify that it's a genuine request and it pulls all the information back from Bubble for that specific request um and then we've only got AWS at the moment but we could add other services in the future and what it's doing is it's we have a number of steps here so connect to AWS create the check whether the root record exists create an the SSL certificate create the booket create the cloudfront distribution checking if there's any conflicts link the domain blah blah and then finally adds the DNS record to the cloud front so it sort of wires it all together what it's doing is it's basically creating the test at bubble so it's just basically passing the task and then it's looping through the different steps uh and calling the individual AWS SDK endpoints uh to do the relevant work and switch notes that's cool yeah it uh detects an error it kicks out the error and runs through like an error workflow which is like basically mocking it as an error in the uh bubble database um if it's successful it just carries on round through to the next uh the next activity and then finally hopefully we'll see this um it will finish the loop and it will come up and it will like scrub the secrets it will mark it as successful um at the moment sending me a slack message but uh what's quite nice is if it doesn't fail if it doesn't complete successfully then the user has the ability to like retry it so maybe there's a permissions issue in AWS like they've not set the right permissions for cloud front or something they can actually go into a update their user permissions and then they can rerun the workflow and it will just recycle that around and depending on where we are okay we're it's a bit slow because it takes a bit of time for these things to create in AWS um but I'm up to my five minutes now so we won't maybe we won't see if it finishes or not but I think one of the things that's really interesting about this happens all the time when you have to do a task and each of the steps takes the computer a minute or two and it's not enough time to switch context you just kind of end up sitting there watching like right now we'd have to wait and sit and I'm sure you used to have to do that in between these cuz it's not long enough for you to go do something else but now you can chain them all up so you go back to the screen you get something else done and it's finished Che back in half an hour it's done yeah um and two things one is please recycle your AWS keys because they were on screen make sure of that and another one is uh Sean just asked hang on where did that go right here could you show the part that's actually updating the bubble UI because that's very interesting and I agree I did a bit of work in bubble myself and I that makes it the looks so much nicer yeah okay so inside Buble um oh no just here the note here that updates yeah how are you um because is it sending multiple requests back how are you getting the information to move on to the next step in your UI from the CH sure yeah so this is basically the the basically it's patching a record inside B based on the ID of the and it's update um the step to be completed basically it creates so we have one record which is the redirect and then we have a bunch of uh we have another table that stores each individual uh can't remember what I called them but basically task um and then it will start up as pending go to completed or errored and the interface cuz uh it's quite nice the way that bubble just is live it's running live so if a new task is added to the task database it will show it in the interface and it will there's just some like if statements if it's errored show a red message if it's you know if it's completed show the green message stuff like that maybe we can talk a bit more about this in the chat afterwards we're running slightly out of time so we need to move on to the next one Andy this was awesome thank you for sharing thank you much that brings yeah so next we've got

### [42:56](https://www.youtube.com/watch?v=oKuNcc_nWRM&t=2576s) Workflow Showcase: Jim Le: "Survey Insights with Qdrant, Python and Information Extractor"

Jim Lee so Jim's been uh you'll probably if you in the templates Library you'll notice some of his contributions and he's got work for that basically handle survey insights so you know a survey might have hundreds or thousands of participants and it could take a research you know days or weeks to filter in group and extract those insights and whatnot and you know with the Advent of AI uh Jim's created a work for that does that for you he's uh using quadrant with that as well and so this could also uh Jim correct me if I'm wrong be run on the cell phone posted AI starter kits you could do this locally as well um but Jim are you ready to show us your flow yes I'm ready to go I'm just going to share my then please share your screen and the floor is yours for the next five minutes cheers than team um yeah so uh how it started was um I had sort of a problem where as you do you have these surveys taken sort of internally or externally but what you end up me collecting the sponses is the easy part um but insights from them is usually the challenge and when you have so this is an example um scenario you could have so you have this uh survey with like a ton of questions and equally a ton of answers right here and um usually you know your CEO is asking you for like yeah what does it mean you got all this data back how do you sort of process it and give the insights for you know actionable um actions I guess afterwards now you could um say for this question here you could grab all the answers and you stick them in the llm and you say give me the insights from this and what you end up with is something akin to Amazon reviews right Amazon reviews where it's like yeah there's some people said this and some people said that you know it's all fine theny but you take that back to your CEO and he's not too happy U because it doesn't really give him much to go off on uh to kind of do some actions um what uh sort of ux researchers did in because at my old place was um they would sort of group or kind of cluster responses together to sort of go a little bit deeper so deep down um into you know what are groups of people saying so what are sort of clusters of you know where are like the positives and negatives what are sort of people and you would have um sort of this yeah sort of the insights done that way right it's kind of more actionable because you know if um you know if the people are like having negative sort of responses you want to know who they are and and what they're exactly saying and you know how many like a ratio of people are saying this within the whole group now so that was kind of the problem I was facing with now um I did a naive way and I was like yeah I'll just get one of these responses and I'll compare it to another right and then another and then you just keep going like this but it's not really practical I mean it doesn't scale you know if you've got this many questions responses it's going to take you forever um and you probably will yeah it's just not a really enjoyable experience to do um so what I did is uh I used NN as a development tool to sort of come up with a solution and looking into clustering algorithms and I can show you the um workflow here and this workflow does exactly what I just uh kind of said What It Takes these responses and it appli um very powerful clustering algorithm which you know if you had 70 respondents it would sort of put um these 70 response all into groups um depending on the S similarities of their responses uh how I did it was um in this sort of survey here I plug all these um responses into quadrant um probably good to note is that there is sort of um metadata so it's important to get the metadata tagged correctly so when you actually fetch it back out you know what question you're dealing with and get that kind of met INF for like who was the participant uh who had this kind of response so that's uh how you kind of loaded the responses into to quadrant um once you have that in uh now I won't run these because they do take a little bit of time because you need to run the embeddings and stuff um but uh once you have that you go back into the sheet get the questions out and then you look through the questions when you get all the responses back and then you stick it in this node the python code node now what a lot of people don't uh realize is that the python code node is super powerful because it comes with basically all your machine learning libraries um numpy uh psychic learn um N ntk I don't like some natural language algorithms all this comes with n builtin um it doesn't need to download it when the first time you run it but once you have it it's much more powerful than something like the JavaScript ones JavaScript C because kind of all available here now this cling algorithm it's just a function it's insane it's illegal this shouldn't be allowed but this whole uh Crux of this workflow is 30 lines where the actual function is this line here so you give it the c means which is pulled from the psychic cluster library and here the only problem is you have to specify the number of clusters you want depending on your data you might want to adjust this um so if it's like a binary you might want two clusters kind of a yes or no otherwise yeah just um experiment with the number but here I said I kind of want 10 clusters um I'm giving you a one minute wording ah already okay so anyway way super easy super fast um and then yeah once you have the Clusters what your what you get back from the quadrant um well out the Clusters is the points like the IDS uh of the vectors and then you get the payloads from those points and then you stick each cluster into um an llm and what you come out with is something like this so here is the first question the yellow and you get these clusters so you can summarize them the groups you know who said what you know like number of responds in each and then yeah this is the data you need to you know create those actional points um sweet so um that's how kind of I solve this problem and it's kind of like have uh really I think it's quite impactful on you know how you would use it within your con company you can host this uh locally um because like yeah as long as you have I mean the llm part is just for the insid the AI part means the machine learning libraries yeah which is doing the heavy lifting here um can you wrap up please oh yeah okay so um yeah other than that these workflows are available in my R page um so you can check those out there Che thanks a lot very cool I've definitely been in that situation where I got way too many responses absolutely to handle I can imagine our product team is going to be setting this up pretty sharp this year MH yeah we'll be looking at that workflow brilliant thanks Jim this was amazing cheers um and then uh finally we have uh our ambassador Liam uh who didn't build a workflow but rather like a rapper for n oh I forget someone I'm skipping the program here jur uh is first and this one's actually I really like this because he's using home assistant and N together I'm a bit of a home assistant not myself yeah my house runs on it and uh jurk helped save heating costs in a medical center jurk oh okay you got that one okay I'll uh share the right one here right now so uh okay it's more about the story

### [51:18](https://www.youtube.com/watch?v=oKuNcc_nWRM&t=3078s) Workflow Showcase: Jörg Zastrau: "Calendar-based room temperature reduction"

behind this and the workflow it's not that complicated but uh the story is kind of interesting because in 2022 March me and my wife we are both kind of seasoned and haven't done any programming for like um maybe 20 years uh we started um orthodontic office it has 13 radiators and we both of us use it only two to three days a week so it's really a hobby project or part-time project now we had this war going on and the German government said okay guys go save some gas so I thought about it what could be our contribution so I went out for buying some Automotion home kit and that's supposed to work with n8n and open Dental software because open Dental software has as a office management system a pretty huge API that works pretty well with nhn the open Dental software is really 90s or like really all they attach the API later on so it shows but you can extend that software and on the other hand we have the integration with a uh radiation control with home assistant and thankfully nhn has a node for a home assistant so I'm going to show you real quick how this works uh so I have to switch me see why this doesn't work I have to go here okay so this is the workflow no first I show you open Dental which is another calendar application so you see still see J and not the workflow yet you want to see the workflow Oh I thought that's what you wanted to do oh no no I want to show you because this open Dental that's not a normal calendar application that's a normal Dental uh calendar application that separates data personal data application and uh like other private data so you have a huge API because you have to ask for appointments separately from like procedures for like Dental stuff so and you can move it around like everybody's say like everywhere else okay so just to show you how this looks and yeah move appointment it moves we don't see that screen y we only see the slide that says calendar based room temperature control yeah oh this is not good computers uh computers you know okay so I have to give it you know this is basically there we go well it's a calendar application oh 90s indeed it's it's a more complicated calendar application all good so I have to go back here you know I'm aged so I'll show you the workflow is with all of our workflow that I upload to the uh open tle Forum by the way uh because I need a backup so I just uploaded to the internet to quote lenus toal and this is relatively easy so we get really all the appointments here today and then we convert the times to UDC which is very cool every time you do this because you might be in Us in different time zones you want to do that and then you calculate the end of the day and now we have some weird 90s stuff here so we have the beginning of the appointment and then we have this pattern the pattern says two slashes means this is each 10 minutes the assistant starts and two x's the doctor works on it and two x's is ass system cleans up so this is total of 60 Minutes you so you have to kind of calculate it here I mean easy but weird so okay that's uh reading from the 90s then when we're done with that we just keep it easy takes a whole list of appointments sort it up and down pick the end of the day pick the start of the day at some point we calculate the common time compare it and put it to the home assistant temperature which is very easy if you take that note it just says set temperature entity in this time low temperature 17° celius all the other one says that's about it so nothing to say about it and last thing I want to show you is how it looks so this is sad news uh after we've done this with uh 13 of those radiators we figured out our opposites above the heating room so it was kind of pointless but we still saving for everybody so at the time so you did not do any actual energy saving okay thank you thank thanks so I think what's really cool about this of course is you know we see a lot of uh fun workflows that can you know maybe light you or something but this is saving CO2 this is uh precious natural resources imagine if a couple thousand users set this up a couple offices couple you know that's powerful stuff and probably the native solution is probably vendors selling you these management softwares that rather expensive be way more flexible way exactly it's uh I talked to home assistants a couple months ago and uh we yeah we' really like to see if we can integrate better uh because it's like these kind of workflow are very useful for many not just offices and that kind well thank you so much um and with that uh now we really are at the last part of

### [57:10](https://www.youtube.com/watch?v=oKuNcc_nWRM&t=3430s) Workflow Showcase: Liam McCarrigle: "A Smart Installer Script for n8n"

the meeting Liam um can you show your thing in two three minutes absolutely can you hear me okay yes the floor is yours perfect I'll copy and paste this in here too so anyone can go check it out so uh you said it's a wrapper it might that might be uh an over classification of it it's kind of a uh um elaborate copy and paste uh except you can select it's essentially just a way to automatically configure your um Docker files and stuff like that with prompts it will even do a cloud flare tunnel for you and I'm going to add engine X um and a few other stuff later but it only sets it up then you have to manually configure stuff after that um essentially what happened is and I'll share my screen here Liam do you have a say that one more time I was just asking if you do have a screen to share there perfect yep so I just have so the get all you have to do is run this one command and it will you can run it on any Linux machine or a Mac and it will download all the dependencies needed um Docker everything and then it will uh essentially create the directories with the docker files and then run Docker compose uh and if you run it I have a little GIF here that shows it but I could very briefly show what it does it should only take a minute since I pre-installed the dependencies zoom makes it tough to share your screen properly hold on okay so I'll run it here and it will go through and very quickly let you set it up so I can say simple and quick I can put in just something because I'm not setting up the tunnel uh you can put your time zone in it shows you so you won't put in I see people put in the offsets and it doesn't really work so I put it all as a list I won't set up the tunnel so I don't share my key the time zone setting that that's GNA prevent so many issues oh something happen with the docker I think you know I just ran the main Docker script I mean the python script instead of the install command I promise this works I don't know that's the first time I got that error but essent you can look through here you can try it on any VPS or on your Mac or it probably runs on WSL too and it takes if you run go through the simple mode it's really three questions um and then if you want to set up the tunnel you just need a your account ID and your token and it will like in literally three minutes set it up make it accessible from the internet and um have an SSL and everything like that and you're ready to go and then any configuration and it pastes in a uh in the docker compos file and in the EnV file it puts almost all of the variables that are available all the environment variables and has them commented out so if you want to go in and change stuff you don't have to be going back and forth to the docs um you can just uncomment stuff change it you know comment it out do stuff like that really I made this because I was lazy and I was setting up a new nadn instance I was like you know what I think a lot of us team it in a pretty lazy in that same kind of way and the typical uh Catch 22 with programmers is I wanted to be lazy so I spent an entire day making a tool to save five minutes to save five inputs yeah but I mean I put these five those five inputs in a whole bunch of time so and also the sense to you're making us look real bad now well I think what's great about this is It's reducing the friction right it creates a lot of discoverability for all these settings sometimes once it's set up then you got to turn it back off and up play and it's great the yeah one of the big things is with the advanced setup it goes through pretty much every environment variable uh it breaks it up by section so you can just skip whole section so you don't have to answer every question but there's so many variables in there that even though I'm an advanced user and have been for a while that I didn't really even know about so when someone's new and putting it in the variables are super um intimidating so when you have it all listed out in front of you have a lot more to play around with right away and this if you're putting it up on Len Noe or hetner or something it's really a couple minutes and you can start it stop it and do whatever have a bunch play around with it super nice do share the link and we'll share with the community as well yeah and Li just like thank you I think a lot of these things what I love about the ended End Community is you know to make something there some effort but then it's some more effort to get it you know public write up little read me that gift in there and everything to make sure that you can share that value with others and I love how often in the community people have this intrinsic desire to do that to share to be helpful so thanks Liam that's a really cool energy sort of paying forward into the community appreciate that thank you I I'll WR up a community post after this too so I can share with else awesome okay um okay with that we reached the end of our official part of the program Just One Last uh comment our next hangout will be on Thursday September 26 uh as I mentioned before our next uh Meetup will be in Prague on September 18 so it's going to be a busy month again um but yeah we're looking forward to seeing you guys again uh until to then and Max thanks so much for co-hosting this with me likewise this was a blast next time yeah let's try and make that happen I love it fantastic let's do that everyone thanks for watching see you again next month CIA ciao

---
*Источник: https://ekstraktznaniy.ru/video/15629*