Community Hangout, Friday, May 16: Workflow Showcase

all right everyone welcome to uh the May hangout uh this is we were Louis and I were just talking this is the fourth one this year and we feel pretty good about being able to do this regularly for now uh I really enjoy seeing all the people here we're getting a lot of great connections and uh I hear it's useful as well so that's awesome um we're going to do this one a little different and I'll explain to you why in a second um so the prr for today as always

I'll start with a couple of community updates and then Nick a program Pro product manager is here he'll be talking about couple of updates from his side uh we invited Candice um from our hiring team to talk about the jobs that we have and the culture at NN and then unfortunately we had a guest from the brain tumor charity who were going to talk about how they use n8n in a team setting uh they use it for different campaigns in different teams um but they had an issue today in their organization and he wasn't able to make it so we'll keep that one for another time he definitely wants to come back later instead we're going to do a thing called uh workflow showcase which I think could be really cool and I'll explain that right after um and then as always after wrapping up the official part I'll shut down the camera and we can just have a chat see what everyone say there's someone who didn't turn down his camera thank you um okay so the workflow showcase how does it work uh what we ask you to do is think about a workflow you worked on recently or let's say this year uh that you're particularly proud of or that you think is really interesting to share with others and that you can share with us in just three minutes so you can do a screen share uh where you just walk us through it and talk about the functionality and the features of N1 that you used and anyone that does that will receive one of these cool little notebooks that we created earlier this year you can't get them on our store but you can get them today um and if you want to participate you can go to bitly slnn workflow showcase you can enter your name and your email address and uh say a few words about what you want to share here and then we'll put you uh in a lineup and I'll call out your names at the end of the show so we can share all the uh the workflows Louis is going to paste this link into the chat as well so it's easier for you to access or uh go back to it if you

