Creating custom integrations with n8n - Maxim Poulsen

so maxim is an engineer working for wipe his role is to bring technical touch to the business operations of company creating processes implementing automations connecting tools creating a data architecture and facilitating the day-to-day operations for the employees maxim also partnered with ml school to teach other people how to create automation workflows with an attempt thanks for joining in maxine over to you hi everyone thanks for having me i'm super glad to be able to give you a little um talk during this community meetup so i'm just going to share my screen can everyone see my screen yep perfect yep so um today i'm going to talk to you a bit about how we use naden to connect our apps our product um to our everyday tools um so just to give you a quick idea of what we do at vibe so vibe is the web technology of visual support and knowledge management and basically we integrate video calls into everyday tools uh ibm maximo salesforce zendesk microsoft dynamics et cetera and what's the id why do we do this because by replacing you know radio and phone calls by video we increase first call resolution rates increase net promoter score and decrease machine downtime displacements and ctraditions what was the challenge so each one of our clients has their own docker container on which they have their own web which means that for each docker container we have a different database and it's very complicated for us to access all of our databases um without having to run through different logins and authentication um and honestly when i was talking with the tech team they weren't really glad with me authenticating to vibe through cloud platforms that we don't host ourselves so um what was the objective and the objective as i was saying earlier was to connect um so vibe to first of all um a google big query database on which we can plug for example a google data studio and better understand our user uh like user actions user interactions um be able to figure out you know when a customer is likely to turn how many calls how many tickets etc and also to have you know duplicate of all the information that was in vibe in our hubspot so our crm most notably user lists um bad feedbacks for customer success and tracking user onboarding and so a solution that we decided to go with it was

web hooks so basically um every time that a notable event happens in vibe a web hook is sent to naden and it then will of course work with this data and send it to bigquery and depending on different cases to hubspot um so let me just show you what it looks like this is a pretty big one so don't get scared quite a few nodes yeah i can see max shearing yeah it's pretty huge um but basically we have one single point where all of our web hooks are sent so this webhook node and then of course you know depending on the bajillion different options that we have whether it's a user web hook a ticket web hook a session web hook a creation of a call center or creation of an expertise you know we're going to format the data and send it all to bigquery and then we use the execute workflow here to do all of the extra actions so for example this is our bad feedback one here we have our user lists and our user onboardings this is also for bad feedbacks um if you guys want i can go a bit more in detail about how these work and then we also report everything to slack just to make sure that we see everything that goes through and don't have any specific errors um if so this was uh quite a big project um and it was actually co-developed with our tech team because i work on you know the more of the business operation side and don't really um have like my hands in the product um and this was you know one of the things that was a bit more difficult when when developing this workflow compared to many others um because you know having to constantly exchange with the tag team made it a bit more heavy and difficult to implement and we were a little bit less agile because i wasn't the only one working on the workflow and every time there was you know something was wrong with the web hook so that's some more missing we always had to ask for you know specific changes some of the really cool points that um that this solution entailed were well first of all we host and then on our own servers so we're not limited by you know number of workflow executions so uh an execution of the workflow every time an action happens wasn't really a problem for us you know we don't use nan. cloud and we also didn't have to authenticate to vibe on a server that was not under our control and it was also a real-time integration which means that um because of this where we actually can keep if i can show you really quickly we actually keep user lists in

hubspot so for each one of our clients we have a user list so here's the user list here's a user list and they're updated in real time and this means that you know our customer success managers can easily see from hubspot um where different clients are what different accounts have been created and how many calls have been going on you know we constantly update all of our contacts in hubspot with information from our product and um and this also allowed as i was explaining earlier to duplicate all of our data into google bigquery um and then we use this to create really complicated dashboards that we give access to the whole team so that they can you know analyze what's going on with our different clients um i have a so two more minutes um so this is what i wanted to talk about mainly today but i actually want did something yesterday that i thought was really cool and i wanted to share with you um so in google sheets there's a

function called import data and basically import data mimics what a webhook like mimics a get web book called so what i did was i created a workflow

that takes a user agent calls user stacks um api and uh parses the data that was uh like from the user agent and so the workflow looks something like this so basically here's webhook we set the query parameter called the api set the device browser etc and use the respond to webhook node to actually import the data back into google sheets so this is actually a really cool way that you can integrate a then two google sheets like instantaneously without having to set up like complicated scripts or something like that um basically all you have to do is set up the webhook node and then use a string formula something like this and you can send data to any n and with the respond to web hook node you can actually send it back to google sheets um so i thought that was pretty cool and i wanted to share with you guys today i think it has many different use cases so i'd be happy to uh happy to learn more um if you guys have any questions or anything like that i'd be glad to answer them and if not thanks for listening and um again happy to be here