forgot with that said uh on the community update side um last month I already mentioned that we're working on an ambassador program um and I can uh shed a bit more light on that now for you so we have decided to focus on three different types of activities for now so we'll be looking at events at meetups and on like more educational activities uh on the events side what we're thinking of doing is uh supporting people who represent NN it at uh let's say conferences or other kinds of activities in some way like uh we now have gex he might be around I think he signed up um and Alberto you're going to be speaking at an web they did this all by themselves and they're just excited about N1 and they want to say a few words about uh how they use us and in return we'll just promote the events and uh send them some swag or like any kind of support that they need they'll get this is not an official this is not like fully developed part yet but like we're starting to x on it um the next bit the meetups uh is closer to release if I can call it that and I will say a few words about that after this and the workshops on education will also happen later this year we're thinking at supporting uh like real uh real life uh workshops let's say you want to give a little training uh in your town or at your company or something like that or you want to do something online like you want to create specific YouTube tutorials that are very educational in nature we'd really like to uh to work with you and support those activities as well so on the Meetup side what we want to do is uh create a couple of ideas for how you could host your meetups maybe you you've already done it before and this is easy for you but if you're new to it uh it's good to have a couple of pointers to help you get started uh so we can help think about like what can you do as a Meetup what type of what does the event look like how do you plan this how do you communicate it uh how do you like run the event Etc uh we can help with us I wrote down manual but it's more like suggestions right it's still your event so you're in charge um we'll have office hours for hosts so if you are stuck and you need some uh inspiration or you have specific questions we're here to help out we'll also have a slack Channel where ambassadors can join us so it's going to be really easy to communicate with uh with the community team on those things um we'll of course promote your events right we have social media we have a newsletter all those things we'll make sure it reaches the community and they know that you're doing this thing we'll we're working on uh a collection of Swag like uh stickers or other giveaways that we can send you away so you can make it great event and we'll also support uh the uh support you financially so you're able to uh get some drinks and snacks or maybe you pay need to pay a little towards renting a venue or something like that so we just want to make sure you're not on your own right we're like if you run this thing we think it's great we really want to show you how much we appreciate that um and we'll help out with it as well the picture that you see here is uh y oberhauser our found and CEO he was in San Francisco last night and we had a like informal little meet up there um two people showed up and they had a great time they talked for more than an hour about all kinds of features how they used an 10 and their company and they had questions about Enterprise Stuff Etc so that was really great so that's already a Meetup right if you just meet a couple of people for a drink and talk about n10 that already counts it doesn't need to be super big or anything um also I'm getting closer to uh hosting a Meetup here in the Netherlands uh it's going to be at the end of June uh on a Thursday or Friday afternoon we're not sure yet around UT um if you want to know more or receive updates just email community nem. io and I'll put you on the mailing list for the event then finally um some other benefits for uh for ambassadors if you decide to join this program we're working on a page where we can list all the ambass so you can see like who is who what are they doing what are they how are they helping in the ambassador program so maybe one person wants to focus on meetups only and the other one wants to do education only that's fine uh we'll have some exclusive swag for you as well so maybe we'll create like a like t-shirts or cap or something that's just for ambassadors but not for anyone else um as well as your personal uh Ambassador business cards could be useful um and as I mentioned before I will compensate you for cost do R like reasonable costs right um okay having said that we're taking applications now we're not quite ready to start but I would really appreciate it if you're interested then you can just fill out the uh registration form that I link to below it's bit bitly again nn- Ambassador dprogram and Louis maybe you can paste that link into the chat for me as well uh what we'll do is with every application that comes in we'll do a quick review uh and figure out like hey are we ready to support this yet um is this like in the right place as well so maybe we're focusing a bit more on specific areas right now so we'll let you know um and if we're not ready yet we'll just like keep you your information and we'll contact you later but we'll let you know how that goes once you're in the program we'll check in with you on a regular basis to make sure everything's going okay and you know what to do Etc um okay that's it enough about the ambassador program and then another quick update uh we have been working on the community newsletter that I mentioned uh last month on the side here you can see a little sneak peak there there's like a lot of LM ipum here but this is what we're thinking about right now is probably going to change a bit but it's going to contain a lot of different types of uh of updates we're going to be talking about like new blog posts Etc we have uh some really cool templates that have we have added to the cre Hub as well as Community updates so these hangouts or like maybe we're going to do a hackathon or something will all be in this news letter as well um it looks like we'll be able to send out the first uh email early June is um and you can already sign up now we just deployed this like 15 minutes ago so if you go to our homepage and you scroll all the way to the bottom there's a little box now where you can leave your email address and add yourself to it and I think that is all for me questions no questions Lis is that right Y no questions so far all right awesome well then it's on to Nick yeah thanks so much let me switch the video to Nick okay while Bart is figuring out the layout um I quickly want to talk

today um or I want to give an update how we think a I at n at then um we already talked about AI quite a lot also in the recent Community updates specifically about the part that you see on the left here which is nn4 AI um so the piece where you can use Advanced AI tools to build your own AI application with longchain um with um other Advanced a AI functions so I don't want to dive too deep into this but just mention that this is one part that we act actively think AI um but then the second part that we also think about is AI for n ATN which is basically using AI ourselves to make Ann easier quicker faster and nicer to use in general and I quickly wanted to give an update what we think about this topic and what we're currently cooking in this area so Bart maybe the next slide that's fine yeah so AI for n andn um so ultimately you might have seen some things already um because we already released some things in beta to kind of find out how they perform with real user problems but um the idea that we have is in general that we build one AI assistant that can help you with a lot of different problems that we see users face every day um one of them for example is helping you to build workflows be a plain English text um I think that is especially important for new users that maybe need to learn NN a little bit um so that they can get up to speed a little bit easier and in some cases this might also just be um faster right um then to help you set up credentials for your services often times setting up credentials is very cumbersome I for example even if I already set up the credentials once I still need to go to docs every time need to read through the docs page need to do all the steps takes a lot of time it's very um cumbersome to do um so this AI assistant will help you do that quicker and also easier um then it will be able to answer every question about NN based on our docs and also our Forum entries so it basically has NN knowledge that you can ask it um about if you have any questions um especially of course for new joiners I think this is particularly interesting how you can reference data or maybe have a concept in anet end that you don't quite understand um then you can just chat about it with the AI assistant then obviously AI is pretty good at writing code um so it would also be able to help you write codee expressions and SQL um in your things um then helping you to debug errors on node executions oftentimes that's a major block um when working with an NN you run a Noe um you get an error and you don't really know how to debug this what to do about it um so the assistant will help you here with one providing useful steps for you but also maybe doing some of the stuff for you already um and then also we want to help you to get data easily from any API out there we already have a note that kind of does that right the HTTP request note um which is often a little bit hard to set up especially for folks that are not so super technical you often need to read docs to set it up um again very cumbersome uh depends how much you like docs of course um but there's definitely people that want to set this up um quicker and we want to use AI basically to magically connect you to any API out there um you see here that um there are two beta tags in here um so let's jump on the next slide to talk about them because those are the ones that have had a little welcome um on some versions already um so for example the AI error helper um here's a screenshot of how that looked like there was basically this little s ski button in here that tried to help you with suggestions how to resolve bugs uh how to resolve errors in node executions um we tested that for a while didn't like the results so much we were not very happy with how it performed with actual problems so we um roll that back and up working on a much better version at the moment basically how this work uh most likely is that we have different agents that are specialized in different error types error buckets and will then be able to help you with a different error bucket it's much better than the last version that we released in I think 139 or something this made a release and then the other one that was just released now um is the ask AI in the HTTP request node um so basically in version 140 I think um we released this ask AI button in the HTTP request node that helps you to set up the Cur command basically so you would just need to mention the service and describe what you want to get from it and then it would come up with a curl for you um set up the right thing um there's a slight difference right now in this feature um between cloud and non-cloud so on cloud um we are using a vector store that is uh having knowledge about like 700 apis out there and their schemas um and on Cell hosted you need to provide a an environment variable and unfortunately it doesn't have this Vector stoneage so there we go with General AI knowledge oftentimes it performs very well um it's not as good as on cloud at the moment um but of course ultimately all these AI features should come to cloud and celled as well so that everyone can use them um I yeah and then maybe on the next slide before we jump into questions I saw a lot of chat messages already um please don't take this for granted um like we are Community here right so we're kind of sharing work in progress with you um but this is kind of what we imagine the UI ux to look like um so you will have this assistant that then is on the right you can chat with it um and it suggests you different things uh to resolve your error for example but also other things cool um next slide that was the last slide um so right maybe we can go into questions already if there are any but I think you need to refresh to order to see the questions sir refresh the hang on yeah that's weird here we go thanks okay yeah so let's jump in the first one um so some AI features are available in the community version with an own API key like the aski stuff um many things will be released to Cloud first to test it there because it's much easier with the security um and often times we also need to make sure that you are using a certain model that we pre-trained or something like this um so while we work on this will be mainly seeing the light on cloud um ultimately though it will come to self hosted as well for everyone um the next one I don't fully get Robert maybe you can elaborate what you what do you mean with a question or not otherwise we will just jump um if you don't want to speak feel free to just write something in the chat I can also uh reply um there in chat then um with the aski features have a limited number of requests currently we don't plan that um but as mentioned everything is working progress we will also need to find out how much a request costs on average um how much that is being used of course we don't want to go bankrupt just because we think AI is cool um but currently we don't plan to add a um limit there um the one thing that we think about is that we maybe have a free tier and like a paid add-on um where you then have unlimited requests um but yeah as mentioned nothing is decided there yet um will be decided once the features are a little bit further along in its development and then any possibilities of searching scraping AI of some sort for errors in the future um I'm not sure which errors you refer to um like mentioned we are already looking for um errors in notes so if you have any errors there for example a code note uh that is not doing what it should do um or something else then uh we will be looking at this but I see you already unmuted yourself so go ahead yeah I meant in the um when you get a error like in the HTTP if because you have the database of 700 or whatever um docs so I know that a lot of people have made scraping workflows and stuff like that I'm sure you can make some type of uh you know flow where you could look up try to find official docs for that thing and maybe scrape that live I mean that might be too much for a model that you host but maybe if there's it local models in the future or anything like that maybe that would be possible yeah it's very cool idea I think so far we're not looking into supporting any scraping activity with AI yet um but I also mentioned like a dot dot um there as mentioned this is very early um in our phases so if you have any ideas what AI could help you with uh which probably you have right now where you think AI can help you please feel free to just send them to board or in the Forum or wherever um super interested to hear where you think AI can help Nick there's one more question around uh security how's the data privacy handle and where's the AI hosted there already some threat with John reping there but ronal wanted to ask her on this yeah in the beginning um we are most likely using the open AI model um so that we will be sending data um to the open AI llm in the beginning um we might expand that later to maybe consider a self-hosted model um to for example have a little bit more data privacy um there but in the beginning we just want to see if we can make features that are valuable and helpful and we think currently open AI offers some of the best models to make results quickly so we will use those models in the beginning yeah and a potential future request around this will be that uh if users can disable completely uh the aski assistance in their instance correct uh that will be something that we will um do maybe via an environment uh variable for example um that you can just turn that off um for privacy reasons cool let does all of the questions that we have cool thanks so much well thanks Nick um then we will move on to Candace who is going to update us on working at N1 and hang on G I'm G up here I'll leave you the slides for I'll do the slides yeah awesome hi

everyone uh I'm kandace I'm in charge of hiring at na10 for go to market rols um and here's my colleague uh Matty who's in charge of hiring for Tech roles I also put our emails if you have any questions after the meeting you can screenshot and feel free to contact us um I wanted to give you a quick note about the culture at n10 and also potential open roles on the next slide just to in case someone is looking for a job or super motivated to join n10 so some of the roles that I'm going to be presenting are already on our website some others are about to be open so again if you have any questions feel free to contact us so we're looking for engineering managers um senior fullstack Engineers product designers as well as the leads um and also we're going to hire some potential contractors to help us build our uh workflow templates and also advocate for our developer Community uh in two different let's say expertise on itops and on sack Ops so if you or if you know anyone feel free to contact me and last but not least I'm not sure if there's anyone working in sales in that Meetup but just in case you know someone exceptional we're also hiring for an Enterprise account executive a bit more about um n1's culture to give you some uh let's say some will to come and join us so first of all I'm not sure if you guys know that but we're only 45 people so I think that a lot of people that are actually playing around with the tool are usually surprised that we're such a small team uh but we're growing quite rapidly five times per year at the moment um and I personally feel that the culture is great you've met a few of my colleagues but of course all of them are like this so a few things about us in terms of values uh we have four main values one is empowering others the other one is act with Integrity third one work with speed and efficiency which makes sense given what we're doing right and the last one is in inspiring and think big um about our culture what do people like about it basically so one thing that we say is that we have an ambitious but kind culture it comes from employees and not from the leadership team so that's interesting uh we're remote first and also answering for Liam at the moment we're not hiring in the US um but we're offering a relocation to Germany if people want to move from the US to Germany otherwise we hire anywhere uh or almost anywhere in Europe um remotely on local permanent contracts so again if you have any specific use case that you want to run by me you can send me an email um awesome colleagues of course a lot of ownership um which is deeply ingrained in the culture awesome product that people love of course you guys are here at the community hangout so you know a lot about it incredible growth um and the last two ones are mainly from Engineers so if anybody is thinking about joining the engineering team uh they love that there is no unnecessary meetings and we're working with a non-strict a pro process and I feel like it's also super important for a lot of people especially if you're coming from bigger companies last but not least if you want to see the open roles you can apply directly on our carrier website use the QR code it's the same link um and you can also join our talent community so if you're interested in joining n n10 in the future but there's no open roll for you can definitely um use that and put out your CV and tell us what you'd like to be doing with us I'm not sure if there is any if you have any question you can take the mic or also have the chat open Liam's question is here you already answered that right yeah is there anything else in the chat right now yeah I think it's completely fine to switch to the next um to The Next Step again I my email so feel free to contact me thank you guys okay um and that brings us to the last part of this hangout the workflow showcase and there is only one person who resp who responds for it so we'll start with that um maybe you'll be inspired by what they're doing and you can add your own story as well um so the idea is to get ready open your best workflow in the browser um and then we'll call your name but it's going to be Mario so you know um and then you'll have a couple of minutes to talk about it and since we don't have a lot of people uh doing that right now you can take a little bit more time if you need to um so uh Mario are you good to go yes thank you very much um I cannot share my screen yet okay is there a reason for that sir it says oh now you should be able to do it Mar no it works yeah perfect yeah so thanks for this opportunity um today I wanted to talk about data consistency by interoperability so nothing AI related unfortunately but I thought this topic is also worth mentioning um so before you continue are you already sharing your screen or not because I don't see yes I am doesn't it work yeah no it works uh you have to click at the top part to switch the layout or or stop sharing your screen I think then would I stop sharing no I mean b needs to stop sharing his screen let's see sorry about that guys this is a new territory okay cool does it work now yeah y great yeah so um this um my

problem was um that I guess we all know we have so many apps nowadays and um yeah it's hard to keep track of tests if you have multiple workspaces you have like private test business task and maybe you work in different companies and um for me it was important to have an overview of all my tests and all my events so all in one place and um I guess we agree on that we all love notion at least for me it applies um and notion is one of a big part of my management and I have at least two Works spaces in notion but again two Works spaces to task bases and then I have to jump around and that's was something I just didn't want anymore so I found uh one specific uh tool it's called Fantastical um which enables um Native Integrations of tasks in a calendar so I can even tick them off it's not like we don't have to misuse calendar item or events as test which many people do out there and I think it's a very bad user experience um because then you have to go into the description of the event and maybe jump to with a link to the task and only there you can mod so uh with this stack I have the ability to somehow get all my tasks in the system and what I need for that is Todo because that's supported in Fantastical so um if I have the ability to um synchronize the task to todoist I can show them here in uh like in Fantastical and move them around and um take them off but there is one particular problem with notion uh they do not have web Hooks and even worse the modified date it updates every minute and not every second and um to be then particularly sure that something has really changed you can only uh if you go for polling only be sure every two minutes that something has changed and that's yeah very slow and doesn't seem very seamless and I wanted to change that so I come up with the idea to build a workflow to emulate the webbook um so what I'm doing is um in this particular um what is it work workflow to um look for the tasks in notion every let's say 5 Seconds um that's by the way the major benefit so I get down from two minutes to every 5 seconds in the end um then I do so do efficient polling by um setting filters in the beginning that's all happens somewhere here and I um store every item I catch in super base to like it's like a caching in this case um then I do comparing what has changed and um in that uh after that I even um either update or maybe I have to even create this page in super base to have it for the next time laying around and um like every when everything is have been processed here I return it to like I push it to web hook and I can uh then move on to the synchronization which takes place in two different workflows this is the one for synchronizing tests from a notion to to- doist and triggered by the web hook I was just showing you guys um it's again U just uh principally is just um mapping the values and update them in uh to doist and the other way around it's the same just getting uh what is it here the custom web custom request I need to gather the tasks from todoist and then map them again here and update them accordingly and that's what this looks particularly like in uh Tod do or at least uh yeah let's make it here if I change this to Prior um priority then um pretty quickly so we have like 5 Seconds delay um which again for my from my expectations is very good for user experience works pretty fast and it also again updates in the calendar um you have here in this case the uh estimation marks which um set the priority and uh the coolest part is I can reschedule just by dragging or I can um complete a task and the information gets automatically updated in the source database yeah so that was the logic behind it there are any questions I me to do is user myself so I'm super interested in seeing these brilliant thanks Mario y um let's see who is next um I have on my list uh Liam and floron uh but I think you both had some concerns around privacy right do you still want to share something guys or not I am cleaning mine up now I'm just testing it I can also share one of my own projects if you guys are interested um floran what about you I tried not to show so much details uh um wait a second I like to blur my domain because it's publicly available um wait a second okay can you see my screen wait a second not yet yeah no yeah there we

go it's in notification system that's reminds me of for example going out and driving to a meeting so what it does is uh it runs every minute I think it get my location from my home assistant so my home assistant gets the location from my phone after that it's scraps my calendars and looks if there's a location in it so it uh calculate the latitude and longitude so I use a public service I think it's open street map or a for of open street map and then I calculate the distance between my location and the location from the meeting I can't show you this uh route because it's also self hosted and I don't want this publicly available um yeah I think it's grabed some other dat it's calculate how long it would take to go there plus an yeah a buffer time I call the buffer time so because I need some time to put my jacket on something like that and um yeah if the time is uh there to start or to start to go to this meeting I get a message the me message is written by open AI so it's a always a super nice text it's yeah it's friendly wait a second it's super friendly uh yeah it's friendly um it also makes it interesting for you to read every time see what came up with this beginning it was always super fun now maybe I can short it a little bit Yeah and after that I get a message via telegram because it's super easy to use the API from Telegram and I played around with the uhi text to speech and after that I also get a message with the audio file so I can play it for example with my um speakers here in the house yeah and that runs every minute because some of the parts are selfhosted it's not that cost efficient it's cost efficient because yeah what I use it doesn't matter yeah that's great that that's a very different type of workflow than what we usually see so that's very when interested interesting uh I can share it in the community board as well when you interested that would be really great stuff I can add and documentation as well how you can build up your own rooting service it's costs something like 20 Gigabytes and it's super fast but yeah you need a service like that that's not something open street map can do for you as well uh maybe I'm not 100% sure so yeah yeah and maybe if you're interested uh I think this would do very nicely as a template potentially so maybe you want to release this as a template o that's a great idea yeah that's my workflow for today really thanks Florian this was great you're welcome um Liam how are you how far are you I am doing great you ready to share you are I'm ready for you great let me see if I can find the right window out of the Thousand that I have open uh hopefully this is the right one yeah there you go okay great so you guys can see this yes so this is uh

pretty different I think that last one was just a smart home one too unfortunately I didn't get to pay attention very much because I was scrambling trying to make sure I wasn't sharing anything private here and uh made it on a different cloud account so I wasn't exposing my Endo but uh this is so my wife and I watch a lot of movies we watch on Plex which is a uh a home like a playback service everyone who knows about n then probably knows about plex too anyone who s hosting um so Plex has a web hook for whenever you're starting and stopping and the biggest problem with us watching movies is my wife really doesn't like when a dog or a pet dies in the movie so if it is and we want to watch the movie she at least wants to know when to close her eyes so I made this the other day on a whim where we get the web Hook from Plex and then Plex sends it as B the Json as binary so I extract it and it just filters out some stuff because I have about 10 users on my Flex and that you get the web hook for everything every time so it only sends it if it's playback start and movie type and then only if it's my or her account and then this is an HTTP request to the doesthe doog die. com DDD search so this is a uh free and crowdsourced and open source API with all kinds of like movie trigger stuff it has like some super oddly specific stuff like does someone's toenail fall off it's crazy so you can like look up any amount of triggers or anything in a movie it's here uh so all you have to do is search the title uh the convenient thing is since it's coming from Plex and that already Works off the IM MTB database it's already the right title um then it just goes in it checks from that response if the dog dies set it to true or false uh get the movie name with the release here to make sure we have the right thing um and if it is uh what's this just checking the Boolean yeah so this just stops the workflow if it's false and if it isn't the funny thing is a lot of people would use text or telegram or something my wife and I usually don't get the only thing we keep all our notifications on is our emails so um in here I just have a Turner so if it's her account it emails her and it says you don't want to watch this movie if it if it's my account it usually means we're watching together so it will send it to me and say oh you might want to check to make sure a dog doesn't die before this so instead of having an if statement I just have a Turner here where it says what is this uh title limbs okay so this is just essentially if it's my username it sends to me and if not it sends to my wife just so that I don't have to have the if statement same thing with the subject I have a different subject and some slightly different content so that's pretty much it it's uh it's pretty neat uh and just a little simple thing I figured that I would share I can show a test if you guys want to yeah do it so that website you can feed it any movie and it will give you like a list of specific trades and yeah I'll show you is just one of them is it DD I hope no bad things come up here I've seen a lot of web services but this one is okay different yeah there's tons of things like this it's it's pretty uh it's pretty fun it's great and they it's all free so let's see let's look up John Wick and you can see there's all these does someone leave without saying goodbye or there abusive parents there's all types of things it's crazy um so we can open up my Plex account and if we start playing which the Plex web hooks are very fast so probably already sent it let's see this I just threw this in the new account so hopefully this is actually going to send the web hook I don't know why this isn't working right now but anyway this is what this email will look like so it comes through my wife's name is Kanani might not like this movie I check this movie and uh does the dog D you know so it comes through really fast we've noticed it's like when we press play the email will be delivered before the movies even finish buffering so it's pretty neat nothing more than that this is probably one of the simplest workflows I have other than some like redirect utilities I honestly don't know what to say this is like one of the most creative workflows I've seen so far this deserves a social media Shout Out b for sure yeah definitely yeah we'll talk about this more SS good I have all types of funky things like this so I more where that came from brilliant all right thanks let's see if there is someone else who wants to take the wheel and Nate are you ready I think so I'm just looking for the share on here to share my screen there a green button at the bottom ah here we go yeah let's give this a

go okay can you see my screen yes okay so this one's pretty straightforward it's pretty quick but it's helpful so um I a member of different chambers of Commerce here and they have event pages with lots of events and to keep track of all of them is kind of a lot of work so I wrote an n8n workflow called local business intelligence and essentially this goes out and checks each of these pages to determine if events have been updated if they have it'll scrape the new data if they haven't it doesn't scrape data and then it'll go and log it in Google Cloud um big query and so it looks pretty simple the way this is running on nns hosting in the cloud um and I have a lot of workflows that basically support that major workflow there so for example over here under the other workflows it'll do things like um write data to Big query with checking the hashes so this little workflow will go in and look at the event and take the event data and hash it to come up with a number just to determine if it needs to write it or not and so that will hand the data over to another workflow over here the Chamber of Commerce and so this is a workflow that goes out and gets the request parses it into chunks and then takes those chunks and makes more chunks I guess is a way to put it and then eventually passes it to a hasher and if it passes the hash lookup it'll then write the event to the database and so this will happen for each of the sites that are connected to it and as I add new noes to it each of these websites are a little bit different in the way you have to scrape data so it's written in such a way that I can add more connectors to this over time and write a scraper per the event page that then logs all the data with the same kind of hashing that's essentially my presentation thanks nice very different too can you elaborate a little bit more on how you check if the data is already you have processed it before sure so over here in the big query with hashing so it's going to go in and get the events for it by selecting from Big query and then it's going to filter the data by existing hashes so I'll store each of these hash values uh using python I'll show you that briefly now there's a lot of ways to hash and the last time we had this meeting so a lot of folks informed me that I could use the crypto Json to do this um so I wrote its own little hashing essentially a workflow because I'll modify how it hashes over time but for now I'm just using the he the python code node in order to use the hash lib library to then generate a hash for it and it'll store those hashes in the database and then it checks the hashes each time it grabs the data to determine if they've been updated or not smart very interesting thank you yeah sure thanks mes um let's see is there anyone else who would like to take a go can I try sure um one

second um so this is a very simple way for me to manage um all the workflows I have too many workflows on any then um can anybody see my screen yeah um let's try yeah so I call n to add table and so basically I manage all my workflow in a very organized way I know which project is active I have text and I if I want to search a particular um workflow that has a particular tag like let's say slack or toggo um then I can do that and it's a very simple one you basically just uh when I execute this one it will just check if uh if a particular workflow is existing or not if not they would add and if there are discrepancy they would change the name um it doesn't include deletion because I would manually delete I don't want um any error to cause that and so I also have something call execution so I know which workflow with the red flag is I can execute it by just clicking something right so if let's say I go to uh workflow let's call it nnn Loop and let's say I change the name to Loop Number Two and I can then um and it then to add table and I can execute it and then I think it would run that it would run the a table to and then and you be running and then it will just update everything that I changed here um so it's just a way to manage all the stuff that I have test or actual say change the name and early I also execute it I think what I use was I use a web poop URL unique web poop with a different workflow call executing and just basically pull in the dynamic uh whatever workflow that I'm trying to and it just execute it so fairly simple but is very useful for me because I have a lot and I find it more intuitive to use table and yeah simple you built your own dashboards on top of andan that's pretty cool yeah yeah so basically I have my own kind of have my own UI and I think you can do the same with notion and if you refer a different way to do that but yeah just organization that's really cool very nice in the chat before the hangout started we were talking about folder support as well and I think you kind of solve that for yourself here right yeah kind of yeah I mean I have like I'm not sure like 30 and it's only going to increase and yeah or maybe n would build something similar in the future where we can manage inside sweet all right thanks Neo um by the way make sure you submit that form that we shared earlier so I can contact you and uh send you one of our notebooks right I don't think your email address is on the list yet um anyone else no if not then I I'm going to take a few minutes to talk about one of my own projects uh if that's okay with you guys because I do other stuff than uh nm2 I am active in the blender community

and so what you see here is one of the community sites that I run and uh it's very Graphics oriented so we have 3D artists and they create all kinds of cool stuff um but if you look at the top of the page you will notice this row of what we call a featured work and so what we do is whenever people post work that they created we have a group of like top users who will contribute them as candidates to be featured and what it looks like is we have a topic here where we have voting going on so let's say today earlier I posted this artwork here and it looks like this and there's a little poll saying hey I think I should feature it or not and we have agreed that if about 70% of the people have upvoted an artwork we can put it onto the feature grow um and from there what I do is I have this spreadsheet where I put all the work uh that we want to share um and I have a workflow that does a couple of things so based on this spreadsheet it will first send this artist uh a direct message on our Forum uh to let them know like hey you've been selected to be featured here are a couple of tips how you can prepare your work um and we'll also you will see a couple of image operations here um I'm going to crop their image to a square because that's how it looks at the top of our site and I'm going to put that in that direct message and that looks something like this so this is the message that they will receive like hey your avocado house is ready to be featured in about eight days from now here's what you can do here's what it will look like and often it will crop out the wrong parts right and so people know they need to update their image to match um and from there another workflow will uh set a new image to be featured three times a day sometimes four times a day depending on how long my queue is and it's will uh update the artwork it will put it on the featured row it will post a reply under it saying like hey congratulations you're now featured um it will also push it out to social media so it's going to share it on Twitter Facebook and uh Instagram um and then um that's it so basically I I'm only busy maintaining that spreadsheet and then three four times a day everything else happens automatically uh and if I did not have an to do this I would there would be no way I could like break my day break my work Focus like three four times a day to do a bit of social media posting Etc so this is pretty amazing and this is I did this two years ago or so when I started using n10 um and this is really the kind of functionality that's that brought me to love the product back at the time uh sorry if using the light seam Liam yeah I know um okay so yeah that's my little uh project and I use it for other stuff as well but yeah a lot of Community Management really benefits from uh this kind of sharing this kind of automation okay um I'll do one last check to see if there's anyone else who is interested in sharing one workflow and if not I'll just team flori wanted to share something ah sorry I just shared it I just submitted it that you have workflow in your list go ahead fan you already shared it I already shared it it's my calendar notification system oh okay I thought you wanted to do another one okay Brant so I'm going to close the official part then and anyone who wants can hang around a bit longer for uh just chatting if you want uh I'll stop the recording now so uh