YouTube Transcript:
Complete n8n Masterclass: Build Al Agents & Automate Workflows (Zero to Hero)

Skip watching entire videos - get the full transcript, search for keywords, and copy with one click.

AutoDub

Understand YouTube Foreign Videos

Immersive YouTube Dubbing in English

Break language barriers, embrace global quality content

Use for Free

Video Transcript

Video Summary

Summary

Core Theme

This content is a comprehensive tutorial on building AI agents and automations using the no-code platform N8N. It guides beginners from understanding basic concepts to implementing complex workflows, emphasizing practical application and real-world use cases.

Mind Map

Click to expand

Click to explore the full interactive mind map

Hey everyone, so welcome to this

complete video on building AI agents and

automation using NA10. While in this

video I will be taking you from complete

scratch that is someone who doesn't have

any idea about this tools or anything in

general to a pro where you will not only

understand about what are all these

tools why they are getting a lot of

traction and all the terminologies as

well and will be able to build

automation which can ease your

day-to-day workflow as well as agents AI

agents which you can integrate in your

application. Now if this is your very

first time understanding these uh terms

or NAN in general, I will highly suggest

to pay a lot of attention as I will be

covering about these terms in depth as

well and we'll be sharing my experience

of building these automation and using

them in my everyday life. Along with

that, please make sure that you bookmark

this video as this is going to be your

launching pad for all the future videos

and uh applications which I will be

building and I will be uploading every

week some use cases which can automate

your day-to-day activities and agents

which you can integrate into your

application. So this is going to be a

lot helpful. So do subscribe to my

channel as well. Furthermore, this is

going to be a nofluff video in which I

will not only be teaching you how to

drag and drop to create some funny

automations, but rather I will be

sharing that how can you master and edit

in and understand that very

comprehensively as well as share my

experiences of using these automation

and agent as part of my startup and also

how I have sold the same and use them in

my consulting business. So with that now

let's get started and make sure to

master these. Okay everyone so now let's

get started now complete AI automation

and agents with NA10 with my Kagarval.

Now I will be making sure that

throughout this full course we will be

understanding many things using a lot of

visualization tool as well as uh some

definition. So please make sure that you

download these and also uh build and

create your own note as I've already

said. So let's start. And the very first

thing which I would like to explain you

and instead of directly jumping onto

NA10 as an application, I would like to

first explain you on what exactly is

automation, what is agent and understand

the difference between the two and the

flow of them as well as that will be a

lot helpful in clearing your basics. So

let's start now. The module one is

automation. Let's see the same.

Automation is the process of using

technology to perform task without human

intervention. So as the name suggests we

are automating something where human

intervention is not needed making

repetitive or time consuming activities

faster and more efficient. So if there

is anything which you can define in a

flow where the steps are kind of

predefined those are the things which

you can automate. It is not a new

concept like we have been automating

stuff using the power of code or by

defining them properly. So automation

has been there and we have been

automating since the dawn of computers I

believe to make our life a lot easier.

Automations follow a fixed rule based

process. So there are rule based thing

which we can define and on that is where

automations are uh kind of following

that great for repetitive and

predictable task. Okay. So the example

is an email sent to every new customer

as soon as they sign up. So normally

whenever you sign up onto any website

you get an email. Now that email is

normally very generic and that is a kind

of an automation which gets triggered or

which gets into effect whenever you sign

up onto a website. So this is a kind of

an automation because here instead of

making a person sit what we can do is we

can define that okay anytime this action

happens this is where we have to just do

this particular task. So let's

understand the more understand the same

with a little bit of more example. So

automations are deterministic and

predefined. So this thing is very very

important to understand that automations

they are not fuzzy in nature. Now what

do I mean by fuzzy? They don't change

right. So they can be defined by rules.

They are deterministic and they can be

predefined like okay if this happens

then this is what should happen. I've

already given you an example. So sending

a welcome email to a new subscriber

after let's say they sign up for a

newsletter. Another very relatable uh

example can be a machine that makes

coffee at let's say 7:00 a.m. every day.

So let's say that you wake up and at

7:00 a.m. every day the machine starts

and makes the coffee for you. So this is

automation like one of the automation

and you will also see that how in your

day-today work in your day-to-day uh

office work as well. There are many

things which you do which are

predefined. You might have to send an

email to someone or you might have to go

through a spreadsheet of let's say

recent signups or leads of let's say any

sales business or something if you are

doing right. So all this comes into the

category of automation. Now the same is

different from agents something which

has been a lot of uh in the discussion

today gaining a lot of traction. An AI

agent is a node that uses artificial

intelligence to perform smart task like

analyzing text or making decisions. Now

this is very very important and

different from automation. The easiest

way you can understand this is in the

previous one where I gave you an example

that how this machine makes coffee at

7:00 a.m. every day. But let's say what

will happen if you are not home or let's

say you wake up at 10:00 when the

automations are defined since they are

deterministic they don't change they are

not smart the coffee will still be made

at 7:00 a.m. Right? Right? So I'm just

taking a very relatable example as this

is very important to understand. Whereas

when we talk about agents, they are just

like smart humans, digital smart humans,

they will be waiting and they will be

aware about your surroundings. And an AI

agent is like a super smart assistant.

this coffee machine. Now, if let's say

this is an agent, it will be

understanding and getting an idea about

the environment and it will be creating

the coffee for you at 10:00 a.m. Right?

So, we have the smart vacuum cleaner as

well now or let's say robot cleaner who

can understand the environment maybe

clean a little bit more hardly wherever

there is uh let's say some liquid

spillage. So all these are examples of

auto uh AI agents where we are

understanding and they are performing in

a nondeterministic manner by

understanding about the environment and

they can work on the fuzzy way where the

output input everything is not defined.

So based on this smartness which is

agent is able to perform a task which is

uh which requires this level of

intelligence. Now one thing to

understand is that it is not a

requirement that anytime you are doing

something you unnecessarily have to

include AI in that just as a very simple

example let's say if someone do sign up

on your website and you have to send

them a welcome mail in this there is no

agents or AI which is required you can

just directly do that uh without any uh

artificial intelligence so let's now

move forward and let's see the flow as

well there is a input which is a trigger

Right. So this trigger is something

which we will see in N8 end

terminologies as well. Then after the

trigger we have an action. Now this

action can be a single step or a

multi-step process. It can be as easy or

as complex depending on multiple uh

dependencies or having multiple

applications in between. So don't worry

we will be seeing each and everything.

We will be building them as well in end.

And then finally we have the output. So

in the output it can be a coffee, it can

be a email which you get, it can be some

newsletter that is the output which we

get. Now as I've already defined it can

be as simple if you are using just a

simple automation or it can be based on

and can be a lot personalized if you are

using some intelligent based on that. So

this means that based on our

understanding the input and the output

can be a lot same. uh just as an example

let's say you are signing up on an

website action is where it all depends

that how we have defined our action and

let's understand the same into a lot

more depth so I've created a better

diagram as that will help you to

understand this overall in a lot of

depth so let's see the same as well

everyone and you can download all these

uh images etc which I have created so do

make sure that you download them and

keep uh them you will find the links in

the comments now coming to the

automation You can see that how input is

a triggered event. So the input can be

let's say if you are sending a message

right or if you are signing up to any

newsletter or sending someone an email

then we can have a defined steps in

terms of an automation. So in an

automation we will be having these steps

defined. Now there can be a multi-step

process where let's say they are

checking a lot of thing as well and

after checking and making sure that okay

uh this is what the process you have

defined it will be having an output

which can be let's say the reply email

which can be a welcome email or anything

which we have defined so this is where

the automations are defined and this is

just kind of the action box which is

getting divided right on the other hand

when I do talk about agents

It is very important to understand the

same as well. In agent, we will be

having some AI or brain in between. Now

I normally always say that agent is just

or your AI agent is just a digital human

being. Okay, a machine with some

intelligence where it will be having

some memory. So just like us human, it

will be having the memory of the

previous interaction. It will be having

some tools. So maybe let's say it can

check about whether it can do some

calculation or it can get some real

world data and it will be having an AI

uh artificial intelligence which will be

AAI chat GPT Google Gemini or anthropic

clot which can help us in processing

tool usage rack and based on all of

these uh overall mind uh overall mind

and intelligence it will then be giving

you the output. So this time the output

can be a lot better if you have defined

them in a lot of better a lot in-depth

understanding. Furthermore, it can also

be fuzzy and a lot more personalized. So

it can very much happen that in terms of

automation you will be getting the

similar kind of a result but using the

power of AI now using these agents we

can give a much better and personalized

uh personalized overall experience. So

this is the very basic understanding

about these terms everyone. So let me

just zoom it out. Yeah. So automation

and agents though the flow is something

like this. We can have multiple steps in

automation which are predefined and

deterministic. Whereas in agents these

steps can be uh dependent on how your

how smart your agent is, what are the

tools which you have provided it and of

course on all the dependencies and how

you are managing that. So the very first

thing which you need to understand

before jumping and using any tool is

that automation is something which we

start off with first. So we automate and

understand that how can we do that and

in that uh in them is where we now

include more and more complex use cases

and we make them a lot smart and this is

something which you must have also seen.

As an example, uh you will be using a

lots of chatbot, right? So 10 years

back, our chatbot were not very smart.

If you used to send a message, you used

to get a reply which was very basic,

right? And those were kind of

automation. Since the advent of AI uh

specifically in the last 5 years, you

will see that how the chat bots and the

replies are getting a lot more smarter

because we are integrating AI or we are

integrating we can integrate agents into

that. something which I will also show

you towards the end that how can you

create a proper agent which can help you

to answer based on all the smartness or

everything which you give and that is

the reason that we need to now take and

understand from complete automation

towards the agent and how can we define

them even though the input and the

output can be the same. So as an example

if you used to send a message onto any

chat that is the input or a trigger

event and output is just the reply but

the major part or everything is

happening in middle or in the middle of

this process. So with that everyone we

will be first focusing on automations in

complete depth and then once we have

master automation then is when we will

be going to agents. Now one thing to

understand don't unnecessarily involve

or integrate AI or agents if that is not

required and I believe that that shall

be a lot clearer when I will be showing

you how to create this automation using

NAN. So now let's jump and let's go on

to the next slide where we will now see

NAN as an automation tool. So for those

of you who are not aware, let me go to

the NAN official website.

So as you can see everyone uh flexible

AI workflow automation for technical

team. So this is the official website

n.io. Let me zoom it in a little bit and

yeah with a good lightning sign. You can

see that how it is having a very good UI

kind of a no code kind of a approach to

building your automations which can be

used for IT operation, security

operation, devops, sales and of course

you so that you can build each and

everything the way we like for our

personal use case as well. It is gaining

lots of traction and has been used in

the industry by many of these good

companies and it is having so many

integrations. So over 500 plus

integration which I believe is uh the

best in the industry. Uh any application

which you will be using be it WhatsApp,

be it Telegram, LinkedIn, uh Google

Sheets, Gmail, all of these are present

by default as your integration in NAN.

So yeah, this is the overall NAN flow

where fast way to actually get AI

working in your business. So the main

idea is that if you do understand your

use case a lot better which I will be

explaining that how you define that and

everything you can use nitin to then

build and automate that and integrate in

your application. So with that everyone

now let's move forward and let me show

you that how you have to uh create an

account on this. Let me just open a new

incognito window. Just a second. So I

can go to a new window write n.io io and

go to the homepage again. Now again uh

before I move forward let's first see a

little bit more. Niten is an open-source

no code tool that lets you connect apps

and services to automate workflow and

integrate AIdriven task. So the best

part about this is that how it is a no

code tool. So if even if you are let's

say a fresher or even if you're in

college it will be very easy to

understand and in this whole video and

course I will be making sure that I

explain you things in depth as well. So

you don't have just a surface level idea

but you actually do understand that how

can you uh make complex workflows as

well in nan we can start from free and

it can be hosted locally or on cloud. So

I will explain you the same once we do

the signup process. It has more than 500

plus integration which with common

applications and AI. So common

application as I gave you the idea.

Coming to AI you can of course uh use

either open AI or any other provider as

well very much easily without coding

anything. So let's now see since as I

said no code tool easily use and master

it to build our automation and agents.

We will solely be focus on automation

first. Free to start uh beginner

friendly and packed with integrations

something which I have shown you. Now I

will be covering in depth as well that

how you can start with init about

different ways to run that as well. No

coding required just drag drop and

connect. So that is the most helpful

part and it doesn't mean that since

coding is not required it is uh let's

say not powerful. uh nit is pretty

powerful and it provides all the options

which I will be showcasing you as we set

it up. There's a huge nit community with

templates and tutorial to guide you as

well. So what do I mean by that

everyone? Uh if we go on the use cases

we can see that how it has provided you

with these templates right. So of course

this will make a lot more sense once you

have the basics clear. uh many students

uh and learners what they do and what I

feel is the biggest mistake they do they

directly go and just uh start off with

this and having no idea no base set they

are never able to take the complete

advantage as well as uh tune these use

cases which we have very nicely defined

based on our use cases uh based on our

overall uh requirement right so yeah

that is something which we will not be

doing everyone now yeah huge genet so I

will be showing you more templates as we

move forward forward. Now let's see and

move on to our next part where I will be

showing you NE and signup process and

what are the different ways of running

the same then we will walk through the

whole N and UI walk through right

whatever all are the options etc present

then Nate and workflow so this what you

see here the main thing we will be

working this drag and drop canvas

basically that is going to be the full

workflow and we will be defining our

very first automation. So these are the

things which we will be now uh defining

and mastering over the next uh half an

hour. So let's first jump on to seeing

that how can we run n. So there are

multiple ways of running n everyone. The

very first one is directly on n website.

So on this website you see that how we

have the sign in and getting started

button. So this is something which we

will be using uh signing in or let's say

getting started. Then after that next we

have running it locally and then we have

selfhosted on a server. So this I will

also be covering towards the end. First

we will see that how we can run it

directly. Now to make it a little bit

more clear I have created a better

example. So what you can do everyone you

can just think of uh different different

ways to run in this manner. Right? So

all of us have surely used Microsoft

Excel. Right? Now the way we used to run

Microsoft Excel uh like again 15 20

years back or maybe right now as well is

that we can directly run this onto our

laptop. Okay. So that is the local MSXL

installation or run. Now the reason I

have used these examples is that they

are I think relatable and understandable

by everyone. Doesn't matter if you are

again in college in school or even uh

let's say 5 10 15 year experience. So

yes all of us have run uh MSXL locally

we have installed the same and work on

that. Now again since the last 10 years

because of so much advancement in the

cloud computing what we can now also do

is we can run MSXL. Now many of you

might also be aware about Google Sheets

in this respect all night right and that

has been found to be a lot easier to at

least getting started with. So let me

show you that as well. Now pretty sure

that all of you are uh pretty aware

about Google Sheets as a whole. So let

me do sheets dot new sheets dot new

and we can just get started with a new

Google sheet. Right. So this is again

pretty much something like MS Excel but

what I would also like to show you is

that we have MS Excel online as well.

Right. So yeah, we can just directly go

on uh Microsoft Excel cloud and here I

can just create a new blank notebook or

I can just start this one as well and we

have MS Excel on cloud with very minimum

setup right you'll just need an account.

So that is the idea and that is how we

will be first seeing Nitin. Now as with

Excel right as with any software rather

there are multiple steps in running or

setting it up locally and what was this

third option self-hosted on a server

means now for people who don't have any

idea let's say just like any third party

computer right any third party system

where we can run the same so don't worry

on both of these as of now we will be

seeing that in depth let's first see

that how we can run it directly on n

just like we are running it nicely ly we

can run our MSXL nicely here. Okay. So

for that everyone now let's first go to

an incognito window. So I am in an

incognitive window and here I am on the

pricing tab. So how you can go there? We

can just go on the NA10 website and we

can go on pricing. So run workflow

automation without running out of

budget. Now you can have it monthly or

annually. You can see that how it is

having starter pro and onprise. And of

course there are different offerings

right. So again uh no need to pay it

provides you a 14-day free trial and if

you wish to continue once you do

understand and have mastered the same

then is when I suggest that you can

surely if you want you can just have it

directly uh run on nit only much like

Microsoft Excel online or Google sheets

or uh you based on how I will cover that

you can run it on your local or on to

some server as well right so with that

now let's move forward everyone uh you

will see that how we

free trial as an option and it is 14

days free trial and no credit card or

anything is required. So let me start

this free trial

and it is asking very basic information

start automating today. So what I can do

I can just normally enter my name Mayank

Agarval. Then I can just enter my email

id right. So let me just enter an email

id which I have not used here though I

guess I've used most of my email ids but

I think I might have one. So I can do a

with maygmail.com.

So you can reach out to me on this email

id as well everyone. Pretty easy to remembergmail.com.

I can just send a simple password. So

let's say

uh let's make it a lot easy.

I'm not going to tell you that.

And then it asks you for a account

So here now what you have to do everyone

you have to provide with the account

name. Now it can it you can just think

of this as your email address on N10

cloud just like how we create uh our

Excel sheets or Google sheets and we can

give it a name right. So let me just uh

do it learn maybe let's say learn nate

in with may I believe this should be uh

unique so let us just try it out and

this is a little longer should be fine.

Let me do one thing. Let me just zoom it

out and do start 14-day free trial. As

you can see, start automating today. We

can verify that okay, I'm a human. Let

me verify that I it has been verified.

We can have a newsletter as well. Again,

it will trigger an automation which will

send you an email. So, let's start our

14-day free trial.

And seems like it is starting. Okay. So,

few questions which I have to answer.

Let's see them.

Size of your company only me. Then team,

let's say I'm in it. Shall be fine.

I'm in education then

yeah we can select anything should be

fine okay and after how did you hear

about this uh so yeah we can select

anything other self

have you contacted uh no we will be

doing it ourself

and we can submit everything right so

here it is asking you to invite a team

member I think we can skip the save for

the time being and it's saying that our

workspace is part starting up. So yeah,

just let's wait a minute everyone and

seems like it has started and what we

can do is now we can click on this start automating.

So now you will see that how it is not nat.io

nat.io

it is your personal NAN which you have

provided. So learn NAN with mayang.app NAN.cloud

NAN.cloud

homeworkflows. Right now it is showing

that okay what is new and everything we

can start from scratch or test a simple

AI agent example. Now I will highly

suggest or either I will show you that

we will be starting from scratch only

directly starting with AI agent is like

not suggested because it will just skip

a lot of steps. So here what we can do

everyone you can see that how in this

overall UI right we have 14 days left in

our NAN trial it has zero by thousands

of execution now we can upgrade the same

as well if you remember we saw the

pricing so if I click on upgrade now it

will ask me to choose the plan and pay

for that so let's go back for the time

being let's not do that

and here we have everything related to

us we can create a workflow so That is

something which we will be doing and it

will just open a blank canvas.

After that we can go on personal where

everything will be there which we are

creating. So let's focus on this left

bar. Each and everything on the overview

we have the details like if we have done

any execution. So as and when we will

define our workflow the same can be

executed and in a free trial we have

thousand execution again way more than

enough for learning these things and you

can see that how it has a failure pro

execution failure rate time saved and

runtime average okay then how we can

create workflow credentials and how we

have execution so this overview in a way

is giving us each and everything a kind

of a summary about uh our overall this

particular application that is learn nit

with mayang then we can go on personal

here again I'm just being shown the

workflow credential and execution so all

what I will be creating and the next is

shared with you so here we can have

anything which is shared with me now if

you remember it did ask in the starting

that we can provide an email id so let's

say if you will provide your friend's

email id then you will be able to see

that here okay credentials and the

workflows so don't worry we will be

creating workflows and I will be showing

you that how exactly can you maybe share

that how you can start that then we have

projects so we can easily just define a

project here we can say that okay this

is learn any

and or rather learn like this my project

to learn to learn n

in depth and And then we have the

project members. Again the same thing we

can just divide it. So a logical

division and we can just save it. We can

see that how we can delete the project.

Now again uh the same has not been

created still but I can click a save

here. And seems like our project has

been created everyone. So just a

grouping a logical grouping kind of a

thing where I can again start from

scratch. Then we have few more things.

So admin panel right? I think many

things will be hided here only. So yeah,

it has just taken us outside onto that

dashboard. If you pay a little focus

here, you will see that how it is inside

our dashboard. If I click back, we were

in home and workflow. So let me just go

a little step ahead in the dashboard. I

can open this instance. It is again

giving me a summary and we can go onto

the forum as well. Now all these things

are very important to understand from a

fresher point of view as well as if you

are experienced because this remains the

same when you will be hosting it locally

or over a cloud as well. Right? So these

things are very very important. If you

have an idea you can surely jump on to

how I cover workflows but I will highly

suggest to understand them once and

since this is a lot comprehensive I

think you shall be done for life in

understanding this right. So with that

if I do on open instance

it will take us uh there only again back

to our home and workflows right so just

a kind of a middle screen in between

after that I can go on templates now if

you remember I told you that how in NAN

we have so many templates like there's a

very good community and you can just see

that so many of them are created like

let's say if I search for marketing

right then I can see how we can uh

dynamic generate a web page from user

request using open AI structured output.

So pretty specific use case and the good

thing again here you can see that how it

has been defined. Let me just zoom it in

a little bit and we can see the same

right it has been properly defined. Let

me click to explore. Here we can see

that how we have a web hook. Now how

they are created. Again uh let's not get

a lot ahead and we will be understanding

NAN first in depth instead of directly

jumping into these uh templates because

I believe that learning how to first use

NAN is very important and it will go a

long way then to just uh using some

templates right more or less you will be

just picking them up and if you don't

know the basics and if it don't run for

you you will be giving it uh giving up

on this templates right so with that let

me close list after that we have

variables everyone so in the variables

you can easily add your variable let's

say if I give name and let's say I give

my here now usage syntax this I will

show you a lot more in depth and I can

save it so we will see that right we can

use this across our workflow and the

best way of using these variable is uh

any constant which you are defining like

your API keys let's say open AI or

Gemini key you can define once and for

all here so that they can be referenced

inside your workflow easily. After that

we have the insights again it will make

a lot of sense once we run that we can

see all these graphs. Then we have the

help here where we can go on the quick

start videos the documentation right so

N10 has a pretty good documentation as

well where we can see that how we can

use the app quick start video courses

text courses though I have gone through

that and I will make sure that I'm

covering each and everything so you

don't have to worry and spend your time

in going through this and this video is

your uh final source and final way of

mastering any so with that Now let's

move forward everyone. We have again

many steps here. We have the forum. We

have the codes. We can report a bug and

see about Nit as well. Then what's new?

We will be having change log with

respect to different different version.

Let's see the full change log here. So

again in the release note we can see

what is the latest version and what is

the next version going to be. And of

course we can see that what are changes

which has happened. Okay. So we can see

the commits etc. This will take us to

the GitHub of NA10.

And here we have all the releases. You

can see that how it is having 117,000

star. And we can see all the releases

here. So pretty much in active

development. The last release was in

sorry the latest release was in last

week only.

Now uh what we have to do everyone let

me close this and this as well. I would

like to go on settings and just change

it to let's say a dark mode right so let

me just do the theme and change it to

dark theme and yeah I think this now is

something which a lot of you will like

so yes we do have theme as well let me

close this here you can see the name

last name email id and just like we can

have change the password or add two

factor authentication something a lot

suggested if you are going to use it uh

for production use cases, right? Then we

have users, right? How we can invite

someone as well and then there are many

few things which are just available on

the enterprise plan whenever you are

running it as a company uh default uh

let's say cloud. So SSO, LDAP,

environments, streaming and community

nodes. So I think we can just uh this

personal is where we have to see this

and we can go out. So this is all about

uh when you start Nit. Now this is going

to exactly the same. You can just think

that what all we have understood as of

now that was understanding this whole UI

the navigation etc in your Excel. Okay.

So again just taking very relatable

example so you don't feel that it is

very out of touch or out of world for

you. So pretty simple just like we

understand how we can click here how we

can save each and everything is

something which I have explained and

covered for you now the setting etc. Now

we will be focusing on this main part

right just like how in Excel this is the

main part where we will be actually

doing anything this is what we have to

now understand in depth everyone so

pretty sure that what all we have

covered is very very much clear please

make sure that you do understand that

now uh let's move forward and let's

start with our major canvas I will be

starting from scratch scratch right so

and this is going to open your canvas or

workflow for you now I will be clicking

this button everyone pay attention this

button to just close this sidebar this

sidebar has still not changed let me

close this and we have the canvas where

we will be working on any much like how

we have this whole uh cells in your

excel Okay,

great everyone. So now let's uh

understand the more major part where you

will be doing all your development or

dragging and dropping. Now I will also

be using a trial account only because I

want to face all the issues which you

might face while you're doing the same.

Right? So it's not that I will be

showing you something on the prod or

paid account or let's say on my hosted

account. No, we will be in the same

environment just like you will be. So

yeah this is the overall UI as of now.

Now of course with the major release

this can change but I believe if you

understand this in depth it will not be

a problem right just like how 2003

version of Excel and this one will just

have some issues in the placing of these

buttons maybe but overall the

understanding will go a long way. So we

will be doing the same in depth. Now

this is your canvas everyone just like

how you have a canvas for drawing right?

This is where all the magic will happen.

Now here you can see add the first step.

So we will understand about that. The

very first thing you can just zoom in

and zoom out. So either by your mouse

wheel by doing uh like basically moving

your mouse wheel or you can just do a on

your trackpad if you're doing it on a

laptop. You can easily just pinch in and

pinch out to do the same. You can zoom

in and zoom out using this buttons as

well. You have a reset zoom here. Right.

So you can press zero to reset and bring

it to the uh like the default level. Now

here uh you can just see zoom to fit as

well. So you will see that how in all

these things we are having this one uh

present right. So the good thing about

NAN as a whole is that it also supports

shortcut. So let's say if I'm just like

playing around somewhere and I if I

press press one now I will be at the

very starting or to the center right

similarly if I zoom in or zoom out a lot

the second I press zero it will be the

default zero and one to go to the center

of my overall uh canvas. Now uh you can

also do N8N shortcuts like to go and

learn about more of these shortcuts.

They are uh basically in the

documentation only and they are a lot

easy to understand and get hold of

because they are very much similar to

your other shortcut like control S to

save control O to open a workflow then

to undo then to redo. Right? So these

are all the shortcuts everyone. We can

see that how we can zoom in or zoom out

by using plus or minus zero to reset

zoom level uh everything then control

plus mouse wheel to zoom in and zoom out

right so yeah you can easily go through

that now uh before we jump on and create

anything what I would first like to show

you is that how we have a open notes

panel here which has a tab as a shortcut

and this thing is very important right I

will be making sure that all these which

I create I will be shar sharing them

with you right so I will tell how we can

uh see that and the second you press

this thing you get a note right so it is

just like uh sticky notes right so you

can just create them inside your canvas

for better understanding now I can just

say uh for all the shortcuts shortcuts

shortcuts

and I can just uh have this link right

so just let me make it a little bit

easier everyone shortcuts

And let me just change it. Right. So

these are in markdown. Now for those who

are not aware again since I'm covering

this for everyone. Markdown is this. You

can just go through this markdown guide,

right? It is having everything you need

to know about this. Markdown is just

like HTML the way of basically defining

and writing. So let me go back and now

you can see that how you can go

doubleclick to edit me and we are having

shortcuts here and the second I go out

you can click on this shortcut now and

you can just go onto that page. So this

you can move around in your canvas right

uh your init right it is based on

something known as nodes. So we will be

going a lot deep into that as well right

but should be fine for the time being

you can just drag and drop and play

around normally again I will be zooming

it out a little. So let me zoom it out a

little and you can see that how we are

able to drag it right now let's say if I

make it like this and if I press one now

I will be at the center. Okay. So this

is what one will be very helpful if you

are let's say created many nodes many

workflows it will be able to show you a

good nice view. Now after that everyone

let's see the same we have understood

everything here we can easily edit the

name as well. So my first workflow

and we can add tags. So let's say

learning or let's say learn n. Now you

can of course search with these tags.

You can manage these tags. That should

be pretty helpful. Now we will see that

how we can make it active something

which I will be doing uh afterwards

should be fine. How we can share the

same right? So sharing again is just

like how we can add someone we can share

them with anyone we want to do that. Now

uh one very very important thing is that

anytime we make any change anytime we

make any change you will see that how we

have to click this save right if you

don't do this if I close then everything

will be lost now very much like how uh

in excel we do this right so online we

have an autosave feature but in your

excel if you close that then it asks you

that hey do you want to save so similar

kind of thing will happen if I click

here it is asking save changes is before

leaving. So you can see that how the

design language is very similar and I

hope that with this example of Excel

everyone is able to understand that. So

yeah we can save this and then we can

leave shall be fine. And here you can

see that how we have the my first

workflow when it was last updated when

it was created and it has a tag as well.

So let me now click this and I'm inside

this. Now if you change if you do make

some changes so let's say shortcut link

now and click outside I can press

control S or command S in Mac to save

this and you can see that how it has

been saved then we have the history as

well right different different history

what all changes you have made when you

have saved them so yeah you can see that

how it is shortcut link here whereas

here it is just shortcut right so let me

close this will be helpful for uh

maintaining and having an idea about

complex uh workflows but yes all these

things is required to be understood in

the starting now you can click here and

you can duplicate this pretty

straightforward to understand you can

download the same as a JSON right so

JSON uh is something which I will

explain you but this is the way I will

be sharing my workflows which I create

throughout this course with you all so

that you can use them at your end

so much like we have a excel file if I

go here and download it. You can see

that okay my was work first workflow.json

workflow.json

user my downloads we can save it we can

save as open or cancel it. Once you have

this then surely you can import from

file as well right and I think yeah

these uh this is the more than thing

which you need to know about it and that

is how I will be sharing my uh workflows

with you right everything which I do in

this course so with this everyone I'm

pretty sure that each and everything is

clear just one last thing we can have

this AI assistant here so ask assistant

which is in beta as you can see here so

I can just ask it any basic question now

let me just uh have it maybe zoom it in.

Okay, know that will not be clear. let

me say hi and it will just help you to

like with the power of AI much like chat

GPT it will be just uh searching through

the docs and telling you the answer to

your queries right so hi mang how can I

help you with any today how uh let's say

how to create a first node now I will

tell you what node is no worries but it

will just tell you that okay what

exactly going from the docs it will be

helping you in the same okay and of

course the nit community etc as well.

Let's see what it gives as an answer.

So yeah, it's pretty taking time. Okay.

To create your first node in you can

follow the steps in an empty workflow.

Click on the add first step. This will

open the node panel. Search or browse

through the available node. If you want

your workflow to start automatically

choose a trigger node. So I think it's

becoming a little complex. Let me make

it a lot more easy for you. Let me close

this. And this plus button is where you

can click. So let me click plus.

Now again there are many many things uh

we don't have to get uh any uh any

problematic or uh like daunted by this.

Let's just click this trigger manually.

And don't worry uh let's just have this

thing now and again I can move this node

as well. I will be telling you different

different kind of node but first let us

create a very basic automation right now

uh to show you this automation what I

will be doing everyone I will be using

examples from Gmail Google sheets etc.

The reason is pretty simple this is

something which all of us use in our

day-to-day uh like day-to-day activities

etc. So we have access to that right

that's the very first thing. Second uh

you will be able to really make real

life use cases once you understand them

in depth. So very first thing which I'm

going to do I'm going to add an

automation. I'm going to do Gmail.

Select this Gmail and here I will just

be doing send a message. So this is what

I have selected. Now it has opened this

screen and don't worry I will be

explaining you everything right how it

flows and all. As you can see, if I go

back to the canvas, this has connected.

So I have two nodes. They are known as

nodes, right? This is the trigger or

input node. Okay? So if you remember, if

I just show you again, this is kind of a

input or trigger, right? So triggered

event I have written because in NAN they

are known as trigger. We are creating

workflows, right? So the flow is there

from left to right. One step then next

step then next step. This is how we are

creating them. And you can see the same

as well. First we will have a trigger

because it should start right just like

how in the morning when we wake up it's

a trigger for our body that hey let's

get started. So it's a flow from left to

right. And one of the very good thing

which I like about edit and design. If

you click on this here as well you will

see that how everything is from left to

right. It is having an input which is

from the left. So we can execute the

previous node and then we can have an

output. Okay. So pretty pretty simple

thing. Don't worry on anything here.

Right now I can select a credential. So

let me do create new credential. And

here it is again. So to make sure that

my init this particular canvas it can

use my Google mail that is Gmail it need

to get validated. Now the same is very

similar to how you just enter a password

on your phone to enter it and use that.

Right here we have different different

ways of authenticating. So we can have a

service account or we can have a ooth 2.

This OOTH 2 is the easiest and the

recommended way. Here you just have to

click on sign in with Google. Something

which we have done on many many websites

right. So let me do that. Sign in with Google.

Google.

And as you can see since I said that I

will be doing everything with you. I am

here and yeah this is how I'm going to

Let me select this.

So I want to allow everything. Now there

will be multiple things which it will

ask. For the time being you can allow

each and everything. Just please make

sure that you remember when you are

learning this. Either you can create a

new account or you can use just some

throwaway account. Like it's not a

problem as such. But I don't want that

you uh mess up your very first your

major or primary email account. So with

respect to the same everyone I will just

be giving it all the excesses and I will

just continue. Okay. So you will see a

little bit different here because I have

given this excesses. Let me do continue.

Okay. Let it run. And how you can see

the connection is successful. So it is

going to be similar this easy only for

you. Let me close this. You can see that

how the account has been connected. Now

if I go on Google and let's say if I go

on Gmail

okay let it run

you can see that how I have just kind of

created it is having a very uh like let

me delete everything. So this is just

kind of a email which I have created for

everything AI and specifically all the

tutorials which I will create but for

the time being this is not my primary

email. You can see that how the same is

empty. Okay. highly suggested to do the

same so that you don't face any issues

in your primary email address. Now let

me go and let us go to enm the very

first workflow. Here the same has been

connected. I can just close this. So it

now has access to my email id. I can see

that okay you have to send an email maygmail.com.

maygmail.com.

Again just using the same email id it

will be from me to me. Okay. Then

subject can be hi from my first workflow

workflow

and it can be a simple text not an HTML

and I let me make it simple. Hey hi from

any time.

Now we can have multiple options as

well. Again not the overall I will be

showing that in the next section. So for

the time being I can just execute this step

step

and you see that how we have the input

and the output has been kind of uh

populated. Now the good thing if I go

and refresh it now

I have this email coming to me. So this

is your very first automation which you

have created. If I go back like the best

way of running this this was more of a

text way of just a test way of just

executing this step. If I close this and

if you remember this was a manual taker.

So you see this uh one second. Yeah, we

see this lightning kind of a sign. Let

me show you this. Yeah, for the trigger,

right? So if I execute this workflow,

let me execute this workflow from here.

It will be flowing from left to right in

this uh arrows. Let me execute. And you

will see that how it is showing workflow

executed successfully. What does that

mean? I will be getting another email

right. So yes it is genuinely working

and we can see that hi hey hi from any

and now the reason that it is a

automation and not anything AI or agent

is that this is not having any AI use

case as of now right so yeah with that I

am pretty sure that till now from

complete scratch you have understood a

lots of things and let me go back and

how we have understood the signup

process like no money No credit card

required. UI walk through. I have made

sure to explain you each and everything,

each and every button because that is

very very important. In it and workflow,

the overall canvas which is known as

workflow, how we can rename it etc. And

we have created the first automation.

Okay. So just one one small quick thing

uh you can just click on this space and

you can rename this. So let's say my

manual trigger and you can just click on

this and let's say send a test email.

So yeah, you will see that how this is

kind of getting uh renamed based on this

use case. Okay, of course you can see

the same in startup uh like in the

shortcut as well but I thought to

explain you. So with this everyone now

we have kind of have the very basic and

the pretty base clear. Now I guess we

can start painting. So we understood

about the canvas. We understood about

the different different colors etc. we

have what are the settings etc.

Everything cleared we in Microsoft

terminology we understood that how we

can enter something here. Now as we will

move forward we will see and learn in

depth about all these as well. So these

four very important foundation steps are

done for any right now. In the next

module we will be focusing on nodes in

nit. So the nodes which I showed you

which we have first created. Now we will

be going a lot in depth about these so

that each and everything is a lot clear

to you. So now let us start with the

next module everyone. I think it should

be module three. I have missed that out.

Yeah. So in this we will now be taking

things up a notch and we will be

focusing on nodes right and along with

that creating automations with that. So

first let us see a little bit about

nodes. What exactly are nodes? So node

is a single building block in nitin

workflow. So as we have seen here that

how we can have or we can create a new

node by clicking on this thing which

triggers this panel on the right where

we can have the node selected. So let me

now go back and we can go back here.

each performing a specific job like

triggering an event or processing data

or some action as well. So majorly you

will see that how we have nodes like

these where we have a trigger like this

should ideally be a lightning bolt then

we can have an action AI agent code or

utility. So this will not make it a lot

more clear. Now for that what I have

done is I have went an extra mile and

made sure that I have created a

workflow. So let me open that. Yeah. So

I've created a workflow everyone which

you can see right in front of your

screen where I have tried to group all

the notes so that it is very easy for

you all to understand. Now let me just

try to do one thing.

Let me also showcase that how you can uh

download and import this file because

that is what you will be doing to get

all the workflows which I shared with

you. So you can go here and in this we

can click download. So once you click

this download it is saving this JSON

file. So let me do a quick save and you

see that how the same has been

downloaded right. So it's a small file

in terms of overall configuration etc.

Now to open the same now this is a

separate window. I have a separate edit

and instance open here with some saved

workflows. But when you will be opening

a new overall workflow something like

this. What you can now do is you can

just import from file right and I can

just select this decent one which I have

downloaded and you see that how the full

workflow which I have created you are

able to easily or rather you would be

easily able to download. Now let's see

the nodes in a little depth given

because they are the building blocks

just like we have logos in real life. So

they will be the one which runs in

sequence and finally help us in our

automation or our agentic flows. So

let's see them one by one. When you

press tab or when you click this plus button

button

that is where we see all these different

different uh categories. So AI action in

an app data transformation flow core

like let me zoom it in to make it a

little bit easier to read. So as you can

see AI action in an app data

transformation flow core human in the

loop and how we can have another

trigger. So these are all or some of

them are what I have extracted out and I

have showcased here. So if you see this

trigger node everyone as the name

suggests trigger node are going to be

the one which triggers your whole

workflow. Now the workflow is going to

be from left to right and it's majorly

being a lot logical in nature the way we

define our automation or let's say an

agentic flow. So here we can have

different different kinds of trigger

right in the last sample automation

which we created we were having a manual

trigger which can get triggered manually

that is when we want the same to get

triggered where we used to press this

execute workflow. Now of course there is

nothing here so nothing will happen but

we can have trigger which is based on

different different uh conditions on

different kinds of trigger as you can

see few of them which I have tried to

include here uh are form trigger so what

n provides you is so let me just zoom it

out a little bit and show you so we can

have a form trigger here everyone now if

I double click on this and let's say if

I open this or copy this path now we

will be seeing this separately as well.

And if I click this on a new tab, then

we can have a form uh basically created,

right? So let's say I go back and I just

have a form title. Let's say test form

and I can have some uh elements, right?

So let's say first name and we can have

element type as text. Yeah, all that is

seems fine. Now if I go back and refresh

it. Okay, I think I will have to save

the same as well. So pay attention

everyone. I'm doing a command S or

control S and like we get a on the top

bottom right we get workflow changes

saved. Now if I refresh it. Okay let me

just copy the link again maybe because I

think uh this has to be just quickly

worked upon. Enter the name. We can have

this copied. Let me paste it.

Exit form trigger isn't listening. Uh

that seems fine. So

just let me quickly check

what are we missing here.

This production URL is not the one required.

required.

Okay, this is having some problem. Maybe

I can execute this so that it is

listening. Now if I refresh it. Yeah. So

maybe I think I have to re uh just start

this form. This is a test version of

your form. Test form. And it is having

the first name right and I can submit

the same. Now we will see be seeing this

in a lot of depth but you can just

easily think that how this is just your

how Google form is right so we can also

create a form which is uh edit and

native and let's say as soon as you

enter your name or any other details

which you want this is uh this can

trigger your workflow. So this is just

one of the example I'm going to stop

listening for the time being let's go

back to the canvas. Similarly, we can

have multiple different kinds of

trigger. We can have a trigger based on

Telegram, which is a messaging

application just like WhatsApp. We can

have a schedule trigger. Now, as the

name suggest, this trigger is going to

run on a schedule. So, if I just double

click and just show you, we can have the

intervals, seconds, hours, all these

things. We can even have the custom

chrome based uh trigger as well. So,

yeah, that is something which we can use

in a similar manner. Everyone, we can

have a web hook trigger. something which

we are going to see as well. We can have

a Gmail trigger as well, right? So let's

say when the mail comes onto your inbox,

then your full workflow can uh trigger.

So in that way you can actually automate

your full workflow. So all these uh

examples I'm showing you so that you are

having a deeper understanding of what exactly a trigger is and how it can

exactly a trigger is and how it can defect on some real it can depend on

defect on some real it can depend on some real world applications as well

some real world applications as well much like how we can receive a message

much like how we can receive a message or we can receive a email in a similar

or we can receive a email in a similar manner in a very similar manner we can

manner in a very similar manner we can have a chat uh trigger as well. So if I

have a chat uh trigger as well. So if I just double click this uh close this.

just double click this uh close this. Yeah. So we can have this chat everyone.

Yeah. So we can have this chat everyone. Now this is by default present in uh

Now this is by default present in uh nitin where I can message let's say

nitin where I can message let's say something and your whole flow is going

something and your whole flow is going to get run much like how we can have it

to get run much like how we can have it in a chatbot. So we can test out the

in a chatbot. So we can test out the same as well. Now let me just uh

same as well. Now let me just uh distract it. Yeah. In a similar way we

distract it. Yeah. In a similar way we can have a workflow trigger. So this can

can have a workflow trigger. So this can actually trigger a separate workflow.

actually trigger a separate workflow. Right. So you are having this workflow

Right. So you are having this workflow created here. We can have a separate

created here. We can have a separate workflow which can get triggered right

workflow which can get triggered right now air table trigger as well. So air

now air table trigger as well. So air table is another application. The whole

table is another application. The whole idea which I wanted to show you here is

idea which I wanted to show you here is that how we can have different different

that how we can have different different trigger based on real world

trigger based on real world applications. So now if I go on add

applications. So now if I go on add another trigger you can see all the

another trigger you can see all the categories here right. So we can have

categories here right. So we can have trigger manually on app event on a

trigger manually on app event on a schedule on a web hook call. So all

schedule on a web hook call. So all these things we are going to see on form

these things we are going to see on form submission when executed by another

submission when executed by another workflow. So these are the one everyone

workflow. So these are the one everyone which we can use as trigger or the

which we can use as trigger or the starting point of our workflow. Right

starting point of our workflow. Right after that next we have the action node

after that next we have the action node something which is going to as the name

something which is going to as the name suggest perform some action. Now the

suggest perform some action. Now the good thing with nitn is the integrations

good thing with nitn is the integrations which makes it a lot more possible and

which makes it a lot more possible and easy to connect it to real world

easy to connect it to real world applications and do some action. In the

applications and do some action. In the previous uh automation which we did, we

previous uh automation which we did, we were having send a message as an action

were having send a message as an action right so I think it's pretty simple just

right so I think it's pretty simple just like how we uh humans have a trigger

like how we uh humans have a trigger point let's say we wake up then we brush

point let's say we wake up then we brush our teeth that is an action in a similar

our teeth that is an action in a similar manner in a digital world actions can be

manner in a digital world actions can be anything uh be it sending a email on

anything uh be it sending a email on Gmail now if you have notion if you are

Gmail now if you have notion if you are aware about notion which is an

aware about notion which is an application which is an awesome

application which is an awesome note-based application

note-based application we can have some uh thing to be done on

we can have some uh thing to be done on notion and then we can have Google

notion and then we can have Google sheets as well. So we can easily connect

sheets as well. So we can easily connect to a Google sheet and perform some

to a Google sheet and perform some action on that right. So it can be

action on that right. So it can be deleting a record, appending a record or

deleting a record, appending a record or maybe we pick up a record and then do

maybe we pick up a record and then do something on that. So this is where the

something on that. So this is where the action comes into picture everyone. Now

action comes into picture everyone. Now here as well we can have multiple

here as well we can have multiple different different uh let's say apps.

different different uh let's say apps. We can see that how it is action in an

We can see that how it is action in an app where we can do something in a app

app where we can do something in a app or service like Google sheets, telegram

or service like Google sheets, telegram or notion. So I have just picked up the

or notion. So I have just picked up the most common one. But the idea is pretty

most common one. But the idea is pretty simple and the good and the best part is

simple and the good and the best part is that how we have so many of these

that how we have so many of these applications like from basic

applications like from basic applications which we use to AWS right

applications which we use to AWS right so the good part you can easily connect

so the good part you can easily connect to them connect to it right you don't

to them connect to it right you don't need to write any code which makes nin

need to write any code which makes nin and creating these automations a lot

and creating these automations a lot easy for anyone right so just simple

easy for anyone right so just simple drag and drop here we can see AWS S3

drag and drop here we can see AWS S3 Azure storage so AWS is there Azour is

Azure storage so AWS is there Azour is here brave search then cal.com kalendly

here brave search then cal.com kalendly now all this just kind of shows that how

now all this just kind of shows that how you can genuinely create a proper end to

you can genuinely create a proper end to end application with all these

end application with all these applications present right out of the

applications present right out of the box and if you scroll down you will see

box and if you scroll down you will see many of these uh which we use so we have

many of these uh which we use so we have Dropbox we have elastic search 11 labs

Dropbox we have elastic search 11 labs then uh of course we have git github

then uh of course we have git github gitlab google related google cloud

gitlab google related google cloud related services right so the

related services right so the integrations ations are genuinely the

integrations ations are genuinely the best thing here. Google Docs, Google

best thing here. Google Docs, Google Drive, Google Sheets, all these

Drive, Google Sheets, all these integrations are pretty nicely present

integrations are pretty nicely present and just ready to use. So we can have

and just ready to use. So we can have even Jiraa etc. as well. We can have

even Jiraa etc. as well. We can have Kafka, Jira software. So all these I'm

Kafka, Jira software. So all these I'm showing you so that you understand that

showing you so that you understand that how uh Nitin can be used to create

how uh Nitin can be used to create workflows which are not just helpful to

workflows which are not just helpful to us in our personal uh let's say

us in our personal uh let's say day-to-day life. uh for example with

day-to-day life. uh for example with Google Sheets, Gmail but rather it is

Google Sheets, Gmail but rather it is having all the professional applications

having all the professional applications as as well in terms of cloud services

as as well in terms of cloud services like uh AWS, Google Cloud and Azure as

like uh AWS, Google Cloud and Azure as well as Jira, GitHub all these things,

well as Jira, GitHub all these things, right? So possibilities are genuinely

right? So possibilities are genuinely endless here. Now we have multiple other

endless here. Now we have multiple other overall things as well. We have LinkedIn

overall things as well. We have LinkedIn as you can see and Microsoft Azure,

as you can see and Microsoft Azure, Microsoft SQL, Microsoft To-Do all these

Microsoft SQL, Microsoft To-Do all these things are present here starting from

things are present here starting from the very basic of the application. So

the very basic of the application. So yeah the integrations are genuinely kind

yeah the integrations are genuinely kind of endless. We can see that how many

of endless. We can see that how many integration is there to the end and

integration is there to the end and YouTube is also present. So all the

YouTube is also present. So all the facets of life from personal to

facets of life from personal to professional are very nicely covered and

professional are very nicely covered and we can surely use that. So this is where

we can surely use that. So this is where the action note comes into picture

the action note comes into picture everyone. So we can perform an action.

everyone. So we can perform an action. Now after that if you see we have the

Now after that if you see we have the data transformation or majorly the

data transformation or majorly the utility node. Let me show you that as

utility node. Let me show you that as well. So as the name suggest here we

well. So as the name suggest here we will be working on let's say any data

will be working on let's say any data which we are getting. We can of course

which we are getting. We can of course filter the data out. We can work on the

filter the data out. We can work on the same. So you will be seeing that how

same. So you will be seeing that how these automation sorry these nodes they

these automation sorry these nodes they are also like the steps in our

are also like the steps in our automation or in our work right we first

automation or in our work right we first trigger something then uh we let's say

trigger something then uh we let's say connect to an application right or we

connect to an application right or we open an application and then maybe for

open an application and then maybe for example we can uh filter out our emails

example we can uh filter out our emails okay based on who have sent them right

okay based on who have sent them right in a similar way we can have some if

in a similar way we can have some if condition that okay I have to first

condition that okay I have to first reply to my work emails so maybe let's

reply to my work emails so maybe let's say if I'm connecting into Google or

say if I'm connecting into Google or Gmail. I'm getting all my emails and I'm

Gmail. I'm getting all my emails and I'm first connecting to the work emails. So

first connecting to the work emails. So that is the idea. Here we can again have

that is the idea. Here we can again have date and types which uh set fields. We

date and types which uh set fields. We can have different different things

can have different different things which I will be showing you in action.

which I will be showing you in action. And then yeah pretty sure it will make a

And then yeah pretty sure it will make a lot more sense. Just to show you again

lot more sense. Just to show you again we can have uh different different types

we can have uh different different types of these transformation node as well. uh

of these transformation node as well. uh we can have these filter limit uh remove

we can have these filter limit uh remove duplicate split out right aggregate

duplicate split out right aggregate merge and then compression crypto

merge and then compression crypto extract from file all these are present

extract from file all these are present we can rename keys etc as well so yeah

we can rename keys etc as well so yeah these are the one which are present

these are the one which are present after that we have the code nodes

after that we have the code nodes everyone so if I show you here then we

everyone so if I show you here then we have the core one here where running

have the core one here where running code HTTP request or web hook comes into

code HTTP request or web hook comes into picture and we can have execute sub

picture and we can have execute sub workflow So FTP any NAN related form or

workflow So FTP any NAN related form or uh let's say operation and we can have a

uh let's say operation and we can have a no operation do nothing kind of a thing

no operation do nothing kind of a thing as well. So just to explain you a little

as well. So just to explain you a little bit more here NA10 also support your

bit more here NA10 also support your custom code. So you can pro uh just

custom code. So you can pro uh just provide the code. Let's say if I just

provide the code. Let's say if I just double click this here if you see we can

double click this here if you see we can provide the code in uh let's say

provide the code in uh let's say JavaScript and Python is also supported.

JavaScript and Python is also supported. Let me just check that where exactly it

Let me just check that where exactly it is. Ask AI. So you can generally just

is. Ask AI. So you can generally just directly use AI. Now that doesn't m

directly use AI. Now that doesn't m doesn't mean that it is uh now a code

doesn't mean that it is uh now a code tutorial. Well for basic operation you

tutorial. Well for basic operation you can generally just write uh your simple

can generally just write uh your simple thing in English and the code it is

thing in English and the code it is going to generate for you. Right? So

going to generate for you. Right? So these are very nicely present everyone.

these are very nicely present everyone. Now let's go back. We can go on settings

Now let's go back. We can go on settings I guess and yeah like these are the few

I guess and yeah like these are the few things which we will see a little bit

things which we will see a little bit more in depth. So JavaScript is

more in depth. So JavaScript is basically supported. I think Python is

basically supported. I think Python is still in beta. I was able to check uh

still in beta. I was able to check uh that Python was also present. Maybe I

that Python was also present. Maybe I will show you that in the practical as

will show you that in the practical as well. Let me close them for the time

well. Let me close them for the time being. Next, we have the overall okay it

being. Next, we have the overall okay it is not action node. My bad. These are

is not action node. My bad. These are your basically AI nodes, right? So, let

your basically AI nodes, right? So, let me show you these as well everyone. Here

me show you these as well everyone. Here we have AI agents. Something which I

we have AI agents. Something which I know that all of you will be looking

know that all of you will be looking forward to and we will gradually be

forward to and we will gradually be using this once we master automation.

using this once we master automation. Then some basic LLM chain how we can

Then some basic LLM chain how we can connect to your open AI or let's say any

connect to your open AI or let's say any other LLM as well. Question answer chain

other LLM as well. Question answer chain text classifier sentiment analysis. So

text classifier sentiment analysis. So few of the very common use cases they

few of the very common use cases they are directly present and provided as a

are directly present and provided as a block. Now if I show here uh show you

block. Now if I show here uh show you here as well uh let's say once I click

here as well uh let's say once I click this tab then in the AI we can have some

this tab then in the AI we can have some templates. So these are again some

templates. So these are again some templates which we can extract from here

templates which we can extract from here which I showed you earlier. Along with

which I showed you earlier. Along with that we can have a AI agent. We can have

that we can have a AI agent. We can have a direct open AI as well. Right? So we

a direct open AI as well. Right? So we can just connect to chat GPT via our key

can just connect to chat GPT via our key and let's say we can message it. We can

and let's say we can message it. We can uh message an assistant, we can delete

uh message an assistant, we can delete or create an assistant all these things.

or create an assistant all these things. Then we have the basic LLM chain and few

Then we have the basic LLM chain and few of the use cases out of the box. So we

of the use cases out of the box. So we have the information extractor,

have the information extractor, question and answer chain, sentiment

question and answer chain, sentiment analysis, summarization chain, text

analysis, summarization chain, text classifier. All these things are present

classifier. All these things are present which we can use out of the box. And of

which we can use out of the box. And of course we have other AI nodes as well.

course we have other AI nodes as well. So now they have been very nicely

So now they have been very nicely divided everyone which I believe will

divided everyone which I believe will make a lot of sense provided you have

make a lot of sense provided you have in-depth knowledge about AI. Good thing

in-depth knowledge about AI. Good thing again uh no coding is required just by

again uh no coding is required just by dragging and dropping you can use these

dragging and dropping you can use these things. So starting from complex things

things. So starting from complex things like document loaders, language models,

like document loaders, language models, memory, output parsers, retriever, all

memory, output parsers, retriever, all these things are present for us to use,

these things are present for us to use, right? Embeddings, vector stores. So

right? Embeddings, vector stores. So yeah, that is going to be a lot more

yeah, that is going to be a lot more powerful and this is why I believe that

powerful and this is why I believe that nit as a tool is something which

nit as a tool is something which everyone can use and it covers wide

everyone can use and it covers wide array of use cases. So all these

array of use cases. So all these basically are the nodes everyone. Now

basically are the nodes everyone. Now again we can have this flow as well

again we can have this flow as well where like there will be some overlap as

where like there will be some overlap as you can see here. So I think we have

you can see here. So I think we have covered majorly all these offerings AI

covered majorly all these offerings AI action in an app data transformation

action in an app data transformation flow core human in the loop as the name

flow core human in the loop as the name suggests. So this is a concept in which

suggests. So this is a concept in which we can have a human input inside any

we can have a human input inside any automation or any loop uh which with AI

automation or any loop uh which with AI which is running. So yeah we can have

which is running. So yeah we can have that as well. For example, we can have

that as well. For example, we can have Slack. We can send something and let's

Slack. We can send something and let's say wait for the slack approval or the

say wait for the slack approval or the Gmail approval. So this is what human in

Gmail approval. So this is what human in the loop means and we can have multiple

the loop means and we can have multiple triggers as well. So add another trigger

triggers as well. So add another trigger is something uh which is coming here. So

is something uh which is coming here. So with that everyone pretty pretty sure

with that everyone pretty pretty sure that you are clear on what nodes are. So

that you are clear on what nodes are. So these are the building blocks which we

these are the building blocks which we will be connecting to one another to

will be connecting to one another to make our automations or AI agents flow.

make our automations or AI agents flow. Right? So they are very very important

Right? So they are very very important to understand and of course there are so

to understand and of course there are so many of these uh nodes which you can use

many of these uh nodes which you can use in your application and the idea is

in your application and the idea is going to be pretty simple. We have to

going to be pretty simple. We have to keep our overall flow or overall nit

keep our overall flow or overall nit workflow a lot easy to understand by

workflow a lot easy to understand by making sure that we can use the nodes

making sure that we can use the nodes which are required. Now one thing to

which are required. Now one thing to mention here we have this HTTP request

mention here we have this HTTP request one as well which makes it possible to

one as well which makes it possible to connect to our own apps as well right so

connect to our own apps as well right so you must be aware that how we do use

you must be aware that how we do use HTTP request and if you are not aware

HTTP request and if you are not aware let's say if you are in college or even

let's say if you are in college or even in school don't worry I will be covering

in school don't worry I will be covering that as well from complete scratch but

that as well from complete scratch but the idea which I wanted to clear here

the idea which I wanted to clear here for maybe a little professional audience

for maybe a little professional audience is that how your personal applications

is that how your personal applications right with the help of HTTP request can

right with the help of HTTP request can be integrated inside an N10 workflow.

be integrated inside an N10 workflow. This is something which I am also using

This is something which I am also using in my overall uh use case for my startup

in my overall uh use case for my startup as well as for consulting which I do.

as well as for consulting which I do. This is where we uh have the client

This is where we uh have the client application uh basically triggered or

application uh basically triggered or plugged in into our workflow. Okay. So

plugged in into our workflow. Okay. So with that I'm pretty sure that this

with that I'm pretty sure that this thing is clear. Now let us go back and

thing is clear. Now let us go back and pretty sure that now the nodes and

pretty sure that now the nodes and everything is clear. Now with the

everything is clear. Now with the understanding and everything intact we

understanding and everything intact we will be creating some practical

will be creating some practical automations which are going to make our

automations which are going to make our concept a lot clearer and via that only

concept a lot clearer and via that only I will show you the overall internal

I will show you the overall internal working of our nodes. how we can

working of our nodes. how we can configure information, how we can set

configure information, how we can set them dynamically, how we can have

them dynamically, how we can have different different options which we can

different different options which we can uh set or configure. Okay. So now let's

uh set or configure. Okay. So now let's start with the practical of our

start with the practical of our automation everyone and so I've

automation everyone and so I've collected this module number as well to

collected this module number as well to avoid any future uh basically confusion.

avoid any future uh basically confusion. Now why are these automation practical?

Now why are these automation practical? We will be integrating our real world

We will be integrating our real world applications and you will be getting a

applications and you will be getting a lots of idea that how can we work on

lots of idea that how can we work on these and yeah unlocking the true power

these and yeah unlocking the true power of our NAT. So in this next module now

of our NAT. So in this next module now we will be starting with the automation

we will be starting with the automation practicals.

So now let us move forward and master automation everyone. Now I will be

automation everyone. Now I will be making sure again that everything is

making sure again that everything is covered where you are able to understand

covered where you are able to understand each and every building block the input

each and every building block the input the output overall flow as the same

the output overall flow as the same shall be very much helpful in building

shall be very much helpful in building these automation from scratch just like

these automation from scratch just like we will do and once you do that then you

we will do and once you do that then you will be even able to use the pre-built

will be even able to use the pre-built templates or let's say automation which

templates or let's say automation which anyone else provide and tailor it based

anyone else provide and tailor it based on your use case. Now I have seen many

on your use case. Now I have seen many tutorials and the same is not covered in

tutorials and the same is not covered in this much depth. So I made sure that it

this much depth. So I made sure that it is very much comprehensive in nature and

is very much comprehensive in nature and uh I will also be in future making sure

uh I will also be in future making sure that I do many projects where we will be

that I do many projects where we will be building the same from scratch. So this

building the same from scratch. So this understanding is going to be a lot

understanding is going to be a lot helpful. So it might seem a little bit

helpful. So it might seem a little bit uh easier in the starting but it is

uh easier in the starting but it is going to quickly uh pace up to a little

going to quickly uh pace up to a little complex use case. So I want that each

complex use case. So I want that each and every one of you now are focusing

and every one of you now are focusing and creating notes and understanding

and creating notes and understanding where uh exactly uh we are making the

where uh exactly uh we are making the changes. If you face any error or any

changes. If you face any error or any issues, please make sure that you

issues, please make sure that you mention the time stamp and ask your

mention the time stamp and ask your doubts and I will be more than happy to

doubts and I will be more than happy to clear the same because now we are

clear the same because now we are genuinely going inside and building

genuinely going inside and building inside our canvas. So with that now

inside our canvas. So with that now let's see the very first uh automation

let's see the very first uh automation everyone. The very first automation is

everyone. The very first automation is going to be a simple form automation

going to be a simple form automation which uh we in which we will be

which uh we in which we will be understanding that how the things are

understanding that how the things are working. We will be having a form which

working. We will be having a form which we will uh basically be fil uh filling

we will uh basically be fil uh filling or which we can provide to someone. Once

or which we can provide to someone. Once the same is filled then we will be

the same is filled then we will be appending the result uh sorry appending

appending the result uh sorry appending the inputs into our sheet right into the

the inputs into our sheet right into the Google sheet which we create and then we

Google sheet which we create and then we will be sending the mail on top of that.

will be sending the mail on top of that. So this first two kind of a thing are

So this first two kind of a thing are possible in Google sheet as well uh

possible in Google sheet as well uh sorry Google form as well but we are

sorry Google form as well but we are adding an extra step to just have a mail

adding an extra step to just have a mail sent uh as well right so the same is

sent uh as well right so the same is going to be of course uh very much

going to be of course uh very much helpful everyone uh 1 minute yeah so

helpful everyone uh 1 minute yeah so let's now move forward with that and

let's now move forward with that and what we have to do let's go to our

what we have to do let's go to our canvas let's go to the empty canvas now

canvas let's go to the empty canvas now a couple of things here uh let's save

a couple of things here uh let's save this overall all nodes workflow as I

this overall all nodes workflow as I believe the same shall be helpful to you

believe the same shall be helpful to you as well. Let's go to our home here and

as well. Let's go to our home here and what you can see is that here we have

what you can see is that here we have the project everyone. So we have this

the project everyone. So we have this project right now what I can do is I can

project right now what I can do is I can easily just uh take my this particular

easily just uh take my this particular uh let's say if I go on personal so I

uh let's say if I go on personal so I can take my this workflow and this is

can take my this workflow and this is just dragable form personal right and

just dragable form personal right and have it inside this project. So highly

have it inside this project. So highly suggested like you always make sure that

suggested like you always make sure that you are having these divided. What you

you are having these divided. What you can also do if you're interested you can

can also do if you're interested you can see this particular create folder uh

see this particular create folder uh button here. As the name suggests you

button here. As the name suggests you can create a folder. So let's say basics

can create a folder. So let's say basics or I would say n foundation

and you can have something present here. So let's say I can move it here as well.

So let's say I can move it here as well. Now inside this learn NA10 is the

Now inside this learn NA10 is the project or sorry I think this is the tab

project or sorry I think this is the tab and inside my project as well I can see

and inside my project as well I can see that how how I am having my workflow

that how how I am having my workflow right so I can have the overview in

right so I can have the overview in there we have I think this as well which

there we have I think this as well which I need to rename yeah so let us rename

I need to rename yeah so let us rename this shall be very helpful notes and we

this shall be very helpful notes and we can have here uh so these are tags tags

can have here uh so these are tags tags are different from your projects and

are different from your projects and folder is just to uh basically organize

folder is just to uh basically organize all your workflows right so let me do

all your workflows right so let me do ated

ated uh nodes. So this shall be helpful as

uh nodes. So this shall be helpful as well everyone. Now let's go back and in

well everyone. Now let's go back and in the overview now you can see that how

the overview now you can see that how this nodes it is inside learn project.

this nodes it is inside learn project. This is uh basically personal and it's

This is uh basically personal and it's inside the folder. If I click this it is

inside the folder. If I click this it is going to take me inside the folder.

going to take me inside the folder. Since in future you hopefully and

Since in future you hopefully and learning with me will be spending a lots

learning with me will be spending a lots of time creating lots of automation I

of time creating lots of automation I want to make sure that you know how to

want to make sure that you know how to organize them as well so it don't become

organize them as well so it don't become a mess and I believe the same these

a mess and I believe the same these small things are also very very

small things are also very very important now what I will be doing

important now what I will be doing everyone let's go back to learn it 10

everyone let's go back to learn it 10 inside this let's now create this

inside this let's now create this workflow now as you can see we have

workflow now as you can see we have created the workflow let me remove this

created the workflow let me remove this and let's automation one right I will be

and let's automation one right I will be doing everything with the best practices

doing everything with the best practices so the very first thing which uh I will

so the very first thing which uh I will be creating is a note here as you can

be creating is a note here as you can see this is a button uh shift s is the

see this is a button uh shift s is the shortcut now the reason for this is as

shortcut now the reason for this is as uh you create workflows right much like

uh you create workflows right much like your code and for anyone who doesn't

your code and for anyone who doesn't know code that should also be fine it's

know code that should also be fine it's normally very helpful

normally very helpful if you are during the creation only and

if you are during the creation only and rather at every step you are documenting

rather at every step you are documenting or writing what your workflow is doing.

or writing what your workflow is doing. So yeah following the best practices is

So yeah following the best practices is very important because even if it's a no

very important because even if it's a no code tool in future when there will will

code tool in future when there will will be so many of these automations you

be so many of these automations you surely will uh not remember the small

surely will uh not remember the small smallest of the details right so for the

smallest of the details right so for the same I will be adding a note and this is

same I will be adding a note and this is going to be the starting point everyone

going to be the starting point everyone now as you can see I can go inside let

now as you can see I can go inside let me make it a little bit bigger and edit

me make it a little bit bigger and edit this note right so I can say something

this note right so I can say something like automation one and then I can have

like automation one and then I can have uh Let's say first automation

uh Let's say first automation automation to understand

automation to understand the um working of

the um working of nodes and inside

nodes and inside settings or configuration

settings or configuration and I can just uh have this outside. Now

and I can just uh have this outside. Now you will see that how this is a lot

you will see that how this is a lot having a heading kind of a thing right.

having a heading kind of a thing right. So how this is bigger in size and this

So how this is bigger in size and this is smaller. Now I already shown you that

is smaller. Now I already shown you that how we have this uh we can just

how we have this uh we can just configure this or style it with

configure this or style it with markdown. So the good thing for you I

markdown. So the good thing for you I have found a website. So this is one

have found a website. So this is one website which we have found uh

website which we have found uh mdxeditor.dev.

mdxeditor.dev. Here what you can do you can just uh

Here what you can do you can just uh type in your things as you want. So I

type in your things as you want. So I can just have let's say automation one.

can just have let's say automation one. Let me rather select uh automation

Let me rather select uh automation one. Now I can have it heading right. So

one. Now I can have it heading right. So you can see that how it is visible. Then

you can see that how it is visible. Then uh your rich text right. So majorly many

uh your rich text right. So majorly many of you will be having a habit of writing

of you will be having a habit of writing things down in word document etc. Right?

things down in word document etc. Right? So what you can do is you can just write

So what you can do is you can just write it the way you will. Okay. And from rich

it the way you will. Okay. And from rich text you can just select this particular

text you can just select this particular markdown option. Right? So once you

markdown option. Right? So once you select this source mode you can just

select this source mode you can just copy this. Right? So this is what you

copy this. Right? So this is what you can copy and it will be formatted. Again

can copy and it will be formatted. Again if you have no idea about markdown this

if you have no idea about markdown this shall be very helpful because since it

shall be very helpful because since it supports markdown it will be very easy

supports markdown it will be very easy very helpful if we write markdown uh

very helpful if we write markdown uh formatted notes so that it will be

formatted notes so that it will be easier for anyone to follow through.

easier for anyone to follow through. Right with that let's now go back

Right with that let's now go back everyone and I'm pretty sure that you

everyone and I'm pretty sure that you can follow these things uh like create

can follow these things uh like create your notes and everything. Please do

your notes and everything. Please do that. I will also be doing it. Let's

that. I will also be doing it. Let's first have a trigger created because uh

first have a trigger created because uh if you remember input or trigger is

if you remember input or trigger is going to be the starting point of our

going to be the starting point of our workflow. So let me have this here. I

workflow. So let me have this here. I can have this very first one trigger

can have this very first one trigger manually as we see here. Run the flow on

manually as we see here. Run the flow on clicking a button. Good for getting

clicking a button. Good for getting started quickly. So let me click this

started quickly. So let me click this trigger manually. And we see a node

trigger manually. And we see a node here. Right. So I can just zoom it in in

here. Right. So I can just zoom it in in the basic level. Uh so I have pressed

the basic level. Uh so I have pressed one and it has uh just pushed me in the

one and it has uh just pushed me in the center right. I will zoom a little bit

center right. I will zoom a little bit out. Uh one thing more which will be

out. Uh one thing more which will be helpful. So something which I want to

helpful. So something which I want to show you is this mini map mini map.

show you is this mini map mini map. Everyone now pretty sure that all of you

Everyone now pretty sure that all of you must have must have played this game age

must have must have played this game age of empires 2 mini map.

of empires 2 mini map. So here as well we used to have this

So here as well we used to have this mini map kind of right. See we used to

mini map kind of right. See we used to have this mini map. Uh I cannot find a

have this mini map. Uh I cannot find a better relatable example. So this again

better relatable example. So this again is a similar thing. Now again it is

is a similar thing. Now again it is present in many games as well. So in a

present in many games as well. So in a similar manner we have this mini map.

similar manner we have this mini map. Anytime we scroll or we try to move and

Anytime we scroll or we try to move and via this we can understand that okay

via this we can understand that okay where exactly we are these this is the

where exactly we are these this is the node and this is your overall uh sticky

node and this is your overall uh sticky note. So this is the node which we have

note. So this is the node which we have created and this is the sticky node. So

created and this is the sticky node. So again uh this mini map is very helpful

again uh this mini map is very helpful in overall moving through your workflow.

in overall moving through your workflow. Right? Now since I have this particular

Right? Now since I have this particular uh trigger right I can easily trigger my

uh trigger right I can easily trigger my workflow. Let me press this click. Now

workflow. Let me press this click. Now you can see few options here. Let me

you can see few options here. Let me have this renamed manual trigger.

have this renamed manual trigger. Once we go on top of that, you can see

Once we go on top of that, you can see that how I can click this play button to

that how I can click this play button to execute this step. Then I can deactivate

execute this step. Then I can deactivate it as well. As the name suggests,

it as well. As the name suggests, deactivate so that it will not be run.

deactivate so that it will not be run. Then we have the delete here. And if I

Then we have the delete here. And if I click on this three dots, we have few

click on this three dots, we have few more things up. Tidy up workflow,

more things up. Tidy up workflow, convert node to subworkflow, select all,

convert node to subworkflow, select all, rename, deactivate. So again, you can

rename, deactivate. So again, you can see the shortcut in the right as well.

see the shortcut in the right as well. Right? So small small things so that you

Right? So small small things so that you are a pro in editing once you learn

are a pro in editing once you learn these things with me. Now what I will be

these things with me. Now what I will be doing everyone I will be clicking a plus

doing everyone I will be clicking a plus button and I will be having form here.

button and I will be having form here. So I will just search for form and I

So I will just search for form and I will use nitn form. You can see that how

will use nitn form. You can see that how form.io or form stack is also supported

form.io or form stack is also supported in terms of trigger but we will be using

in terms of trigger but we will be using the default init form. So let me have

the default init form. So let me have okay uh I think uh we have a form

okay uh I think uh we have a form trigger only which we have to import. So

trigger only which we have to import. So let me close this everyone. Let me

let me close this everyone. Let me delete this one. Right. So it's not

delete this one. Right. So it's not going to be a manual trigger. We have

going to be a manual trigger. We have the trigger which is attached to a form.

the trigger which is attached to a form. Right? So this is something which we are

Right? So this is something which we are using. Now if I go back and show you we

using. Now if I go back and show you we just have to do add another trigger. And

just have to do add another trigger. And here we have this on form submission.

here we have this on form submission. Okay. So just closing this. We have this

Okay. So just closing this. We have this on form submission trigger which is

on form submission trigger which is connected to my form. Now let me delete

connected to my form. Now let me delete one of them here.

one of them here. Now uh the other things are same exactly

Now uh the other things are same exactly the same and I can now doubleclick. So

the same and I can now doubleclick. So once you double click you get inside

once you double click you get inside your node right. So whatever node has

your node right. So whatever node has now the settings this is where you can

now the settings this is where you can uh edit them out. Now these are all the

uh edit them out. Now these are all the settings which you can work on everyone.

settings which you can work on everyone. So if you see here these are the

So if you see here these are the parameters or the settings. Now the best

parameters or the settings. Now the best part with uh nit is that how it is

part with uh nit is that how it is having a very good documentation. If I

having a very good documentation. If I press on this docs it will take me to

press on this docs it will take me to the form trigger node documentation. So

the form trigger node documentation. So for anyone who is having any doubts this

for anyone who is having any doubts this is from where you can read about it or

is from where you can read about it or normally you have that AI uh helper as

normally you have that AI uh helper as well. Right. So let me now close this.

well. Right. So let me now close this. Inside this uh you will see that how I'm

Inside this uh you will see that how I'm having a test URL. Okay. So I can just

having a test URL. Okay. So I can just copy this. And if I open it in a new

copy this. And if I open it in a new tab,

tab, it is going to open my overall form. As

it is going to open my overall form. As of now, of course, we have not

of now, of course, we have not configured it. So this is very empty

configured it. So this is very empty kind of a form. Let me close this. We

kind of a form. Let me close this. We can have a production kind of a URL as

can have a production kind of a URL as well. So the overall form test form -

well. So the overall form test form - test and how we have the produ uh

test and how we have the produ uh production URL. So for the people who

production URL. So for the people who are seeing this for the first time just

are seeing this for the first time just assume it is a Google form nothing else

assume it is a Google form nothing else nothing difficult. This is just a unique

nothing difficult. This is just a unique identifier just like your form I can

identifier just like your form I can have. Now we can have some

have. Now we can have some authentication. We can have some basic O

authentication. We can have some basic O or none. For the time being I'm setting

or none. For the time being I'm setting it as none. I can have the form title.

it as none. I can have the form title. So let's say uh may

So let's say uh may consultation

consultation form. So what I'm trying to do here

form. So what I'm trying to do here everyone I am trying to create this

everyone I am trying to create this particular form for anyone who would

particular form for anyone who would like to have AI consultation with me. So

like to have AI consultation with me. So this is again something which I do

this is again something which I do parallelly where uh we help uh startups

parallelly where uh we help uh startups organization etc by automating their

organization etc by automating their workflow right. So we based on the

workflow right. So we based on the knowledge. So this is again I'm just

knowledge. So this is again I'm just attaching it to a use case. So you can

attaching it to a use case. So you can also parally create workflows for

also parally create workflows for anything which you do right.

anything which you do right. Understanding things with the use case

Understanding things with the use case is a lot more easier. Now I can have

is a lot more easier. Now I can have some form description. Uh hey there

some form description. Uh hey there glad to meet you.

glad to meet you. Please fill in the below details

Please fill in the below details so that you uh so as to

so that you uh so as to connect with

connect with may for AI consultation

may for AI consultation or say training. So again just I'm

or say training. So again just I'm listing out the things which I have. Let

listing out the things which I have. Let us correct the spelling.

us correct the spelling. So now it is saying that okay form

So now it is saying that okay form elements right uh elements as the name

elements right uh elements as the name suggest what else we want in the form.

suggest what else we want in the form. So surely we will be having something as

So surely we will be having something as easy as name so that I have your name

easy as name so that I have your name here. Now it is a type as you can see

here. Now it is a type as you can see here. Let me just zoom it in a little.

here. Let me just zoom it in a little. We have the field name which is your

We have the field name which is your name. Element type. So there are

name. Element type. So there are different different element types here

different different element types here which we can see. We have the custom

which we can see. We have the custom HTML, date, drop-own list, email, file,

HTML, date, drop-own list, email, file, hidden field, number, password, text or

hidden field, number, password, text or text area. So I will have it as text for

text area. So I will have it as text for the time being. And of course I can have

the time being. And of course I can have your name and I can make it a required

your name and I can make it a required field. So I'm pretty sure that till now

field. So I'm pretty sure that till now each and everything should be a lot easy

each and everything should be a lot easy and clear. I can have another form

and clear. I can have another form element. So let's say this time I can

element. So let's say this time I can have domain. So I'm making it a easy to

have domain. So I'm making it a easy to understand or let's say rather service.

understand or let's say rather service. Now this time since this is a service I

Now this time since this is a service I want it to be limited. I can have this

want it to be limited. I can have this as let's say a drop-own list right or

as let's say a drop-own list right or let me have it not as a drop-own list.

let me have it not as a drop-own list. Let me have it as uh yeah I think

Let me have it as uh yeah I think drop-own list work because here I don't

drop-own list work because here I don't want the person to have more choices.

want the person to have more choices. Sorry here I want the person to have

Sorry here I want the person to have choices. It can be for consultation

choices. It can be for consultation or let me have the option field options

or let me have the option field options right I can have the training so I have

right I can have the training so I have these two overall options everyone now I

these two overall options everyone now I don't want to it to be multiple choice I

don't want to it to be multiple choice I want it to be only for one service and I

want it to be only for one service and I can make it a required field as well

can make it a required field as well right so if I go back if I go back uh

right so if I go back if I go back uh sorry I think if If I click this and if

sorry I think if If I click this and if I have it. Okay, I think we click the

I have it. Okay, I think we click the execute step button in your form

execute step button in your form trigger. So it is showing you form

trigger. So it is showing you form trigger isn't listing yet. Click execute

trigger isn't listing yet. Click execute step button in your trigger. Right? So I

step button in your trigger. Right? So I have to just go here and click on this

have to just go here and click on this execute step button. So execute step.

execute step button. So execute step. And now this is a test version of our

And now this is a test version of our form which we can see my consultation

form which we can see my consultation form. Uh hey there glad to meet you.

form. Uh hey there glad to meet you. Please fill in the details so as to

Please fill in the details so as to connect with Mayang for AI consultation

connect with Mayang for AI consultation or training. Now I can have my name

or training. Now I can have my name here. I can have the service which I

here. I can have the service which I want to select. So this is a very very

want to select. So this is a very very straightforward way of creating your or

straightforward way of creating your or starting your workflow. Anytimes anyone

starting your workflow. Anytimes anyone fills in the form you will be starting

fills in the form you will be starting with the same. So let's go back to the

with the same. So let's go back to the edit in now and let's stop listening for

edit in now and let's stop listening for the time being. So listening as the name

the time being. So listening as the name suggests like anytime someone fills it

suggests like anytime someone fills it in you are constantly listening right

in you are constantly listening right uh it will trigger your workflow once

uh it will trigger your workflow once you click the submit button. So now let

you click the submit button. So now let me also show you few more things. So

me also show you few more things. So these are the different different

these are the different different elements. Now you can make it as much

elements. Now you can make it as much in-depth as you want.

in-depth as you want. Respond when form is submitted or when

Respond when form is submitted or when the workflow finishes. So you can click

the workflow finishes. So you can click this button when to respond to the form

this button when to respond to the form submission. Right? So I think form is

submission. Right? So I think form is submitted is pretty good. Now I would

submitted is pretty good. Now I would like to have your overall attention a

like to have your overall attention a little bit here options here I can have

little bit here options here I can have as you can see uh 1 minute. Yeah sorry.

as you can see uh 1 minute. Yeah sorry. So here as you can see I can have an

So here as you can see I can have an option. Now these are different settings

option. Now these are different settings right? These are separate settings with

right? These are separate settings with respect to our form or this particular

respect to our form or this particular node. I can click add option. And the

node. I can click add option. And the very first one can be append, edit and

very first one can be append, edit and attribution. So let me do one thing. Let

attribution. So let me do one thing. Let me just first get rid of this. I can

me just first get rid of this. I can avoid that. Now what this does, let me

avoid that. Now what this does, let me execute step. And you see that how this

execute step. And you see that how this one is not having this form automated

one is not having this form automated with NA10. Right? So again some extra

with NA10. Right? So again some extra options which you want to use. So let me

options which you want to use. So let me stop listening again.

stop listening again. Now I can have another option. I can

Now I can have another option. I can have button label. So let's say let AI

have button label. So let's say let AI your

your world pretty uh good thing to write but

world pretty uh good thing to write but let me just execute it now again and you

let me just execute it now again and you see that how instead of submit it is

see that how instead of submit it is uh let AI fire your world. So small

uh let AI fire your world. So small small changes which we can of course

small changes which we can of course have and this is what I meant that even

have and this is what I meant that even if uh any is no code it does provide you

if uh any is no code it does provide you these options separately which you can

these options separately which you can work on. So again we can have more

work on. So again we can have more options we can have form path form

options we can have form path form responses workflow time zone custom form

responses workflow time zone custom form styling as well. So we can have this CSV

styling as well. So we can have this CSV again which we can provide. I think this

again which we can provide. I think this is that. Yeah. So through which we can

is that. Yeah. So through which we can do some custom form uh styling. Again

do some custom form uh styling. Again just showing you that how it supports so

just showing you that how it supports so many things. After that we can go onto

many things. After that we can go onto this second tab as well everyone. So

this second tab as well everyone. So here we have this second tab where we

here we have this second tab where we have the setting. So we can have this

have the setting. So we can have this note right and we can just uh let's say

note right and we can just uh let's say mention um my first form. So what is

mention um my first form. So what is this mentioning? optional node to save

this mentioning? optional node to save with node. Pretty nicely understood. And

with node. Pretty nicely understood. And we can have if active the note above

we can have if active the note above will display in the flow as a subtitle.

will display in the flow as a subtitle. So let me just select this. And the best

So let me just select this. And the best way to see what is happening. Let's

way to see what is happening. Let's first save everything. Always make sure

first save everything. Always make sure that you save your uh flow constantly. I

that you save your uh flow constantly. I don't find any autosave button as of

don't find any autosave button as of now. And if I go back, I think it is

now. And if I go back, I think it is showing it here. So the note is kind of

showing it here. So the note is kind of also helping you in documenting what it

also helping you in documenting what it does.

does. Now when I click this we can go inside

Now when I click this we can go inside it and we can see that how it is

it and we can see that how it is listening.

listening. Let me uh also tell you that how you

Let me uh also tell you that how you have to see this particular uh like the

have to see this particular uh like the left and the right part. So for that

left and the right part. So for that what I will be doing I will be just

what I will be doing I will be just executing this step and let me just fill

executing this step and let me just fill it with may. So I am myself reaching out

it with may. So I am myself reaching out for the consultation. Okay. And I can

for the consultation. Okay. And I can just AI fire. Once the same has been

just AI fire. Once the same has been submitted, if I go back since my NAN was

submitted, if I go back since my NAN was listening, you can see that how I am

listening, you can see that how I am having a output here, right? Name my

having a output here, right? Name my service consultation and we are having

service consultation and we are having some metadata. So this thing is

some metadata. So this thing is something which I have not entered but

something which I have not entered but it is showing because this is the

it is showing because this is the metadata which is having the details

metadata which is having the details when I submitted my form. Right now the

when I submitted my form. Right now the use case can be pretty helpful. We can

use case can be pretty helpful. We can just have it used to see that okay what

just have it used to see that okay what was the latest entry etc. Now uh the

was the latest entry etc. Now uh the flow is pretty simple uh what I was

flow is pretty simple uh what I was explaining. Let me add maybe another

explaining. Let me add maybe another uh node here. It is just following left

uh node here. It is just following left to right. So see in the left as we don't

to right. So see in the left as we don't have anything right. So the this is one

have anything right. So the this is one very good thing in the UI or UI user

very good thing in the UI or UI user experience of NA10. It is very logical

experience of NA10. It is very logical in nature. Right? So on the left if we

in nature. Right? So on the left if we would have had something we would be

would have had something we would be seeing the same but since we don't have

seeing the same but since we don't have anything this is the same execute step

anything this is the same execute step on the right is the output

on the right is the output which

which you all will also feel that it is pretty

you all will also feel that it is pretty logical to handle that others can

logical to handle that others can basically use this output right so the

basically use this output right so the nodes which are going to be in future so

nodes which are going to be in future so now uh with the form thing totally

now uh with the form thing totally understood everyone I am going to now

understood everyone I am going to now focus us and add another node. This node

focus us and add another node. This node is going to be my sheets, Google sheets.

is going to be my sheets, Google sheets. And I can just do append uh append row

And I can just do append uh append row in a sheet. So let us use this append

in a sheet. So let us use this append row. Right now you can see this thing is

row. Right now you can see this thing is what I was mentioning about everyone

what I was mentioning about everyone that how on the left we have the input

that how on the left we have the input where we are having this particular

where we are having this particular details from the form which I filled.

details from the form which I filled. So pretty easy to follow how we have on

So pretty easy to follow how we have on the left everything present and on the

the left everything present and on the right is going to be the output once

right is going to be the output once this particular node gets triggered. So

this particular node gets triggered. So I hope you are able to appreciate how

I hope you are able to appreciate how logical this is how it is flowing from

logical this is how it is flowing from left to right. So left all the inputs

left to right. So left all the inputs which you can use or refer to inside

which you can use or refer to inside your form and on the right we have the

your form and on the right we have the output which will of course go to the

output which will of course go to the future nodes as well. Okay. So here we

future nodes as well. Okay. So here we have variable and context as well. These

have variable and context as well. These are the different different uh variables

are the different different uh variables which are present in my workflow

which are present in my workflow algether which is your now variable.

algether which is your now variable. Then today if you remember we created a

Then today if you remember we created a variable name where I just had may so

variable name where I just had may so this is something which we can also use

this is something which we can also use and I will show you that how of course

and I will show you that how of course we can uh use it inside our details. Now

we can uh use it inside our details. Now let's try to understand about uh Google

let's try to understand about uh Google sheets in depth. So once you do let's

sheets in depth. So once you do let's say three to five of these nodes in

say three to five of these nodes in depth which I will be covering in

depth which I will be covering in automation only I think it will be very

automation only I think it will be very easy to make sense of other nodes

easy to make sense of other nodes because more or less just drag and drop

because more or less just drag and drop you just have to connect things right

you just have to connect things right now what is happening everyone what I

now what is happening everyone what I want to explain you let's go to this uh

want to explain you let's go to this uh visualization here and in this uh I want

visualization here and in this uh I want to do one thing so just to explain you a

to do one thing so just to explain you a little bit better let me have this edit

little bit better let me have this edit icon.

icon. So to make sure that we can connect to

So to make sure that we can connect to our Google sheets everyone again we will

our Google sheets everyone again we will have to connect right are N8N with the

have to connect right are N8N with the Google sheet. So the idea is pretty

Google sheet. So the idea is pretty simple n as an application it cannot

simple n as an application it cannot directly

directly uh deduce that okay what sheet you want

uh deduce that okay what sheet you want to connect with right so I will have to

to connect with right so I will have to create this connection and for creating

create this connection and for creating this connection we need to do some

this connection we need to do some authorization as well. Now it is pretty

authorization as well. Now it is pretty logical to think like let's say if you

logical to think like let's say if you are maintaining a sheet or an excel not

are maintaining a sheet or an excel not everyone should be able to come and work

everyone should be able to come and work on the same right so for the same what I

on the same right so for the same what I will be doing let me go back and let us

will be doing let me go back and let us have a sheet created so sheets let me do

have a sheet created so sheets let me do one thing sheets dot new

one thing sheets dot new so again just a quick shortcut to create

so again just a quick shortcut to create a new Google sheet and we have this

a new Google sheet and we have this sheet created now I can have let's say

sheet created now I can have let's say um

um leads right I'm just writing it as leads

leads right I'm just writing it as leads here I know that I will be having a name

here I know that I will be having a name and I will be having a service right so

and I will be having a service right so and I can just have it uh let's say

and I can just have it uh let's say inquire

inquire time maybe so I can just write it

time maybe so I can just write it something like this or let me just write

something like this or let me just write make it easy and write it time let me

make it easy and write it time let me close everything here now you can see

close everything here now you can see that how I have defined three things

that how I have defined three things here which I want to fill on the basis

here which I want to fill on the basis of my form. Right? So let me just keep

of my form. Right? So let me just keep it uh and connect it with my sheet. So

it uh and connect it with my sheet. So let's now

let's now go back. I will just click my sheet

go back. I will just click my sheet again. Right here you can see that

again. Right here you can see that create credential to connect with.

create credential to connect with. Right? I will have to create a new

Right? I will have to create a new credential because as I said we are

credential because as I said we are connecting our editor to the Google

connecting our editor to the Google sheet. Right? So let me create a new

sheet. Right? So let me create a new credential and you see that how again I

credential and you see that how again I have sign in with Google right. So since

have sign in with Google right. So since we are using Google sheet and we know

we are using Google sheet and we know that our Google can easily Google

that our Google can easily Google account can only help to connect with

account can only help to connect with our sheet right. So let me click this.

our sheet right. So let me click this. Now you can have a different way of

Now you can have a different way of authorization as well. Uh again this is

authorization as well. Uh again this is a little bit difficult right but uh yeah

a little bit difficult right but uh yeah you can provide these account email the

you can provide these account email the region you can have the assistant help

region you can have the assistant help for this instruction right some private

for this instruction right some private key impersonate as user so again

key impersonate as user so again different ways are present which are a

different ways are present which are a lot complex but for the time being I

lot complex but for the time being I believe that o2 the recommended way is

believe that o2 the recommended way is easier for you then we can have sharing

easier for you then we can have sharing etc as well that okay uh like this is in

etc as well that okay uh like this is in the detail within us only learn NA10

the detail within us only learn NA10 project is the owner and some details

project is the owner and some details which are present. So let's go to

which are present. So let's go to connection and sign in with Google.

connection and sign in with Google. So here again I just have the email

So here again I just have the email which uh I have logged in AI with

which uh I have logged in AI with Mayang.

Mayang. So it is just now having some three

So it is just now having some three services uh which is view and manage

services uh which is view and manage metadata of files in your Google drive.

metadata of files in your Google drive. So your Google sheet gets saved to your

So your Google sheet gets saved to your Google drive right and see edit create

Google drive right and see edit create and delete your Google sheets

and delete your Google sheets spreadsheets right. So for the timing

spreadsheets right. So for the timing you can provide that should be fine and

you can provide that should be fine and the connection is successful. So pretty

the connection is successful. So pretty easy to connect this right and it has

easy to connect this right and it has made it a lot easier to connect which is

made it a lot easier to connect which is very difficult if you try to write it in

very difficult if you try to write it in code. Okay so I can just close this. Now

code. Okay so I can just close this. Now the good thing is that uh if I now talk

the good thing is that uh if I now talk about resource okay so I can either have

about resource okay so I can either have a full document or I can have a sheet

a full document or I can have a sheet with document operation is append row

with document operation is append row which we have already seen. So we will

which we have already seen. So we will be appending a new row into this

be appending a new row into this particular operation.

particular operation. Now let's take talk about this document.

Now let's take talk about this document. So in terms of nit language this is a

So in terms of nit language this is a document and this is a sheet right? So

document and this is a sheet right? So if I you see a little bit bottom this is

if I you see a little bit bottom this is a sheet everyone and we have this as the

a sheet everyone and we have this as the document name. So leads is the document

document name. So leads is the document name. Now let me go back here and I can

name. Now let me go back here and I can have the sheet within document operation

have the sheet within document operation is append row and I will be selecting my

is append row and I will be selecting my document from this. So it has searched

document from this. So it has searched and got this pretty nicely. So I can

and got this pretty nicely. So I can have leads here and again it is just

have leads here and again it is just doing the hard work for us. And we can

doing the hard work for us. And we can have sheet one. So in the back end only

have sheet one. So in the back end only once you collect connect this it tries

once you collect connect this it tries to make a call and get all the

to make a call and get all the spreadsheets or document which you have

spreadsheets or document which you have created and then within that it is

created and then within that it is having the sheet one. Now you will see

having the sheet one. Now you will see that how it is having name, service and

that how it is having name, service and time the columns which I have created

time the columns which I have created extracted here. So I'm showing you that

extracted here. So I'm showing you that how it has been created very very nicely

how it has been created very very nicely with the flow in mind which majority

with the flow in mind which majority uses and of course we have different

uses and of course we have different different options which we can change.

different options which we can change. So I can now do map each uh column

So I can now do map each uh column manually and map automatically. I would

manually and map automatically. I would like to do and show you by doing this

like to do and show you by doing this manually.

manually. So it is fetching the column again. Now

So it is fetching the column again. Now we have this name everyone and let me

we have this name everyone and let me just uh let's say if you see here

just uh let's say if you see here it is saying drag an input field from

it is saying drag an input field from the left to use it here right now I hope

the left to use it here right now I hope you understand that how I will not be

you understand that how I will not be adding may here because if I make it may

adding may here because if I make it may like this it is uh filled it is uh sorry

like this it is uh filled it is uh sorry it is basically fixed right you can see

it is basically fixed right you can see the fixed here as well so this is for

the fixed here as well so this is for the use case when you want to always

the use case when you want to always send some fixed information but that is

send some fixed information but that is not going to be the case. If you

not going to be the case. If you genuinely understand the use case our

genuinely understand the use case our sheet will get appended or we will have

sheet will get appended or we will have the input based on what we are entering

the input based on what we are entering inside the form right. So with that in

inside the form right. So with that in mind everyone what we will have to do is

mind everyone what we will have to do is we can drag and drop from the previous

we can drag and drop from the previous nodes. So this is the beauty of any that

nodes. So this is the beauty of any that how the things are in flow right. So

how the things are in flow right. So just I will have to drag and drop my

just I will have to drag and drop my flows and in this what we will be now

flows and in this what we will be now doing everyone I just have to drag it

doing everyone I just have to drag it like this and drop it here. So let me

like this and drop it here. So let me just remove this Mayang.

just remove this Mayang. Now as soon as I have dragged and

Now as soon as I have dragged and dropped this you see that how it has

dropped this you see that how it has changed to expression because now this

changed to expression because now this is not fixed. This will be changing

is not fixed. This will be changing based on what I input. It is showing me

based on what I input. It is showing me the result. It is showing me the result

the result. It is showing me the result which is Mayang and I will be covering

which is Mayang and I will be covering that what exactly this is uh after we

that what exactly this is uh after we kind of complete this form. So don't

kind of complete this form. So don't worry I will be explaining you this

worry I will be explaining you this notation as well in a lot of depth.

notation as well in a lot of depth. Now similarly you can just drag and drop

Now similarly you can just drag and drop a service. So very very easy to do it

a service. So very very easy to do it will change to expression and it is

will change to expression and it is showing you the current value. So let's

showing you the current value. So let's say if I would have selected uh let's

say if I would have selected uh let's say training it would have shown you

say training it would have shown you training here. Similarly, submitted ad I

training here. Similarly, submitted ad I can have it here and you see that how

can have it here and you see that how the same has also been done. Okay. Now

the same has also been done. Okay. Now just to check it uh check it quickly and

just to check it uh check it quickly and again we have options here as well. We

again we have options here as well. We have the cell format data location on

have the cell format data location on sheet and minimize API calls. So few

sheet and minimize API calls. So few things which we can configure and

things which we can configure and similarly we have the settings. So

similarly we have the settings. So always output data execute once right.

always output data execute once right. So if active

So if active the node execute only once with the data

the node execute only once with the data from the first item it receives retry on

from the first item it receives retry on fail. So this execute one can be pretty

fail. So this execute one can be pretty good if you have multiple uh let's say

good if you have multiple uh let's say things and you just want to test it out.

things and you just want to test it out. So let's say you have 100 values but we

So let's say you have 100 values but we want to just check it for first value to

want to just check it for first value to make sure that it works due to whatever

make sure that it works due to whatever reason if it fails do we want it to

reason if it fails do we want it to retry? Let's say if I go and I delete

retry? Let's say if I go and I delete that sheet so it will fail on the first

that sheet so it will fail on the first try. So do we want to retry that? Maybe

try. So do we want to retry that? Maybe I changed the name. Okay. And this on

I changed the name. Okay. And this on error what we want to do we do we want

error what we want to do we do we want to stop the workflow because we can have

to stop the workflow because we can have future uh nodes here as well. Right. So

future uh nodes here as well. Right. So we can have the nodes after that. What

we can have the nodes after that. What do you want to do? So these workflow

do you want to do? So these workflow relating settings are present here.

relating settings are present here. Okay. You will see that these are kind

Okay. You will see that these are kind of common in uh many of the nodes which

of common in uh many of the nodes which we create because they are not related

we create because they are not related to a node but rather the full workflow.

to a node but rather the full workflow. So I can either stop the workflow or I

So I can either stop the workflow or I can continue or I can continue using the

can continue or I can continue using the error as the input right. So pretty

error as the input right. So pretty straightforward and easy to understand

straightforward and easy to understand and then we can have some notes as well.

and then we can have some notes as well. Uh my first sheet. So as I said they are

Uh my first sheet. So as I said they are going to be a lot common across notes.

going to be a lot common across notes. So once you understand them everything

So once you understand them everything is going to be easy. And we have the

is going to be easy. And we have the docs again as well.

docs again as well. So let us try to execute this once

So let us try to execute this once everyone let's execute the step

everyone let's execute the step and

and okay it is executing seems like it has

okay it is executing seems like it has executed which means we have the

executed which means we have the information here. So yeah you can see

information here. So yeah you can see that how powerful the same is. Now if I

that how powerful the same is. Now if I go on let me close these uh ones let me

go on let me close these uh ones let me close this as well.

close this as well. And now if you see we have the output

And now if you see we have the output here as well. So we can see that output

here as well. So we can see that output is my service consultation and the time.

is my service consultation and the time. Let me close this. And now let me have

Let me close this. And now let me have Gmail. Okay. So let me have Gmail. In

Gmail. Okay. So let me have Gmail. In Gmail I want to now send a message. Let

Gmail I want to now send a message. Let me uh where exactly is this? Send a

me uh where exactly is this? Send a message.

message. And now what I want to show you, we have

And now what I want to show you, we have these two nodes which are precursor to

these two nodes which are precursor to our Gmail node. Right? So the logic says

our Gmail node. Right? So the logic says that I should be able to use both of

that I should be able to use both of these inputs. This is what you will see

these inputs. This is what you will see here. So if you show on input, we have

here. So if you show on input, we have the sheet here. We have the on form

the sheet here. We have the on form submission and of course we have the

submission and of course we have the variable and context everything present

variable and context everything present as it would. So I'm pretty sure that

as it would. So I'm pretty sure that this shall be a lot easy for you to

this shall be a lot easy for you to understand. Now I can again I will have

understand. Now I can again I will have to create a credential because this is a

to create a credential because this is a new workflow which uh I have created. So

new workflow which uh I have created. So the previous credential they are not

the previous credential they are not being carried upon. Okay. So I hope

being carried upon. Okay. So I hope you're able to easily understand and

you're able to easily understand and join the workflow here everyone that how

join the workflow here everyone that how we have created a form and it's a init

we have created a form and it's a init form init form. We have appended the

form init form. We have appended the value inside the sheet so that we can

value inside the sheet so that we can use it further anywhere inside our

use it further anywhere inside our workflow. And now we can just send the

workflow. And now we can just send the mail. So let me just quickly set these

mail. So let me just quickly set these settings up. Now in the setting you will

settings up. Now in the setting you will see that how these are the common ones.

see that how these are the common ones. So I will not be explaining them again.

So I will not be explaining them again. You can just quickly uh play around with

You can just quickly uh play around with them. If you want for your particular

them. If you want for your particular node if there is a lot of uh information

node if there is a lot of uh information you make sure that you fill in these

you make sure that you fill in these notes. They are very helpful. Uh

notes. They are very helpful. Uh something which I always make sure to

something which I always make sure to fill along with the sticky notes

fill along with the sticky notes outside. Then again let's go to the

outside. Then again let's go to the create new credential. I will be doing a

create new credential. I will be doing a authorization again. So let's do this.

authorization again. So let's do this. More or less it has the things uh just

More or less it has the things uh just it wants to re uh affirm that overall.

it wants to re uh affirm that overall. So good practice connection is

So good practice connection is successful. We can close this. Let's go

successful. We can close this. Let's go back.

back. Now resource is message. Uh we have the

Now resource is message. Uh we have the label draft or thread as well. Uh let's

label draft or thread as well. Uh let's first work on message only. Operation is

first work on message only. Operation is send. So you can change these things

send. So you can change these things here as well. uh it's not that since you

here as well. uh it's not that since you have selected Gmail and you have

have selected Gmail and you have selected send a message it's not that

selected send a message it's not that you will have to go back and it is a

you will have to go back and it is a little smart at the end right because

little smart at the end right because majorly if we think about this we see

majorly if we think about this we see this Gmail here right so we can have the

this Gmail here right so we can have the operation change at least so I can just

operation change at least so I can just have send here you can see that how you

have send here you can see that how you have different different operations here

have different different operations here so send now to AI with may at the

so send now to AI with may at the rategmail gmail.com

rategmail gmail.com gmail.com

gmail.com subject is let's say form

subject is let's say form leadupdate

leadupdate and now I can have the email type so let

and now I can have the email type so let me make it text only as well for the

me make it text only as well for the time being you can easily go to uh chat

time being you can easily go to uh chat GP or any other LLM and maybe just ask

GP or any other LLM and maybe just ask for a HTML kind of a thing again uh it

for a HTML kind of a thing again uh it will be a little better formatted now I

will be a little better formatted now I can just present the message here

can just present the message here everyone so in the message I can say hey

everyone so in the message I can say hey my uncle

my uncle so now see there's a problem if I press

so now see there's a problem if I press enter or something I will not be able to

enter or something I will not be able to see this for that uh I hope you see this

see this for that uh I hope you see this small button here which pops up so let

small button here which pops up so let me show you that now easily let's say uh

me show you that now easily let's say uh if I just

if I just go towards this thing I see this button

go towards this thing I see this button which is for open edit window right so I

which is for open edit window right so I will click this button and now I can say

will click this button and now I can say hey May uh how are you again I'm just

hey May uh how are you again I'm just showing you that this is the default

showing you that this is the default message which we have already seen in

message which we have already seen in our simple first automation and it is

our simple first automation and it is going to send the message but this time

going to send the message but this time I don't want to send the message like

I don't want to send the message like this rather what I want is I want that

this rather what I want is I want that uh now you will see that how it has been

uh now you will see that how it has been divided hey my how are you

divided hey my how are you there is a new lead on the form

there is a new lead on the form And I can just say name. Now for this

And I can just say name. Now for this name what I can do I can again drag and

name what I can do I can again drag and drop. So see I have drag and dropped it.

drop. So see I have drag and dropped it. And now it has been a lot better in

And now it has been a lot better in terms of overall writing. So if I close

terms of overall writing. So if I close this since you have now included and

this since you have now included and showed that how it can be a expression

showed that how it can be a expression based. So you have to follow this right.

based. So you have to follow this right. As soon as I remove this, it will become

As soon as I remove this, it will become I can make it fixed. And once I go and

I can make it fixed. And once I go and do expression, then what I can do is I

do expression, then what I can do is I can just get this name here

can just get this name here with this. If you now expand, it will be

with this. If you now expand, it will be a lot easier and better to overall work

a lot easier and better to overall work on. So let me now make it a better

on. So let me now make it a better formatted thing. How are you? There is a

formatted thing. How are you? There is a new lead on the form name.

new lead on the form name. Then uh service is your service. So

Then uh service is your service. So again I can just easily drag and drop

again I can just easily drag and drop and I can have the time which is this

and I can have the time which is this time if I would have wanted because all

time if I would have wanted because all of the others are in the downstream and

of the others are in the downstream and don't get any uh afraid of this syntax.

don't get any uh afraid of this syntax. I will be explaining you the same once

I will be explaining you the same once we complete this automation. Right.

we complete this automation. Right. First I want that you get the taste of

First I want that you get the taste of the automation. Okay like okay yeah this

the automation. Okay like okay yeah this is working. This is pretty powerful.

is working. This is pretty powerful. Then I will show you and make you master

Then I will show you and make you master in these small small things as well.

in these small small things as well. After that uh you can just say thanks.

After that uh you can just say thanks. And what I also would like to do

And what I also would like to do everyone is I would like to have a

everyone is I would like to have a source here. And in this source I can go

source here. And in this source I can go on variable and context and let's say I

on variable and context and let's say I have the workflow ID. So now understand

have the workflow ID. So now understand I can have multiple workflows which are

I can have multiple workflows which are running. I should be aware that okay

running. I should be aware that okay from which it is coming. So this workfl

from which it is coming. So this workfl ID might seem a little technical but it

ID might seem a little technical but it is just a unique identifier. Okay. So I

is just a unique identifier. Okay. So I can just say thanks uh your awesome

can just say thanks uh your awesome workflow.

workflow. So I can have other information as well

So I can have other information as well name if it is active or not. Then

name if it is active or not. Then execution uh how many executions have

execution uh how many executions have been there the variables which I have

been there the variables which I have here and some now and today things which

here and some now and today things which I can use. So let me just now uh close

I can use. So let me just now uh close this and yeah you can see that how this

this and yeah you can see that how this is pretty nicely formatted now we can

is pretty nicely formatted now we can easily read the same as well. If I want

easily read the same as well. If I want I can have some uh other things I can

I can have some uh other things I can just remove this append nit attribution

just remove this append nit attribution pretty uh good from nit that it is not a

pretty uh good from nit that it is not a paid feature right uh in most of the

paid feature right uh in most of the application this is a paid feature. Now

application this is a paid feature. Now if I execute this

if I execute this and if I go on my email, let me go on

and if I go on my email, let me go on the outside.

the outside. Okay, so this I can delete this should

Okay, so this I can delete this should be fine. Uh okay, my bad. Let me undo

be fine. Uh okay, my bad. Let me undo it. So yeah, we got this form lead

it. So yeah, we got this form lead update. Hey Mayang, how are you? There

update. Hey Mayang, how are you? There is a new lead on the form name. Service

is a new lead on the form name. Service consultation time source. Uh again this

consultation time source. Uh again this can help me to understand from which it

can help me to understand from which it came. Uh ideally this source might not

came. Uh ideally this source might not make a lot of sense. the name of the

make a lot of sense. the name of the workflow will but yes tomorrow name can

workflow will but yes tomorrow name can same but this unique identifier will

same but this unique identifier will always be the same right so thanks your

always be the same right so thanks your awesome workflow and you see that how

awesome workflow and you see that how things are working as we would like them

things are working as we would like them to work right so in a way we did

to work right so in a way we did understood that yes this is working and

understood that yes this is working and yeah this is a complete workflow

yeah this is a complete workflow everyone right so we genuinely have

everyone right so we genuinely have completed this workflow the first two

completed this workflow the first two things are something which you can do

things are something which you can do with Google form as well like it did in

with Google form as well like it did in the back and can maintain a sheet but uh

the back and can maintain a sheet but uh sending or connecting it with email and

sending or connecting it with email and if we can do it with email you can

if we can do it with email you can surely do it with other services as

surely do it with other services as well. So there are of course so many

well. So there are of course so many apps and integration which I can connect

apps and integration which I can connect and work on which I also uh ran you

and work on which I also uh ran you through which you can easily understand

through which you can easily understand that how this is a lot more powerful

that how this is a lot more powerful right. So with that everyone we have

right. So with that everyone we have completed our first automation. Now uh

completed our first automation. Now uh before we move on to the second

before we move on to the second automation which is a little bit uh

automation which is a little bit uh little up the notch right what I would

little up the notch right what I would like to do is I would like to explain

like to do is I would like to explain you a little bit more in depth about

you a little bit more in depth about this input and output how we can have

this input and output how we can have this different different uh overall

this different different uh overall uh ways or the types right here and here

uh ways or the types right here and here as well along with that how you have to

as well along with that how you have to not be afraid and understand about uh

not be afraid and understand about uh these things right how you and without

these things right how you and without dragging and dropping just by simple

dragging and dropping just by simple reference also make sense of this. So

reference also make sense of this. So what is this JSON? All these things I

what is this JSON? All these things I will be covering. So that again if you

will be covering. So that again if you are a fresher and normally as well since

are a fresher and normally as well since in coding we don't go in depth about

in coding we don't go in depth about these JSON etc. Here this is the

these JSON etc. Here this is the language which we will be using right.

language which we will be using right. So this is the language of communication

So this is the language of communication with your nit workflow that is your JSON

with your nit workflow that is your JSON and how you will be referring to these

and how you will be referring to these variable. So it's still no code no code

variable. So it's still no code no code sorry but you have to understand this in

sorry but you have to understand this in a lot of depth. So this is what I would

a lot of depth. So this is what I would like to first explain you because this

like to first explain you because this will be useful for everything each and

will be useful for everything each and like any workflow which you create no

like any workflow which you create no matter the use case and uh if you pick

matter the use case and uh if you pick up any template this is what will be uh

up any template this is what will be uh helpful in understanding that template

helpful in understanding that template in depth right so sh save your workflow

in depth right so sh save your workflow and now let's jump on to understanding

and now let's jump on to understanding about this particular uh input output

about this particular uh input output and JSON in a lot of depth so I have

and JSON in a lot of depth so I have created a like I have sorry had a

created a like I have sorry had a awesome workflow which you can so via

awesome workflow which you can so via which I will be explaining you the same

which I will be explaining you the same cool everyone so now let's move forward

cool everyone so now let's move forward uh pretty sure that this automation

uh pretty sure that this automation shall be a lot clear uh highly suggest

shall be a lot clear uh highly suggest you to also try out uh other different

you to also try out uh other different different uh indications right so I have

different uh indications right so I have shown you with the most common one and

shown you with the most common one and we will be using Gmail and Google sheets

we will be using Gmail and Google sheets wherever possible the reason is that for

wherever possible the reason is that for the majority right I guess for 95% of

the majority right I guess for 95% of the people and learners this is

the people and learners this is something which we use every day. So

something which we use every day. So automating this or able to understand

automating this or able to understand this is something which will be very

this is something which will be very helpful. Right? Though of course you can

helpful. Right? Though of course you can use uh other apps and integration as

use uh other apps and integration as well. Now let's move on to understanding

well. Now let's move on to understanding the basics as I said of JSON in

the basics as I said of JSON in particular. Now the same will be very

particular. Now the same will be very helpful for anyone who have no idea

helpful for anyone who have no idea about coding or any structure in

about coding or any structure in general. And for the same I have used

general. And for the same I have used one of the templates which has been

one of the templates which has been given. Let me show you that. So if I go

given. Let me show you that. So if I go yeah learn JSON basics.

yeah learn JSON basics. So this is the template everyone which

So this is the template everyone which uh via which we will be understanding

uh via which we will be understanding about this JSON in depth. Now if you

about this JSON in depth. Now if you have an idea about JSON I will suggest

have an idea about JSON I will suggest you to watch this on 2x maybe the reason

you to watch this on 2x maybe the reason is pretty simple that it will at least

is pretty simple that it will at least help you to remember all these things

help you to remember all these things right and one more thing so

right and one more thing so understanding this uh since this might

understanding this uh since this might be not code exactly but this might be

be not code exactly but this might be the closest you will come to coding in

the closest you will come to coding in terms of NAN so I believe that the same

terms of NAN so I believe that the same is very very important now let me do one

is very very important now let me do one thing again so that you can also get

thing again so that you can also get these uh let me uh download this.

these uh let me uh download this. So let me download this.

So let me download this. So I have saved the same we can go here

So I have saved the same we can go here and we can click download. Uh it will be

and we can click download. Uh it will be downloaded as a JSON. Let me just uh

downloaded as a JSON. Let me just uh maybe download it again and we see that

maybe download it again and we see that how we have two downloads of this. Now

how we have two downloads of this. Now to load it again to my uh other space

to load it again to my uh other space right. So this is the one which I have

right. So this is the one which I have created as a reference so that I have

created as a reference so that I have these things saved. Uh in this what I

these things saved. Uh in this what I can do? Let me first save this. So very

can do? Let me first save this. So very important. Let's go back and let's have

important. Let's go back and let's have a new workflow. So create workflow.

a new workflow. So create workflow. Now I will be doing this import from

Now I will be doing this import from file. Now I'm showing you this because

file. Now I'm showing you this because you will also be using the JSONs or the

you will also be using the JSONs or the files which I provide to load and yes

files which I provide to load and yes this is the exact same JSON which we are

this is the exact same JSON which we are talking about right? So JSON as a file

talking about right? So JSON as a file which we are downloading and also

which we are downloading and also something which we will be using a lot

something which we will be using a lot in NA10. So let us now import from file.

in NA10. So let us now import from file. uh let me click this and I can just

uh let me click this and I can just select this learn JSON basics. Now you

select this learn JSON basics. Now you will see so many of these blocks and

will see so many of these blocks and don't get afraid they are very easy to

don't get afraid they are very easy to understand. Let me first go and tell you

understand. Let me first go and tell you the very very basic thing about JSON. So

the very very basic thing about JSON. So if I go on let's say any JSON formatter

if I go on let's say any JSON formatter website let's say I go here then in a

website let's say I go here then in a very simple sense JSON is just something

very simple sense JSON is just something like this of a structure. So you have a

like this of a structure. So you have a key let's say like this and then we have

key let's say like this and then we have a value. So we can have now key_2 to

a value. So we can have now key_2 to second key and I can have value related

second key and I can have value related to this. So this is just all the

to this. So this is just all the structure which is there in JSON. Now if

structure which is there in JSON. Now if I validate it uh let me just do it. I

I validate it uh let me just do it. I think it is uh maybe comparing that or

think it is uh maybe comparing that or something. Let me copy this and let us

something. Let me copy this and let us go back maybe to some other one.

go back maybe to some other one. validate and it is saying that okay this

validate and it is saying that okay this thing is valid the second I make any

thing is valid the second I make any problem let's say if I add one extra

problem let's say if I add one extra this it will fail so in a very simple

this it will fail so in a very simple sense this is what a JSON is now what I

sense this is what a JSON is now what I would like to do uh just so that it is

would like to do uh just so that it is clear to you let's go into our workflow

clear to you let's go into our workflow so this is where our workflow is let me

so this is where our workflow is let me zoom it in here and let's now focus and

zoom it in here and let's now focus and start with this again uh very helpful

start with this again uh very helpful for anyone who have no idea or for

for anyone who have no idea or for revising this because normally we don't

revising this because normally we don't use so much JSON programmatically. Okay.

use so much JSON programmatically. Okay. So I will be going through this quickly

So I will be going through this quickly and pretty sure that by running this

and pretty sure that by running this flow at your end as well you will be

flow at your end as well you will be able to quickly revise them as and when

able to quickly revise them as and when you pick up n or in future normity as

you pick up n or in future normity as well. So now let's see uh this workflow

well. So now let's see uh this workflow will teach you basics of JSON the

will teach you basics of JSON the language that nit uh that apps and nodes

language that nit uh that apps and nodes use to exchange information. So if and

use to exchange information. So if and if you think about this I am sending you

if you think about this I am sending you this file which is some information. So

this file which is some information. So that is the reason I am sharing a JSON

that is the reason I am sharing a JSON file with you. So I hope this makes

file with you. So I hope this makes sense that this is something which we

sense that this is something which we are also now using for sharing the

are also now using for sharing the information. Now what is a JSON? Imagine

information. Now what is a JSON? Imagine a contact card named John Doge 30 has

a contact card named John Doge 30 has children. Yes. And it has some phone

children. Yes. And it has some phone number. JSON is a way of writing this

number. JSON is a way of writing this down so a computer can understand it

down so a computer can understand it perfectly. So just like we humans are

perfectly. So just like we humans are able to communicate to communicate

able to communicate to communicate between different different applications

between different different applications uh between computers or between any

uh between computers or between any software we also have to define some uh

software we also have to define some uh way right so JSON you can think of some

way right so JSON you can think of some language in that JSON mean JavaScript

language in that JSON mean JavaScript object notation if I remember the same

object notation if I remember the same right but yes that is how it is and yeah

right but yes that is how it is and yeah it has this to do with JavaScript so

it has this to do with JavaScript so don't get any uh afraid it is still

don't get any uh afraid it is still nothing with respect to coding so as you

nothing with respect to coding so as you can see JSON is a perfect way of writing

can see JSON is a perfect way of writing this down so computing can understand

this down so computing can understand it. Now this is again the steps which

it. Now this is again the steps which are written. So we just have to execute

are written. So we just have to execute the workflow. Let me now come out of

the workflow. Let me now come out of this. Let me uh remove this. Yeah. And I

this. Let me uh remove this. Yeah. And I can click on this execute workflow on

can click on this execute workflow on which the workflow will uh will get

which the workflow will uh will get executed. So for this let's execute this

executed. So for this let's execute this and we will see if I press a zero and

and we will see if I press a zero and one that all of them has been executed

one that all of them has been executed because we have seen this that how they

because we have seen this that how they are in a uh sequence and since uh we are

are in a uh sequence and since uh we are kind of using nit only to understand

kind of using nit only to understand about something in init and I believe

about something in init and I believe that is a very nice way so let's now

that is a very nice way so let's now move forward everyone let me zoom it in

move forward everyone let me zoom it in heart of JSON key and value everything

heart of JSON key and value everything in JSON is built on this pair so as I

in JSON is built on this pair so as I shown you a key Right? And a pair a key

shown you a key Right? And a pair a key the name of the data always in double

the name of the data always in double quotes. So if you remember this is how I

quotes. So if you remember this is how I created my key this was in double quotes

created my key this was in double quotes right and then we have the value or the

right and then we have the value or the data which we want to store. So on that

data which we want to store. So on that a value the data itself. Right? So let's

a value the data itself. Right? So let's say if I want to store my name I will

say if I want to store my name I will have the key as name and may as the

have the key as name and may as the value right. So may is a string then I

value right. So may is a string then I can have let's say age in a similar

can have let's say age in a similar manner I can have age as 30. We can have

manner I can have age as 30. We can have hashts. So we will see about this as

hashts. So we will see about this as well. Right now we can see in this node

well. Right now we can see in this node output you see two key value pairs. This

output you see two key value pairs. This is the basic building block for

is the basic building block for everything that follows. So now what

everything that follows. So now what I've done everyone pay attention. I have

I've done everyone pay attention. I have just clicked on this particular node.

just clicked on this particular node. Now we have already seen that how can we

Now we have already seen that how can we go inside this using the clicking.

go inside this using the clicking. Right? Now uh just to explain you this

Right? Now uh just to explain you this key value node right. So if I uh add a

key value node right. So if I uh add a node here and I think this is known as

node here and I think this is known as uh yeah edit fields right. This is the

uh yeah edit fields right. This is the raw node which we are using. So if I

raw node which we are using. So if I just have it uh outside

just have it uh outside maybe I can delete this. Yeah. So this

maybe I can delete this. Yeah. So this is the raw node which we are using

is the raw node which we are using everyone which they have configured. So

everyone which they have configured. So if I click this

if I click this we can see that how the node can only

we can see that how the node can only receive input data if you connect it to

receive input data if you connect it to another node which makes sense and on

another node which makes sense and on that we can set this field right. So a

that we can set this field right. So a very simple example let's say this is

very simple example let's say this is kind of a information adder right? Let's

kind of a information adder right? Let's say if I'm sending something then you

say if I'm sending something then you can add or make some new things based on

can add or make some new things based on this. So we will be using this in future

this. So we will be using this in future as well. Right? So it will be a lot more

as well. Right? So it will be a lot more clear. Let me show you in the above

clear. Let me show you in the above only. When I click this you will see

only. When I click this you will see that how if I do on this schema right?

that how if I do on this schema right? We have nothing in the back right. So if

We have nothing in the back right. So if you remember this is just a simple

you remember this is just a simple manual trigger. No information nothing.

manual trigger. No information nothing. Once I go back into inside this we are

Once I go back into inside this we are having this normal variables those are

having this normal variables those are something which we already anyway knows

something which we already anyway knows that they are present. So now today

that they are present. So now today variables execution these are at a

variables execution these are at a workflow level. So we can use them right

workflow level. So we can use them right now you will see that how in a very

now you will see that how in a very similar manner if I just zoom it in a

similar manner if I just zoom it in a little bit in the input section we are

little bit in the input section we are able to see the same in a schema manner.

able to see the same in a schema manner. Right. So this is different different

Right. So this is different different ways in which we can see what all is

ways in which we can see what all is present. We can choose a table as well.

present. We can choose a table as well. Right. So I think execute through start

Right. So I think execute through start uh I have executed this 1 minute execute

uh I have executed this 1 minute execute workflow. So we can see the same in

workflow. So we can see the same in schema or in the JSON. Now as of now

schema or in the JSON. Now as of now again no data is present. So that is why

again no data is present. So that is why it is empty. In future we will be able

it is empty. In future we will be able to see the same right now you will see

to see the same right now you will see that how by doing a manual mapping and

that how by doing a manual mapping and since this is the first node where we

since this is the first node where we have to do something the initial one I

have to do something the initial one I would like to say as zerooth node

would like to say as zerooth node because it was manual trigger. We have

because it was manual trigger. We have the key and value being set. So we are

the key and value being set. So we are setting key and value. Right now this is

setting key and value. Right now this is very similar to how if I go here I just

very similar to how if I go here I just say that this is the key and this is the

say that this is the key and this is the value. I'm specifying what is the type

value. I'm specifying what is the type of my value right? So my value is of

of my value right? So my value is of type string. In a similar manner I'm

type string. In a similar manner I'm just setting this. So another key

just setting this. So another key another key and another value. So

another key and another value. So instead of value two or key2 we are

instead of value two or key2 we are using another key and another value. Let

using another key and another value. Let me go back.

me go back. Now of course once we set this uh we can

Now of course once we set this uh we can of course have other fields as well

of course have other fields as well which we can use and if I execute this

which we can use and if I execute this then this is going to provide me with

then this is going to provide me with this particular output. So that is what

this particular output. So that is what I said that it is kind of a data adder

I said that it is kind of a data adder or enricher where let's say you have the

or enricher where let's say you have the name now you are using this node to

name now you are using this node to maybe add my age as well. So the output

maybe add my age as well. So the output of this node is key and value and

of this node is key and value and another key and another value. Similarly

another key and another value. Similarly just like we had in inputs just like we

just like we had in inputs just like we had these three schema table and JSON in

had these three schema table and JSON in output we can see the same as well

output we can see the same as well right? So let me just zoom it in and

right? So let me just zoom it in and show you a little bit. Now if I go on

show you a little bit. Now if I go on table we see the same things as table.

table we see the same things as table. So it is just taking the very first one

So it is just taking the very first one as maybe the names of columns. So key

as maybe the names of columns. So key another key uh value another value.

another key uh value another value. Okay. Oh sorry my bad. uh this is

Okay. Oh sorry my bad. uh this is actually vertically key and value then

actually vertically key and value then another key another value right and in a

another key another value right and in a JSON as well so of course like ideally

JSON as well so of course like ideally they're in JSON only okay but we are

they're in JSON only okay but we are using them uh we are able to see them in

using them uh we are able to see them in a schema manner because it is easier to

a schema manner because it is easier to understand like this right so this is uh

understand like this right so this is uh one thing everyone now here you will see

one thing everyone now here you will see that how you can edit the output so if I

that how you can edit the output so if I want I can change anything here as well

want I can change anything here as well right so kind of like a quick hack

right so kind of like a quick hack through which we can edit this and maybe

through which we can edit this and maybe set it to what I

set it to what I And next we have the pin. So pin data

And next we have the pin. So pin data means that this node will always output

means that this node will always output current data instead of executing. Okay.

current data instead of executing. Okay. So I will explain you for what this

So I will explain you for what this might be required. This basically will

might be required. This basically will be required whenever we are trying to

be required whenever we are trying to test something out. So that is the

test something out. So that is the reason it says that doesn't apply to

reason it says that doesn't apply to production execution. So instead of

production execution. So instead of running everything again and again,

running everything again and again, let's say if I'm trying to get some

let's say if I'm trying to get some email and then work on that, I can just

email and then work on that, I can just pin this data. Now once this is pinned

pin this data. Now once this is pinned in a way this is the data which will

in a way this is the data which will already gets uh just passed up. So for

already gets uh just passed up. So for example just to show you if I let's say

example just to show you if I let's say have this value two as well it will not

have this value two as well it will not change here right. So if I execute this

change here right. So if I execute this maybe it will ask you testing a node

maybe it will ask you testing a node override pin data cancel or unpin and

override pin data cancel or unpin and test. So this is what it is saying that

test. So this is what it is saying that hey this is kind of in a testing mode

hey this is kind of in a testing mode you cannot change anything and this is

you cannot change anything and this is the data which I will pass on to uh in

the data which I will pass on to uh in future. So if let's say for example if

future. So if let's say for example if you got a mail now it is not that you

you got a mail now it is not that you will always be running and getting the

will always be running and getting the latest email while you are testing or

latest email while you are testing or developing something right so this is n

developing something right so this is n ways of uh dummying the data why you can

ways of uh dummying the data why you can pin this so this is going to be very

pin this so this is going to be very helpful because when we create complex

helpful because when we create complex workflows you will be pinning the data

workflows you will be pinning the data like this so with that uh for the timing

like this so with that uh for the timing I'm leaving it unpinned right that'll be

I'm leaving it unpinned right that'll be fine now let me go out and Let's go on

fine now let me go out and Let's go on to the next one. So data type string a

to the next one. So data type string a string is simply text. The text is

string is simply text. The text is always enclosed in double quotes. Look

always enclosed in double quotes. Look at the example. So if I click this, we

at the example. So if I click this, we know that how

know that how uh now uh first you if you will see

uh now uh first you if you will see here, we are able to see the key and

here, we are able to see the key and value from the last node as well because

value from the last node as well because now the whole thing is in sequence and

now the whole thing is in sequence and how I told you that the UI of nit is

how I told you that the UI of nit is pretty intuitive, right? So just like

pretty intuitive, right? So just like how it moves from left to right on our

how it moves from left to right on our canvas inside this as well it is moving

canvas inside this as well it is moving from left to right. So in the left we

from left to right. So in the left we have the inputs and on the right we will

have the inputs and on the right we will have the outputs. So we are getting this

have the outputs. So we are getting this key and another key. And here again we

key and another key. And here again we are setting the same via a JSON. So

are setting the same via a JSON. So either you can use a manual mapping here

either you can use a manual mapping here right. So I can have something like

right. So I can have something like this. If I click on keep on clicking

this. If I click on keep on clicking this. So this is more like yeah the

this. So this is more like yeah the things are kind of defined or you can

things are kind of defined or you can directly just set it via a JSON. So you

directly just set it via a JSON. So you can just directly set via a JSON. Okay.

can just directly set via a JSON. Okay. So pretty simple thing. Again if I have

So pretty simple thing. Again if I have to just show you let's say I create this

to just show you let's say I create this uh this is very much like how I'm saying

uh this is very much like how I'm saying hey either you write key and value like

hey either you write key and value like this. Okay. So provide me in a kind of

this. Okay. So provide me in a kind of field way or you just provide me the

field way or you just provide me the JSON and I will make sense of that.

JSON and I will make sense of that. Okay. So this is what manual mapping in

Okay. So this is what manual mapping in JSON is. Now again here as well if you

JSON is. Now again here as well if you see this is fixed and expression. So I

see this is fixed and expression. So I hope you remember from the last

hope you remember from the last automation we can easily drag it. If I

automation we can easily drag it. If I make it an expression. So let me make

make it an expression. So let me make expression. And now I think I can just

expression. And now I think I can just use it like this. Okay. So we will see

use it like this. Okay. So we will see that afterwards. But the idea is that we

that afterwards. But the idea is that we are able to set the type. Okay. We are

are able to set the type. Okay. We are able to set the type of our value. Now

able to set the type of our value. Now why it makes sense may because the

why it makes sense may because the values is the genuine data which we are

values is the genuine data which we are sharing and it can be in different

sharing and it can be in different different types. So I would just like to

different types. So I would just like to show you one thing. If I go on JSON

show you one thing. If I go on JSON types

types uh we can see that how JSON data types

uh we can see that how JSON data types it supports a string it supports a

it supports a string it supports a number then it supports an object. So in

number then it supports an object. So in a way a full JSON object can also be a

a way a full JSON object can also be a value. So don't get confused. We will

value. So don't get confused. We will understand this in future as well. But

understand this in future as well. But the idea is that yes the value can be

the idea is that yes the value can be itself a JSON as well. It can be an

itself a JSON as well. It can be an array. It can be a boolean. So boolean

array. It can be a boolean. So boolean is just true or false. Or it can be

is just true or false. Or it can be null. Null means nothing is there. Okay.

null. Null means nothing is there. Okay. So now what is just happening? Pretty

So now what is just happening? Pretty easy thing. We are just setting my field

easy thing. We are just setting my field one and my field two as value which is a

one and my field two as value which is a string and one which is an integer. So

string and one which is an integer. So here as well you will see the same a

here as well you will see the same a means string. This hash means number and

means string. This hash means number and we can see the same in table. Similarly

we can see the same in table. Similarly or in a JSON. So you will see that how

or in a JSON. So you will see that how of course they will match because you

of course they will match because you are giving the input as a JSON and the

are giving the input as a JSON and the output is basically getting sent and one

output is basically getting sent and one more thing to notice the subsequent

more thing to notice the subsequent nodes. Okay, I will show you in next the

nodes. Okay, I will show you in next the subsequent nodes will get the value from

subsequent nodes will get the value from all the previous nodes. So if I close

all the previous nodes. So if I close this now and let me clear this. When I

this now and let me clear this. When I go to data type number, this is simply a

go to data type number, this is simply a number. It can be a whole number like 10

number. It can be a whole number like 10 or a decimal. So both of them are

or a decimal. So both of them are supported. It is just known as a number

supported. It is just known as a number syntax just write without the quotes. So

syntax just write without the quotes. So age 30 uh this is correct. Incorrect.

age 30 uh this is correct. Incorrect. Now this 30 is different if you just pay

Now this 30 is different if you just pay attention. This 30 is a string. It's not

attention. This 30 is a string. It's not an integer in terms of in language of

an integer in terms of in language of computer. They are different. Okay. And

computer. They are different. Okay. And one more thing. So I can just have it

one more thing. So I can just have it like this and open this. Okay. So yeah

like this and open this. Okay. So yeah now I think it is using manual mapping

now I think it is using manual mapping instead of JSON. A different different

instead of JSON. A different different ways of doing the same thing. Right. And

ways of doing the same thing. Right. And this is what I was mentioning that you

this is what I was mentioning that you are getting the output from the last

are getting the output from the last node and the second last node as well.

node and the second last node as well. So a node gets the input from the all

So a node gets the input from the all the previous node and propagates its

the previous node and propagates its output along with the previous output to

output along with the previous output to all the future nodes. So yeah simply it

all the future nodes. So yeah simply it is just sending this uh like just

is just sending this uh like just setting this thing. If I see the JSON

setting this thing. If I see the JSON here I think it yeah it is also no I

here I think it yeah it is also no I have to go to manual mapping only.

have to go to manual mapping only. uh 1 minute. So I think I we can add

uh 1 minute. So I think I we can add that. So I can show you that as well.

that. So I can show you that as well. JSON example integer.

JSON example integer. I have to add value as 10. Let me make

I have to add value as 10. Let me make it uh number. Add field JSON example

it uh number. Add field JSON example float. So I actually uh mistakenly

float. So I actually uh mistakenly missed this value. So I'm just setting

missed this value. So I'm just setting this again. Okay. 12.5. Now again if you

this again. Okay. 12.5. Now again if you want you can have more values. Okay.

want you can have more values. Okay. That I think is pretty straightforward.

That I think is pretty straightforward. We can have options. Ignore type

We can have options. Ignore type conversion error. support dot notation.

conversion error. support dot notation. So this I will just explain you a little

So this I will just explain you a little bit on type conversion. Now if I talk

bit on type conversion. Now if I talk about type conversion what can happen is

about type conversion what can happen is that if you provide a string if you

that if you provide a string if you provide this 10 but let's say you

provide this 10 but let's say you provide it like this. So I'm not able to

provide it like this. So I'm not able to enter the double quotes. For example, I

enter the double quotes. For example, I select string here and I mention this

select string here and I mention this 10. So ideally it can just do the type

10. So ideally it can just do the type conversion. Okay. So let's say if I copy

conversion. Okay. So let's say if I copy this uh one which is coming up as a

this uh one which is coming up as a number I can just convert it into a

number I can just convert it into a string easily right so we can ignore

string easily right so we can ignore those error that hey this one is number

those error that hey this one is number why are you taking it as a string though

why are you taking it as a string though type conversion should be logical if I

type conversion should be logical if I now try to convert it into number it is

now try to convert it into number it is just getting deleted okay so it is not

just getting deleted okay so it is not that you can convert so what I meant the

that you can convert so what I meant the whole idea of what I meant was and you

whole idea of what I meant was and you it is not that you have the value which

it is not that you have the value which you now want to convert into a integer

you now want to convert into a integer like what will be the

like what will be the actual value of this so let's say for

actual value of this so let's say for example if I'm having may which is my

example if I'm having may which is my name you cannot convert it into an

name you cannot convert it into an integer right on the other hand you can

integer right on the other hand you can convert a integer into a string right so

convert a integer into a string right so I hope that is very easy to understand

I hope that is very easy to understand with the same understanding now let's

with the same understanding now let's move forward they are just kind of

move forward they are just kind of adding everything in uh line right so

adding everything in uh line right so let me like this is becoming like this

let me like this is becoming like this because node configuration has changed

because node configuration has changed and it is saying that hey your data

and it is saying that hey your data might get affected we something has

might get affected we something has changed here so we have made those

changed here so we have made those change right now in a similar manner it

change right now in a similar manner it is sending up the boolean so boolean is

is sending up the boolean so boolean is just true and false JSON example boolean

just true and false JSON example boolean it is sending the boolean here and it is

it is sending the boolean here and it is just false here okay so you will see

just false here okay so you will see that how again uh everything is there we

that how again uh everything is there we can see the same as table from previous

can see the same as table from previous nodes one node back two node back three

nodes one node back two node back three node back and four node back or you can

node back and four node back or you can see all as JSON. So again JSON same

see all as JSON. So again JSON same number string from which node it is

number string from which node it is coming all of these things are kind of

coming all of these things are kind of set uh like specified and I think this

set uh like specified and I think this is very good from uh your tenant because

is very good from uh your tenant because it makes it very logical and easy for

it makes it very logical and easy for everyone.

everyone. Now if I move forward similarly we have

Now if I move forward similarly we have the data type null. So the one which I

the data type null. So the one which I explained you we can have JSON example

explained you we can have JSON example null we can easily set it as null just

null we can easily set it as null just okay and again similar manner in schema

okay and again similar manner in schema it is most easier to see because

it is most easier to see because everything is available and yes it is

everything is available and yes it is based on the order as well first you had

based on the order as well first you had the string then number then boolean here

the string then number then boolean here now it is just using this JSON so it is

now it is just using this JSON so it is giving you example of different

giving you example of different different type of value okay then next

different type of value okay then next we have the array so again uh sorry my

we have the array so again uh sorry my bad yeah again in arrays we can multiple

bad yeah again in arrays we can multiple values. So if you remember array, it is

values. So if you remember array, it is just a list of different different

just a list of different different values. So if I go here everyone back, I

values. So if I go here everyone back, I can just say that okay uh let's say I

can just say that okay uh let's say I enter another value here. So it can be

enter another value here. So it can be nicknames. Okay. So let's say nickname.

nicknames. Okay. So let's say nickname. Now I can just specify my different

Now I can just specify my different different nicknames here, right? So

different nicknames here, right? So let's say I have professor. So somehow

let's say I have professor. So somehow people call me that from money heist

people call me that from money heist like maybe when I have the specs

like maybe when I have the specs everything or teacher or I can have 1 2

everything or teacher or I can have 1 2 3 okay again I know that 1 2 3 doesn't

3 okay again I know that 1 2 3 doesn't make sense but yes this is an array

make sense but yes this is an array multiple values okay so this is what an

multiple values okay so this is what an array is and it has set these values

array is and it has set these values first element to false and null and you

first element to false and null and you will see that how it has used different

will see that how it has used different different data types in an array so it

different data types in an array so it is not that it is homogeneous in nature

is not that it is homogeneous in nature this is what we use as a word in

this is what we use as a word in programming we can have different types

programming we can have different types of values in an array. Okay. Similarly,

of values in an array. Okay. Similarly, the last data type as I've already shown

the last data type as I've already shown you it is a JSON object. So if I open

you it is a JSON object. So if I open this

this now don't get confused. Let me make it a

now don't get confused. Let me make it a little bigger and let me explain you.

little bigger and let me explain you. Let me copy this and maybe we can just

Let me copy this and maybe we can just have the formatter so it will make a lot

have the formatter so it will make a lot of sense. Let me just show you in the

of sense. Let me just show you in the validator. Let me copy paste this and

validator. Let me copy paste this and let me process. See uh again this this

let me process. See uh again this this is very easy to understand like just

is very easy to understand like just they have made it uh kind of a little

they have made it uh kind of a little flat. The second I have validate and you

flat. The second I have validate and you can easily get or use this JSON uh

can easily get or use this JSON uh validator and formatter it become became

validator and formatter it become became a lot easy. It is having a key which is

a lot easy. It is having a key which is a value. So it is having a string kind

a value. So it is having a string kind of an value. Then we have an array 1 2 3

of an value. Then we have an array 1 2 3 then boolean then integer and then it is

then boolean then integer and then it is saying that hey I have a key named

saying that hey I have a key named subobject

subobject which is a JSON itself. So if I show you

which is a JSON itself. So if I show you this don't you think that this is also a

this don't you think that this is also a JSON in itself. If I just process this

JSON in itself. If I just process this this is also a JSON right? So that is

this is also a JSON right? So that is all what it was. If I process it again

all what it was. If I process it again it is all where now the value will be

it is all where now the value will be stored. So pretty pretty simple thing.

stored. So pretty pretty simple thing. It is showing you this uh the I think

It is showing you this uh the I think this is the history. Yeah. Right. So

this is the history. Yeah. Right. So subkey find me it is just a JSON as the

subkey find me it is just a JSON as the value of some key. So that thing just

value of some key. So that thing just nothing else. And you can of course keep

nothing else. And you can of course keep it like make it uh more in depth. So if

it like make it uh more in depth. So if I want I can set this value key as a

I want I can set this value key as a object again. Okay. So just we are using

object again. Okay. So just we are using on the basics. So once we have

on the basics. So once we have understood JSON in depth we can have the

understood JSON in depth we can have the value as a JSON. Okay. So if I go back

value as a JSON. Okay. So if I go back now this is what it is uh setting

now this is what it is uh setting everyone. We can see the schema it will

everyone. We can see the schema it will be easier to understand right. So this

be easier to understand right. So this is the object here where we have the key

is the object here where we have the key first then we have an array something

first then we have an array something like this then boolean then integer and

like this then boolean then integer and then subobject which is in itself a

then subobject which is in itself a JSON. Okay. So yeah with that I think

JSON. Okay. So yeah with that I think this shall be clear. uh in the setting

this shall be clear. uh in the setting it is almost the same the way we saw it

it is almost the same the way we saw it in the last automation. Let me close

in the last automation. Let me close this. And now you see that how we are

this. And now you see that how we are having so many inputs which we are

having so many inputs which we are taking. Let me close this and let's go

taking. Let me close this and let's go to the last one

to the last one using JSON in N. Now for the magic how

using JSON in N. Now for the magic how do you use data from a previous node. So

do you use data from a previous node. So if you will see we have so many of these

if you will see we have so many of these nodes where we have set up these values

nodes where we have set up these values syntax uh sorry this then this node

syntax uh sorry this then this node creates a custom message. Look at the

creates a custom message. Look at the value of the message field hello the

value of the message field hello the number from the tutorial is this. It

number from the tutorial is this. It dynamically pulled the number 10 from

dynamically pulled the number 10 from the number node. This is how you make

the number node. This is how you make your nodes talk to each other. So I will

your nodes talk to each other. So I will just tell you now what exactly is

just tell you now what exactly is happening. We have set the values. We

happening. We have set the values. We have set that okay what each node is

have set that okay what each node is setting and propagating the value

setting and propagating the value further. We now just want to use this.

further. We now just want to use this. Okay. So if I click this,

Okay. So if I click this, the idea is pretty simple. Uh pay a

the idea is pretty simple. Uh pay a little attention.

little attention. Let me add another field. Okay. Let me

Let me add another field. Okay. Let me add another field and let me say that

add another field and let me say that hey this is uh

hey this is uh this is let's say string value. Okay. So

this is let's say string value. Okay. So string value.

string value. Now with respect to n

Now with respect to n you surely will be have to using these

you surely will be have to using these values which the previous node have set.

values which the previous node have set. Right? either they can be coming from

Right? either they can be coming from your email or your Google sheet or any

your email or your Google sheet or any of the 500 apps. The idea is that every

of the 500 apps. The idea is that every app, every node will be sending the

app, every node will be sending the value in a JSON only. That is how NAN

value in a JSON only. That is how NAN communicates. If I want to talk and see

communicates. If I want to talk and see the value from the very very first

the value from the very very first field, all I can do is I can just drag

field, all I can do is I can just drag and drop this value. And once I drag and

and drop this value. And once I drag and drop it, you see the overall

drop it, you see the overall syntax as well. So I would like to talk

syntax as well. So I would like to talk a little bit inside this it is dollar

a little bit inside this it is dollar right then it is setting this node name.

right then it is setting this node name. Okay. So we can say that this is a node

Okay. So we can say that this is a node name. Okay. Then dot item dot JSON. So

name. Okay. Then dot item dot JSON. So it went inside this string. Then we are

it went inside this string. Then we are saying that hey I want to get the JSON

saying that hey I want to get the JSON item. So dot item dot JSON and then I am

item. So dot item dot JSON and then I am able to access this my field one right.

able to access this my field one right. So let us try to now write it by like

So let us try to now write it by like let us now try to see that how can we

let us now try to see that how can we get this key value and it will be a lot

get this key value and it will be a lot clear. So let me just uh have it

clear. So let me just uh have it something like here only. So let me like

something like here only. So let me like write it like this. First we will have a

write it like this. First we will have a two of these things right? We are having

two of these things right? We are having two of these curly braces. Let me just

two of these curly braces. Let me just uh zoom it in like this. Yeah, two of

uh zoom it in like this. Yeah, two of these curly braces. I want to use this

these curly braces. I want to use this key and value here. Right. So for this

key and value here. Right. So for this what I will do? I will first have dollar

what I will do? I will first have dollar sign. Then I will have this brackets.

sign. Then I will have this brackets. Okay. Now I would say key

Okay. Now I would say key and value the name of my node and it is

and value the name of my node and it is inside a inside this particular single

inside a inside this particular single quotes. Now you can see that how it is

quotes. Now you can see that how it is also suggesting the same. So I can just

also suggesting the same. So I can just select this then dot item

select this then dot item dot JSON. Once I do this dot item do

dot JSON. Once I do this dot item do JSON I am saying that hey this is the

JSON I am saying that hey this is the node in this node I want to just use

node in this node I want to just use this JSON. So the syntax is dot item

this JSON. So the syntax is dot item do.json

do.json then dot I can just get this key now and

then dot I can just get this key now and you can see that how we are getting this

you can see that how we are getting this as a value here. If I want I could have

as a value here. If I want I could have the next key which is another key

the next key which is another key another key and I got another value. So

another key and I got another value. So this language is very very important

this language is very very important either you can easily drag and drop

either you can easily drag and drop because in init

because in init right but you should know that okay how

right but you should know that okay how you have to frame this as well from

you have to frame this as well from scratch. So this is what we have

scratch. So this is what we have understood everyone. Now let me close

understood everyone. Now let me close this and of course it was string so it

this and of course it was string so it will be showing if I execute this step

will be showing if I execute this step just for you it is showing this string

just for you it is showing this string value as value and another value in JSON

value as value and another value in JSON it is inside this okay uh I could have

it is inside this okay uh I could have made this an array as well and now if I

made this an array as well and now if I execute this see what the change will be

execute this see what the change will be it is saying that okay there's an error

it is saying that okay there's an error because for array we need to have this

because for array we need to have this square brackets as well I guess right

square brackets as well I guess right now if I execute this uh gain an error

now if I execute this uh gain an error using JSON expressions

using JSON expressions but we got a value okay my bad so we

but we got a value okay my bad so we will have to set up these uh array

will have to set up these uh array values like let's see that

values like let's see that uh I have to use this thing right so if

uh I have to use this thing right so if I go here I can have it something like

I go here I can have it something like this value and maybe like what I'm doing

this value and maybe like what I'm doing is I'm just setting this

is I'm just setting this and let this I guess it will still show

and let this I guess it will still show error. No worries. Okay. So it has node

error. No worries. Okay. So it has node executed successfully and it says that

executed successfully and it says that yeah now we have the values. Okay. So

yeah now we have the values. Okay. So just it was missing that uh double

just it was missing that uh double quotes and yeah we are able to get this

quotes and yeah we are able to get this the way we want right pretty

the way we want right pretty straightforward. Uh they are string uh

straightforward. Uh they are string uh we are able to see this as well and I

we are able to see this as well and I hope now you understand about this fixed

hope now you understand about this fixed add expression. Now let's say if I have

add expression. Now let's say if I have another field and I have to add name of

another field and I have to add name of user. I could just have it as may right?

user. I could just have it as may right? It is a string here. If I execute it, it

It is a string here. If I execute it, it is all good. Right? So, pretty simple

is all good. Right? So, pretty simple thing. Uh nothing out. Uh I'm not using

thing. Uh nothing out. Uh I'm not using any logic or any dynamic value here from

any logic or any dynamic value here from schema. Let's always uh I think the

schema. Let's always uh I think the schema is a little bit helpful based on

schema is a little bit helpful based on my experience as well. So, you can use

my experience as well. So, you can use this and just have it here. Simple

this and just have it here. Simple thing, right? And yeah, if I just close

thing, right? And yeah, if I just close this now, uh the last thing is the last

this now, uh the last thing is the last to create a final object by using

to create a final object by using expression to pull data from all

expression to pull data from all previous node. I think you can do this,

previous node. I think you can do this, right? You don't need to see the result

right? You don't need to see the result as well. Click on this node and use look

as well. Click on this node and use look at the expression. If I do this then you

at the expression. If I do this then you see that how from all the previous node

see that how from all the previous node it is able to pick up the data. Now I

it is able to pick up the data. Now I think it is using some value which we

think it is using some value which we have changed. So it is from string if I

have changed. So it is from string if I go here in the string item JSON JSON

go here in the string item JSON JSON example string. So yeah we change this

example string. So yeah we change this thing right? We change this to my field

thing right? We change this to my field and my field too. So to correct this we

and my field too. So to correct this we can just say my field one and once we

can just say my field one and once we execute this we can see the answer as

execute this we can see the answer as well. So in a hindsight this is just

well. So in a hindsight this is just kind of getting these values dragging

kind of getting these values dragging and dropping this nothing else right. So

and dropping this nothing else right. So this completes your understanding that

this completes your understanding that how the data will be kind of

how the data will be kind of communicated and exchanged you

communicated and exchanged you understand about JSON in depth like how

understand about JSON in depth like how it's just a key value pair. How what are

it's just a key value pair. How what are the different different data types of

the different different data types of JSON? Okay, so they are also very very

JSON? Okay, so they are also very very important. Uh we have uh seen them. They

important. Uh we have uh seen them. They are string, number, boolean, null, array

are string, number, boolean, null, array and then object. Okay, so these are the

and then object. Okay, so these are the one which you will be dealing with.

one which you will be dealing with. Every node will be communicating with

Every node will be communicating with the next node in terms of JSON value.

the next node in terms of JSON value. Even if you have to make it dynamic,

Even if you have to make it dynamic, doesn't matter what you have to do, you

doesn't matter what you have to do, you will be using this uh understanding and

will be using this uh understanding and information. So that's why it is very

information. So that's why it is very very important. You can surely click

very important. You can surely click schma schema to see it in a better easy

schma schema to see it in a better easy to understand way. But yes uh I think

to understand way. But yes uh I think the way I've explained you it should not

the way I've explained you it should not be a problem. Either you use JSON table

be a problem. Either you use JSON table or schema. It is just one or the other

or schema. It is just one or the other way of uh telling or getting the

way of uh telling or getting the information. Right. So you can pin this

information. Right. So you can pin this as well and you can edit the same if

as well and you can edit the same if required. So I can easily just edit it

required. So I can easily just edit it and then maybe I can save and pin it for

and then maybe I can save and pin it for my testing purposes. something which we

my testing purposes. something which we will see in future right when we will be

will see in future right when we will be building complex workflows. Having this

building complex workflows. Having this understanding is very important not just

understanding is very important not just for building temp building these

for building temp building these workflows but if you do pick up a

workflows but if you do pick up a template in future how exactly will you

template in future how exactly will you be making the changes that is why this

be making the changes that is why this information is required because in very

information is required because in very very complex uh templates there will be

very complex uh templates there will be like uh 30 40 of these nodes. So if you

like uh 30 40 of these nodes. So if you know that okay how you can yourself do

know that okay how you can yourself do this you will never face this problem.

this you will never face this problem. Okay. So with that everyone, I think

Okay. So with that everyone, I think this overall intro to JSON with

this overall intro to JSON with specially focused on NA10 is completed.

specially focused on NA10 is completed. Now I think we can jump onto the next

Now I think we can jump onto the next overall uh automation and in that I will

overall uh automation and in that I will again be covering this from a lot of

again be covering this from a lot of depth so that you have a full idea that

depth so that you have a full idea that what all is happening right so let's now

what all is happening right so let's now jump on and learn about the next

jump on and learn about the next automation which is your automation to

automation which is your automation to something based on my use case like

something based on my use case like which I have genuinely used and then uh

which I have genuinely used and then uh helped the client right so again as I

helped the client right so again as I told I have picked up the use cases

told I have picked up the use cases which will be very logical to explain as

which will be very logical to explain as I

I use them in real life as well and of

use them in real life as well and of course they are very uh easy and dumb

course they are very uh easy and dumb down kind of version of that but we will

down kind of version of that but we will be seeing about APIs here so that it is

be seeing about APIs here so that it is very helpful in building complex

very helpful in building complex workflows as well so now let's move on

workflows as well so now let's move on to the next automation everyone as you

to the next automation everyone as you can see the same right in front of your

can see the same right in front of your screen I would like to first explain the

screen I would like to first explain the same in a easy to understand manner so

same in a easy to understand manner so you are able to understand that yes why

you are able to understand that yes why we might need a API here plus what is it

we might need a API here plus what is it exactly which we will be doing here

exactly which we will be doing here right so for that Let's just go and

right so for that Let's just go and create a new sheet first. So I would

create a new sheet first. So I would like to have this as JSON

like to have this as JSON uh learn or let me say learn JSON. I

uh learn or let me say learn JSON. I would like to add a tag. Let's say learn

would like to add a tag. Let's say learn here only. Not yeah learn any 10 is also

here only. Not yeah learn any 10 is also fine. Let me save everything and we can

fine. Let me save everything and we can go on the homepage. Right. Uh I can just

go on the homepage. Right. Uh I can just create a new workflow I think. Yes. So

create a new workflow I think. Yes. So this has already been created.

this has already been created. Automation 2. So we are just creating a

Automation 2. So we are just creating a new workflow with automation 2. Now

new workflow with automation 2. Now let's open a new sheets. Okay. So I'm

let's open a new sheets. Okay. So I'm just opening a new Google sheet. Again

just opening a new Google sheet. Again you could use uh any other thing as

you could use uh any other thing as well. Uh direct CSV, air table, anything

well. Uh direct CSV, air table, anything here. Uh pay attention what I will be

here. Uh pay attention what I will be doing. So the use case was that uh since

doing. So the use case was that uh since it's a real estate client what used to

it's a real estate client what used to happen and it is just one or very

happen and it is just one or very starting point of the flow. Let's say if

starting point of the flow. Let's say if I as a potential customer I would like

I as a potential customer I would like to have an ID, name, let's say number

to have an ID, name, let's say number and some budget, right? Budget. If I

and some budget, right? Budget. If I come on the website or if I'm just

come on the website or if I'm just normally inquiring about something, the

normally inquiring about something, the real estate uh firm, real estate team,

real estate uh firm, real estate team, what they can do is they can provide you

what they can do is they can provide you with better overall recommendation or

with better overall recommendation or rather they can help you better if they

rather they can help you better if they know few more things about you. Right?

know few more things about you. Right? So for example let's say this is my name

So for example let's say this is my name mayang then number can be anything 1 2 3

mayang then number can be anything 1 2 3 4 5 and budget let's say is 50k USD

4 5 and budget let's say is 50k USD ID what they wanted was that they are

ID what they wanted was that they are able to somehow guess my nationality and

able to somehow guess my nationality and gender and of course some other details

gender and of course some other details right based on let's say some more

right based on let's say some more factors this I'm taking as very initial

factors this I'm taking as very initial level of things this will be extra

level of things this will be extra bulleted to be a lot more complex and

bulleted to be a lot more complex and based on this uh just as an example

based on this uh just as an example let's say if I am an Indian they might

let's say if I am an Indian they might be able to tell me localities where more

be able to tell me localities where more Indians are right so it was an

Indians are right so it was an international client but yes this was

international client but yes this was the overall idea plus based on of course

the overall idea plus based on of course if it is a family if it is bachelor and

if it is a family if it is bachelor and different different factors they can

different different factors they can showcase and provide you with better

showcase and provide you with better overall uh potential locations right so

overall uh potential locations right so this was the idea now what we are going

this was the idea now what we are going to do here we are going to just make

to do here we are going to just make sure that we can somehow enrich or we

sure that we can somehow enrich or we can calculate this uh information. So,

can calculate this uh information. So, gender and nationality, we are able to

gender and nationality, we are able to calculate this information. That's the

calculate this information. That's the whole plan everyone. So, let's go and uh

whole plan everyone. So, let's go and uh this is what you will see in this as

this is what you will see in this as well. There will either be a trigger or

well. There will either be a trigger or we will be getting a sheet like this.

we will be getting a sheet like this. So, the sheet which we have created

So, the sheet which we have created after that that we will be creating a

after that that we will be creating a HTTP or API request. So, don't worry if

HTTP or API request. So, don't worry if you have no idea about API. We will be

you have no idea about API. We will be learning about that as well in depth.

learning about that as well in depth. Right? We will be having a sheet just

Right? We will be having a sheet just like we have one now and we will be

like we have one now and we will be enriching the sheet. Okay. So we will be

enriching the sheet. Okay. So we will be enriching that sheet and finally we can

enriching that sheet and finally we can send a email. So it can be a dynamic

send a email. So it can be a dynamic email which you can send to yourself

email which you can send to yourself that hey there seems to be a potential

that hey there seems to be a potential client. This was his name uh at age etc.

client. This was his name uh at age etc. And this is what we feel is the

And this is what we feel is the nationality gender and again you can

nationality gender and again you can make it a lot more in depth. These are

make it a lot more in depth. These are the properties which we feel might be

the properties which we feel might be good for him. we have sent him

good for him. we have sent him something. All these things can easily

something. All these things can easily be then handled or automated. Right? So

be then handled or automated. Right? So with the use case cleared now let's go

with the use case cleared now let's go and first let me connect to this

and first let me connect to this particular spreadsheet. Let me name it

particular spreadsheet. Let me name it potential

potential customers. Let us have a underscore here

customers. Let us have a underscore here as well.

as well. So let's go to our automation tool. Here

So let's go to our automation tool. Here I will now be going to Google Sheets

I will now be going to Google Sheets right because we are going to start from

right because we are going to start from Google Sheets and you can see that how

Google Sheets and you can see that how so many of the Google related

so many of the Google related technologies are there. So that point I

technologies are there. So that point I think have we have already seen Google

think have we have already seen Google Sheets here and for the time being I am

Sheets here and for the time being I am not adding it on a trigger rather I will

not adding it on a trigger rather I will be doing a

be doing a get rows in sheet. So there is a get

get rows in sheet. So there is a get rows in sheet which I'm clicking and if

rows in sheet which I'm clicking and if we zoom it out. Yeah. So we are already

we zoom it out. Yeah. So we are already being connected. Now what I can do is

being connected. Now what I can do is sheet within documents. Get rows is

sheet within documents. Get rows is something which I will be doing and

something which I will be doing and let's select the document potential

let's select the document potential customer. Okay. And we can have the

customer. Okay. And we can have the sheet one here. Right. So for the time

sheet one here. Right. So for the time being we should we don't want any filter

being we should we don't want any filter or something. And let me execute this

or something. And let me execute this node. So we don't have any node in the

node. So we don't have any node in the back. We know all these thing. Let us

back. We know all these thing. Let us execute this.

execute this. And seems like we got some information.

And seems like we got some information. So row number two ID, name, number,

So row number two ID, name, number, budget and gender and neutrality,

budget and gender and neutrality, nationality is for the timing left which

nationality is for the timing left which we will be calculating. Okay. And for

we will be calculating. Okay. And for that we ideally need some service. So I

that we ideally need some service. So I will be using an open AI open API like

will be using an open AI open API like the one which is which you can hit use

the one which is which you can hit use easily. But yeah, you could easily have

easily. But yeah, you could easily have an API which is present in the in your

an API which is present in the in your uh let's say with your logic in your

uh let's say with your logic in your application. Okay. So that is the whole

application. Okay. So that is the whole idea everyone. Now for the time being

idea everyone. Now for the time being what we have to do pay attention we have

what we have to do pay attention we have to of course first understand that man

to of course first understand that man what is this API what you are saying

what is this API what you are saying right I have very less idea what is this

right I have very less idea what is this API so even if you have an idea which I

API so even if you have an idea which I believe many of you might be having

believe many of you might be having pretty good still see the video maybe on

pretty good still see the video maybe on 2x because I will be covering a lot more

2x because I will be covering a lot more things specifically focused on nitin and

things specifically focused on nitin and if you don't have an idea then you are

if you don't have an idea then you are going to enjoy understanding about API

going to enjoy understanding about API in so much depth okay so Let's uh first

in so much depth okay so Let's uh first see that what all we are going to

see that what all we are going to understand API with. I have similarly

understand API with. I have similarly created and got another

created and got another 1 minute

1 minute [Music]

[Music] learn API.

learn API. So yeah uh we have a similar kind of a

So yeah uh we have a similar kind of a in-depth workflow via which we will be

in-depth workflow via which we will be understanding about APIs in depth right

understanding about APIs in depth right because I want that since this is the

because I want that since this is the atmax level of coding or little

atmax level of coding or little technical thing which you might have to

technical thing which you might have to do again it's not coding as such you

do again it's not coding as such you understand these things from the very

understand these things from the very start for all the future automations

start for all the future automations which we are going to create automation

which we are going to create automation or agentic workflow so first uh let us

or agentic workflow so first uh let us read a little bit about from here that

read a little bit about from here that what is this API then I will give you an

what is this API then I will give you an example

example Welcome. This workflow will teach you

Welcome. This workflow will teach you the basics of APIs. The full form is

the basics of APIs. The full form is application programming interfaces.

application programming interfaces. Okay? So don't just get hung up on the

Okay? So don't just get hung up on the applica on the full form. That should be

applica on the full form. That should be fine. What is an API? Think of it like

fine. What is an API? Think of it like ordering food at a restaurant. You are

ordering food at a restaurant. You are the client. So we customer are the

the client. So we customer are the client. The HTTP request node which is

client. The HTTP request node which is going to make the request, right? You

going to make the request, right? You want something. The kitchen is the

want something. The kitchen is the server. So kitchen is going to be the

server. So kitchen is going to be the application or the web hook node like

application or the web hook node like just avoid the web hook for now. I will

just avoid the web hook for now. I will explain you what that is. You can just

explain you what that is. You can just think of this as kitchen which is having

think of this as kitchen which is having some data which you want. It has the

some data which you want. It has the data or service you want. Okay. The API

data or service you want. Okay. The API is the waiter and the menu. It's a set

is the waiter and the menu. It's a set of rules and option you have for making

of rules and option you have for making a request and getting a response. So

a request and getting a response. So this is all what is the easiest method

this is all what is the easiest method to understand about API. Same thing you

to understand about API. Same thing you will see that I have kind of uh

will see that I have kind of uh explained and used here. So we are the

explained and used here. So we are the user here. We are the one who are the

user here. We are the one who are the user. Then this waiter is going to be

user. Then this waiter is going to be our API. Of course it will understand

our API. Of course it will understand some language. It will make sure that

some language. It will make sure that you are the right or potential customer

you are the right or potential customer like you have not already eaten, you are

like you have not already eaten, you are in the restaurant. So few things it will

in the restaurant. So few things it will also be checking right and then based on

also be checking right and then based on what you request it it is going to

what you request it it is going to transform that request to the

transform that request to the application or the kitchen and then get

application or the kitchen and then get you the response right so that is the

you the response right so that is the easiest way to understand about API and

easiest way to understand about API and this is something which is used across

this is something which is used across all the application right this is how in

all the application right this is how in like the how we are able to communicate

like the how we are able to communicate between application using uh these APIs

between application using uh these APIs in reality when you are connecting with

in reality when you are connecting with these uh uh sheets or any application

these uh uh sheets or any application some API is there in the uh back end

some API is there in the uh back end only which uh NAT has standardized that

only which uh NAT has standardized that it is you are not seeing that thing okay

it is you are not seeing that thing okay but of course it cannot have all the

but of course it cannot have all the applications just as an example if say

applications just as an example if say you have an application which you have

you have an application which you have created for your use case uh N will not

created for your use case uh N will not be aware right so you will have to

be aware right so you will have to expose an API right so for that now

expose an API right so for that now let's go everyone and let me do one

let's go everyone and let me do one thing let me let me yeah explain you

thing let me let me yeah explain you here only we will download this and I

here only we will download this and I will share the same with with you so

will share the same with with you so that we can easily just uh switch

that we can easily just uh switch between them.

between them. How to use this tutorial? Click on

How to use this tutorial? Click on execute workflow. The workflow will run

execute workflow. The workflow will run from top to bottom. Explore each lesson

from top to bottom. Explore each lesson by clicking the HTTP request node and

by clicking the HTTP request node and the corresponding web hook. Read the

the corresponding web hook. Read the sticky note for each lesson. So again

sticky note for each lesson. So again the same understanding. If you have a

the same understanding. If you have a idea about API, you can surely just see

idea about API, you can surely just see on 2x as I said but the idea is that if

on 2x as I said but the idea is that if you have no idea or if you it has been

you have no idea or if you it has been time or you have a very vague idea that

time or you have a very vague idea that hey what is headers? What is this base

hey what is headers? What is this base URL? then please keep on seeing. I

URL? then please keep on seeing. I promise you the next 15 20 minutes are

promise you the next 15 20 minutes are going to helpful in your nit journey.

going to helpful in your nit journey. Now pay attention.

Now pay attention. Uh so yeah

Uh so yeah action required for any cloud user. So

action required for any cloud user. So there is a little caveat. If you're

there is a little caveat. If you're using any cloud version the one which we

using any cloud version the one which we are using the default setting in this

are using the default setting in this node will cause an access to environment

node will cause an access to environment variable denied error. Okay. So I hope

variable denied error. Okay. So I hope you remember that how can we set the

you remember that how can we set the environment variable. This is normal and

environment variable. This is normal and easy to fix. Just follow these two

easy to fix. Just follow these two steps. Find your web hook URL. Open any

steps. Find your web hook URL. Open any web hook trigger node in this workflow

web hook trigger node in this workflow and get like the one for get menu. Copy

and get like the one for get menu. Copy the production URL. You only need the

the production URL. You only need the base part. So what do we mean by this?

base part. So what do we mean by this? Uh pay attention. Let me have a web hook

Uh pay attention. Let me have a web hook here. So web hook is just like a

here. So web hook is just like a listener just like how you have a

listener just like how you have a overall. Now if you go on this

overall. Now if you go on this production, you just have to copy this

production, you just have to copy this uh part and copy the base part. I will

uh part and copy the base part. I will see if it is required or we will make it

see if it is required or we will make it a lot easy. Update the base URL node. In

a lot easy. Update the base URL node. In this node, replace this entire

this node, replace this entire expression in the value field with the

expression in the value field with the URL you just copied. Okay. So, it is

URL you just copied. Okay. So, it is saying hey you just copy this thing. You

saying hey you just copy this thing. You only need to copy this till web hook not

only need to copy this till web hook not this /1/abc

this /1/abc all these things are not needed. So,

all these things are not needed. So, this is what we call as base URL. As an

this is what we call as base URL. As an example, google.com is the base URL.

example, google.com is the base URL. Then after slash you can have anything

Then after slash you can have anything once you search or once you search for

once you search or once you search for images or anything. Chadgpt.com is the

images or anything. Chadgpt.com is the base URL then you can have anything

base URL then you can have anything after that. So that is what we call as

after that. So that is what we call as path. So let me just do one thing. Uh

path. So let me just do one thing. Uh let's now go back in this node. Replace

let's now go back in this node. Replace the entire expression in the value field

the entire expression in the value field with the URL you just copied. So it is

with the URL you just copied. So it is saying that okay uh let me get rid of

saying that okay uh let me get rid of this uh web hook. I'm just keeping it

this uh web hook. I'm just keeping it here so that you also can do the same.

here so that you also can do the same. Let me open this. And it is saying that

Let me open this. And it is saying that okay in this node

okay in this node just environment. Hook URL it is asking

just environment. Hook URL it is asking me to change this with my URL and it

me to change this with my URL and it should also be till this point if you

should also be till this point if you understand right. So this is what it is

understand right. So this is what it is saying. Pay attention.

saying. Pay attention. This is the URL which I have like the

This is the URL which I have like the web till web hook is what is my base URL

web till web hook is what is my base URL and after that we can have tutorial and

and after that we can have tutorial and API. Okay. So let me go back. Let us

API. Okay. So let me go back. Let us save this. Let's go back and see this.

save this. Let's go back and see this. So with your URL, so your instance app,

So with your URL, so your instance app, this was what I have used Toby 12,

this was what I have used Toby 12, right? Nit and cloud web hook tutorial

right? Nit and cloud web hook tutorial API. So we have done the same thing,

API. So we have done the same thing, right? Don't forget the tutorial API

right? Don't forget the tutorial API part and you shall be done. So I will

part and you shall be done. So I will just quickly uh like rewalk you through

just quickly uh like rewalk you through what all I have done. Once you click on

what all I have done. Once you click on this, go to production URL. Copy this

this, go to production URL. Copy this completely. But we will just be needing

completely. But we will just be needing the base URL. And this is the base URL

the base URL. And this is the base URL which we have to copy. Okay, we don't

which we have to copy. Okay, we don't need the further thing because that has

need the further thing because that has to be done with this particular web hook

to be done with this particular web hook or any form or anything. So since we

or any form or anything. So since we have this, let's open this. And now what

have this, let's open this. And now what it is saying uh manual mapping settings.

it is saying uh manual mapping settings. Do we have anything as well? No, that is

Do we have anything as well? No, that is all good.

all good. Uh access to environment variable

Uh access to environment variable denied. This is the error which it was

denied. This is the error which it was saying. Uh let's see the error. And I

saying. Uh let's see the error. And I think if we execute this once uh the

think if we execute this once uh the error will go away because now we have

error will go away because now we have we are not depending on the environment

we are not depending on the environment variables. Ideally we could have set

variables. Ideally we could have set this environment variable outside just

this environment variable outside just like how we we can set my here if you

like how we we can set my here if you remember

remember I think here if I go we have this

I think here if I go we have this variables and base URL we can set but

variables and base URL we can set but shall be fine we have just done the part

shall be fine we have just done the part okay because this same will be used

okay because this same will be used afterwards. So this part is done

afterwards. So this part is done everyone. Now let's see and learn about

everyone. Now let's see and learn about APIs a little bit. So I would like to

APIs a little bit. So I would like to show you one very easy API. So um let's

show you one very easy API. So um let's say cat facts API free catf facts ninja.

say cat facts API free catf facts ninja. So now everyone you will see that how it

So now everyone you will see that how it is a page where we are just majorly

is a page where we are just majorly focused on the API. It is having like

focused on the API. It is having like multiple end points. Endpoint means what

multiple end points. Endpoint means what we can uh hit right. So just as an

we can uh hit right. So just as an example your restaurant it can have

example your restaurant it can have multiple waiters right? So one waiter

multiple waiters right? So one waiter maybe caters to the veg dishes other to

maybe caters to the veg dishes other to the non-veg dishes. So in a similar way

the non-veg dishes. So in a similar way they will be having a separate menu

they will be having a separate menu right. So if I just uh let's say see

right. So if I just uh let's say see this and write fact after this fact then

this and write fact after this fact then I will be getting a fact related to the

I will be getting a fact related to the cat. Okay. So pretty uh rhyming but the

cat. Okay. So pretty uh rhyming but the idea is that this output will be making

idea is that this output will be making a lot of sense because just in the last

a lot of sense because just in the last section we learned about JSON. Now in

section we learned about JSON. Now in this you see that how first key is fact

this you see that how first key is fact which is having a text and the second

which is having a text and the second one is length which is a integer or a

one is length which is a integer or a number kind of a thing where the length

number kind of a thing where the length is given. So the idea is pretty simple.

is given. So the idea is pretty simple. It can be as complex of a restaurant as

It can be as complex of a restaurant as it can be or it can be an easy

it can be or it can be an easy restaurant as well. So the API can be as

restaurant as well. So the API can be as complex or easy as you like. The whole

complex or easy as you like. The whole thing is that it is giving you the

thing is that it is giving you the response in a JSON format which you can

response in a JSON format which you can use. Okay. So let's go back to our uh

use. Okay. So let's go back to our uh workflow.

workflow. Now in this workflow we have configured

Now in this workflow we have configured the base URL which we have set what uh

the base URL which we have set what uh we had right now after this what we can

we had right now after this what we can do everyone pay attention. So it is uh

do everyone pay attention. So it is uh basically making these APIs for you and

basically making these APIs for you and I would like to make sure that you

I would like to make sure that you understand this. So first lesson one the

understand this. So first lesson one the basics. This is the simplest possible

basics. This is the simplest possible request. You are a uniform resource

request. You are a uniform resource locator. This is the address of

locator. This is the address of restaurant kitchen. So just like let's

restaurant kitchen. So just like let's say when you call a waiter or let's say

say when you call a waiter or let's say normally if you call a restaurant you

normally if you call a restaurant you get a number. In a similar sense your

get a number. In a similar sense your API should have a URL or a location

API should have a URL or a location through which you can reach out to it.

through which you can reach out to it. Okay.

Okay. Now here what they have done if I just

Now here what they have done if I just uh show you a little bit in depth. They

uh show you a little bit in depth. They basically have created these endpoints

basically have created these endpoints which they expect that you can hit.

which they expect that you can hit. Okay. So let me show you by going inside

Okay. So let me show you by going inside them. This is a web hook. Now web hook

them. This is a web hook. Now web hook you can just think of a mobile phone

you can just think of a mobile phone with network right. So the second I

with network right. So the second I start this web hook it will be active.

start this web hook it will be active. So it can receive calls. You can call

So it can receive calls. You can call this restaurant. Let's see this. It is

this restaurant. Let's see this. It is uh again using my uh local or my uh this

uh again using my uh local or my uh this particular URL. Okay. So

particular URL. Okay. So tobby12.app.nit.ncloud

web hook test tutorial API menu. This means that this connection is going to

means that this connection is going to get valid everyone. So once we start

get valid everyone. So once we start this connection is going to get valid.

this connection is going to get valid. It's a get request. So I will tell you

It's a get request. So I will tell you what this get request is in some time.

what this get request is in some time. Okay. And if anyone hits this then it is

Okay. And if anyone hits this then it is saying that hey response with this

saying that hey response with this mapping. So response with item pizza

mapping. So response with item pizza price 12. Okay. So what I will do now?

price 12. Okay. So what I will do now? Let me just copy this path. Let me copy

Let me just copy this path. Let me copy this path. And let me try to hit it and

this path. And let me try to hit it and seems like it is saying that hey nothing

seems like it is saying that hey nothing is found. Error 40 code 404 means that

is found. Error 40 code 404 means that nothing is found. And the error is also

nothing is found. And the error is also in JSON because we communicate in JSON.

in JSON because we communicate in JSON. That's why it is very very important.

That's why it is very very important. Well, the reason is pretty simple. I

Well, the reason is pretty simple. I should first make this connection

should first make this connection active, right? So, this is where the web

active, right? So, this is where the web hook I will have to start. So, let me do

hook I will have to start. So, let me do one thing. Let me start this web hook

one thing. Let me start this web hook and then you will see that how we will

and then you will see that how we will be able to get the data. Now, this web

be able to get the data. Now, this web hook is running everyone means this

hook is running everyone means this connection is active.

connection is active. If I go back and if I just refresh it,

If I go back and if I just refresh it, see I'm able to get item pizza

see I'm able to get item pizza and price 12. Okay, so pretty simple

and price 12. Okay, so pretty simple thing, right? We are just able to easily

thing, right? We are just able to easily get what we have set there. And this is

get what we have set there. And this is an active API now just like how this cat

an active API now just like how this cat thing was active. So it was also a

thing was active. So it was also a active API. Now if I want what I can do

active API. Now if I want what I can do is I can go here. Now since this has got

is I can go here. Now since this has got the result I would like to show you this

the result I would like to show you this web book as well. See it is having a

web book as well. See it is having a lots of detail about who hit that. So

lots of detail about who hit that. So just like if you call your number goes

just like if you call your number goes to the restaurant or if you call a

to the restaurant or if you call a waiter he also has some details about

waiter he also has some details about you. It is saying that hey user agent

you. It is saying that hey user agent was Mozilla 5.0 Macintosh Intel Mac OS.

was Mozilla 5.0 Macintosh Intel Mac OS. So again something related to my browser

So again something related to my browser or the way I'm hitting it. Then some

or the way I'm hitting it. Then some cookies then schema. Okay. Again the

cookies then schema. Okay. Again the idea is that IP address maybe all these

idea is that IP address maybe all these thing it is able to get from the single

thing it is able to get from the single call which I made. So that was pretty

call which I made. So that was pretty helpful. Now if I want I can easily

helpful. Now if I want I can easily change and add another field. Let's say

change and add another field. Let's say name and let's say I add my ink. Okay.

name and let's say I add my ink. Okay. So maybe name of the waiter. So yeah to

So maybe name of the waiter. So yeah to explain you I can be that. No worries.

explain you I can be that. No worries. Let us save this. So I have saved this.

Let us save this. So I have saved this. Now let me restart it again. And let me

Now let me restart it again. And let me now try to show you by hitting it again.

now try to show you by hitting it again. And see now we are getting the name

And see now we are getting the name mayank as well. So the idea is pretty

mayank as well. So the idea is pretty simple just like that we have a API

simple just like that we have a API which we can hit. Now what I want to

which we can hit. Now what I want to show you one more thing if I want let me

show you one more thing if I want let me just stop this thing. So this has been

just stop this thing. So this has been stopped in this customer get menu. Okay.

stopped in this customer get menu. Okay. So this IDE is going to hit and get the

So this IDE is going to hit and get the menu that is the pizza and the length.

menu that is the pizza and the length. I can show you one more thing. If we go

I can show you one more thing. If we go back and for the time being

back and for the time being let me just execute all the previous

let me just execute all the previous nodes.

nodes. This is the base URL and this is the

This is the base URL and this is the menu. So we have already seen that how

menu. So we have already seen that how the same is working. Okay. Let me do one

the same is working. Okay. Let me do one thing. Let me just use this catf fact

thing. Let me just use this catf fact ninja API instead. So all this uh web

ninja API instead. So all this uh web hook right all this sorry web hook uh

hook right all this sorry web hook uh this particular node does this

this particular node does this particular node of HTTP

particular node of HTTP all it does is that it hits the overall

all it does is that it hits the overall address with what you want. So there can

address with what you want. So there can be something there cannot be something.

be something there cannot be something. So for the timing if I just execute this

So for the timing if I just execute this uh 1 minute. Yeah. So if I just let me

uh 1 minute. Yeah. So if I just let me close this. Which one is this?

close this. Which one is this? Okay, my bad. Yeah, we were inside this.

Okay, my bad. Yeah, we were inside this. Sorry. So, just got confused. Yeah, we

Sorry. So, just got confused. Yeah, we were inside the one which I have created

were inside the one which I have created separately. So now when I execute it, I

separately. So now when I execute it, I am able to get the cat thing here. So

am able to get the cat thing here. So pretty simple thing, right? This is all

pretty simple thing, right? This is all what APIs are. You just make a call and

what APIs are. You just make a call and you get what you want in some JSON

you get what you want in some JSON format, right? So now let's move a

format, right? So now let's move a little bit forward. Customizing a

little bit forward. Customizing a request query parameters. What if you

request query parameters. What if you want to customize your order? That's

want to customize your order? That's what query parameters are for. Now what

what query parameters are for. Now what does that mean in a simple language is

does that mean in a simple language is that what if you want to send that hey

that what if you want to send that hey bring me the veg menu, bring me the

bring me the veg menu, bring me the non-veg menu, bring me the drinks menu

non-veg menu, bring me the drinks menu just like how you say to a waiter and he

just like how you say to a waiter and he gets you that menu. Right? So this is

gets you that menu. Right? So this is just where customizing thing happens.

just where customizing thing happens. Now pay attention what is happening. It

Now pay attention what is happening. It is just having uh this particular path.

is just having uh this particular path. Right? So it is this tutorial

Right? So it is this tutorial API and order. This is the path. After

API and order. This is the path. After that as of now no authentication is

that as of now no authentication is there. So VA is not checking if you have

there. So VA is not checking if you have the money or not. That may be one level

the money or not. That may be one level of authentication. Okay.

of authentication. Okay. And what it is saying let's pay

And what it is saying let's pay attention. So first entry JSON that is

attention. So first entry JSON that is all good it is responding. Now it is

all good it is responding. Now it is having an if condition. It is saying

having an if condition. It is saying JSON query extra cheese. So based on

JSON query extra cheese. So based on this uh path it is going to now return.

this uh path it is going to now return. It can be let's say respond with cheese

It can be let's say respond with cheese or respond with plane. So we can just

or respond with plane. So we can just set this thing. These are simple option

set this thing. These are simple option added to the end of your URL after a

added to the end of your URL after a question mark. So this thing is very

question mark. So this thing is very very important. They are the parameters.

very important. They are the parameters. They are key value pair used to filter

They are key value pair used to filter sort or specify what you want. Okay. So

sort or specify what you want. Okay. So in an API you after question mark can

in an API you after question mark can set that hey this is the cuisine I want.

set that hey this is the cuisine I want. simple thing just a communication

simple thing just a communication protocol is different it's like telling

protocol is different it's like telling the waiter I will have the pizza can you

the waiter I will have the pizza can you add extra cheese extra cheese is the

add extra cheese extra cheese is the query parameter okay so what we have to

query parameter okay so what we have to do pay attention here

do pay attention here uh this is the thing I can just go to

uh this is the thing I can just go to maybe uh 1 minute yeah

maybe uh 1 minute yeah in the option do we have something no we

in the option do we have something no we don't have any parameter here property

don't have any parameter here property name data no I can just get rid of this

name data no I can just get rid of this this is the URL. This is the path.

this is the URL. This is the path. Uh let me just do one thing here. Where

Uh let me just do one thing here. Where exactly is this being taken? Okay. Yeah.

exactly is this being taken? Okay. Yeah. Let me just run this. Let me run this

Let me just run this. Let me run this and I can show you this thing after

and I can show you this thing after that. So let me copy this thing. Let me

that. So let me copy this thing. Let me copy this thing

copy this thing and let me try to show what will be the

and let me try to show what will be the result. So I want it with what was the

result. So I want it with what was the path here. If I go back

path here. If I go back extra cheese. Okay. So if I specify

extra cheese. Okay. So if I specify extra

extra cheese equals true. Let's run this.

cheese equals true. Let's run this. Seems like it is saying pizza with extra

Seems like it is saying pizza with extra cheese. So it is able to read it on the

cheese. So it is able to read it on the go when I'm passing it. And if I now go

go when I'm passing it. And if I now go back, if I show you the one with cheese,

back, if I show you the one with cheese, it is going to return pizza with extra

it is going to return pizza with extra cheese. And in the

cheese. And in the 1 minute, yeah, in the parameters. So

1 minute, yeah, in the parameters. So where exactly it is getting that? Let's

where exactly it is getting that? Let's see that as well

see that as well minute.

minute. Yeah. So just let me show you on the

Yeah. So just let me show you on the previous one this if extra cheese where

previous one this if extra cheese where the condition is applied. If we see here

the condition is applied. If we see here JSON query this query is having extra

JSON query this query is having extra cheese on what I passed. Okay. So let us

cheese on what I passed. Okay. So let us try one one very quick thing. Okay. Let

try one one very quick thing. Okay. Let me start it again. Let me start it

me start it again. Let me start it again. And let's not pass extra cheese

again. And let's not pass extra cheese or something. Let's say uh order type

or something. Let's say uh order type veg. So let's see if it will fail or

veg. So let's see if it will fail or what will happen. It is giving me plain

what will happen. It is giving me plain pizza which is kind of understood. I

pizza which is kind of understood. I will tell you why. And these are very

will tell you why. And these are very important to understand. This was false.

important to understand. This was false. Okay. Because this was false, it

Okay. Because this was false, it responded with plain in the plain order

responded with plain in the plain order is plain pa. So this is what is getting

is plain pa. So this is what is getting returned. Now we have already seen JSON

returned. Now we have already seen JSON and thing. But what I wanted to show you

and thing. But what I wanted to show you here is that now in the query we have

here is that now in the query we have the order type and veg going. So this is

the order type and veg going. So this is veg right that's why it is basically

veg right that's why it is basically working like this. I can just easily

working like this. I can just easily maybe show you like this.

maybe show you like this. This is what uh we want to use. So veg

This is what uh we want to use. So veg now it was looking for extra cheese

now it was looking for extra cheese that's why it was failing but we have

that's why it was failing but we have not sent extra cheese this time right

not sent extra cheese this time right which means this failed and because it

which means this failed and because it failed it went to respond with blame. So

failed it went to respond with blame. So the idea is that yes you can send any of

the idea is that yes you can send any of these uh query parameters just like how

these uh query parameters just like how you have an options to like ask for menu

you have an options to like ask for menu etc and based on that you can have some

etc and based on that you can have some conditions. So this is all what I guess

conditions. So this is all what I guess you want to know everyone. Now let's

you want to know everyone. Now let's move on to the next one

move on to the next one sending data post and body. Now there

sending data post and body. Now there are multiple types of API or HTTP

are multiple types of API or HTTP request.

request. HTT request types.

HTT request types. So you will see that how it is having

So you will see that how it is having multiple get, post, put, patch, delete,

multiple get, post, put, patch, delete, different different types. Now this is

different different types. Now this is very straightforward. Let's say if you

very straightforward. Let's say if you are just asking for the menu, you don't

are just asking for the menu, you don't need to send anything. The waiter will

need to send anything. The waiter will get the menu. If let's say your dish is

get the menu. If let's say your dish is bad, right? If let's say I don't like

bad, right? If let's say I don't like the coffee which I'm drinking, I will

the coffee which I'm drinking, I will this time send the coffee and maybe I

this time send the coffee and maybe I will call a API or a request exchange

will call a API or a request exchange coffee. Okay. So I think this is pretty

coffee. Okay. So I think this is pretty much straightforward. If you want to pay

much straightforward. If you want to pay the bill, maybe you will send the

the bill, maybe you will send the credentials of your credit card. So or

credentials of your credit card. So or if you want to let's say delete

if you want to let's say delete something, maybe you will send a delete

something, maybe you will send a delete kind of a request. Okay? So for easy

kind of a request. Okay? So for easy categorization, your HTTP request is

categorization, your HTTP request is also divided into multiple types. Okay?

also divided into multiple types. Okay? Or multiple uh uh this basically HTTP

Or multiple uh uh this basically HTTP request methods. Now this is one method.

request methods. Now this is one method. Sometimes you don't want to get data,

Sometimes you don't want to get data, you want to send it. Method post. This

you want to send it. Method post. This method is used to send new data to the

method is used to send new data to the server. It's like handling the water to

server. It's like handling the water to a completed customer feedback card or

a completed customer feedback card or handling the waiter sorry body. This is

handling the waiter sorry body. This is the actual data you are sending. Since

the actual data you are sending. Since you are sending more complex information

you are sending more complex information than simple query param it goes in a

than simple query param it goes in a separate package called the body. So the

separate package called the body. So the whole idea is that in this particular

whole idea is that in this particular thing we are sending body as comment I

thing we are sending body as comment I am so happy. Now since we are sending

am so happy. Now since we are sending something this is not a get request this

something this is not a get request this is a post request as you can see here

is a post request as you can see here like there are multiple different ways

like there are multiple different ways of making this call. So these are a

of making this call. So these are a little bit basics they are not code as

little bit basics they are not code as such but yes if you will like to have

such but yes if you will like to have any nonavailable integration with any

any nonavailable integration with any app surely you will be using APIs and I

app surely you will be using APIs and I can show you this thing as well just to

can show you this thing as well just to quickly show you. Let's say Gmail APIs

quickly show you. Let's say Gmail APIs API documentation

API documentation Gmail API overview.

Gmail API overview. The Gmail API is a restful API that can

The Gmail API is a restful API that can be used to access Gmail inboxes and send

be used to access Gmail inboxes and send mail. So don't you think that this is

mail. So don't you think that this is something which NAT might be using after

something which NAT might be using after getting authentication which it has

getting authentication which it has provided inbuilt but yes this is

provided inbuilt but yes this is something which you can use in any of

something which you can use in any of your application. So that's the whole

your application. So that's the whole idea. you will find that how configure

idea. you will find that how configure oath consent then it is having all the

oath consent then it is having all the things which you would need. So the idea

things which you would need. So the idea is that you could do all these thing via

is that you could do all these thing via code and it just is making it a lot more

code and it just is making it a lot more easy for you to do it uh naturally by

easy for you to do it uh naturally by drag and drop. So with that everyone I'm

drag and drop. So with that everyone I'm pretty sure that you shall be a little

pretty sure that you shall be a little clear with this. Now after this this is

clear with this. Now after this this is identification where we can pass some

identification where we can pass some authentication just like let's say uh if

authentication just like let's say uh if we are sending a bill then we should be

we are sending a bill then we should be having a authentication that yes we ate

having a authentication that yes we ate then we are sending the real money and

then we are sending the real money and in lesson five it is a timeout being

in lesson five it is a timeout being added so to make sure that it is not a

added so to make sure that it is not a very uh heavy for the waiter your waiter

very uh heavy for the waiter your waiter may wait it just normally say hey wait

may wait it just normally say hey wait I'm just completing one request then I

I'm just completing one request then I will come to you so that is what it is

will come to you so that is what it is saying uh that this time we are having a

saying uh that this time we are having a 3second delay

3second delay So the result will come after three

So the result will come after three time. So that's why it is get slow

time. So that's why it is get slow service. Okay. So it will wait three uh

service. Okay. So it will wait three uh second and it will come to you. This is

second and it will come to you. This is something which you will also see when

something which you will also see when you uh use an API which is very heavy.

you uh use an API which is very heavy. Uh normally when you uh use a website

Uh normally when you uh use a website let's say on our result day that is

let's say on our result day that is where it takes a lot of time. So this is

where it takes a lot of time. So this is the reason. Okay. So yeah, I guess this

the reason. Okay. So yeah, I guess this uh level of understanding or knowledge

uh level of understanding or knowledge for APIs is a lot for the easy

for APIs is a lot for the easy understanding just you are using it to

understanding just you are using it to get something get your data in a JSON or

get something get your data in a JSON or you can post or put this uh workflow if

you can post or put this uh workflow if you will go through I think that shall

you will go through I think that shall be more than enough just run this web

be more than enough just run this web hook and try to hit this manually. Okay,

hook and try to hit this manually. Okay, because that is the easiest way. Or else

because that is the easiest way. Or else what you will have to do, you will have

what you will have to do, you will have to create a separate workflow. Make this

to create a separate workflow. Make this web hove active and then run this

web hove active and then run this particular path because only a single

particular path because only a single workflow can be run via a simple uh

workflow can be run via a simple uh single uh in a sing in this workflow.

single uh in a sing in this workflow. This can be run both of them cannot be

This can be run both of them cannot be run. Okay. So with that now let's move

run. Okay. So with that now let's move forward everyone. And what I wanted to

forward everyone. And what I wanted to do let's go back to our problem. If you

do let's go back to our problem. If you remember this was the problem which we

remember this was the problem which we were solving

were solving where I have the ID, I have the name,

where I have the ID, I have the name, number, budget, then I want gender and

number, budget, then I want gender and nationality. Okay. So why I made you

nationality. Okay. So why I made you walk through API? Because if you search

walk through API? Because if you search free API, no sign up, right? Then go to

free API, no sign up, right? Then go to this link EPF free API like this is what

this link EPF free API like this is what you will see after you search for this

you will see after you search for this and it has many of these APIs like we

and it has many of these APIs like we saw the catfact API. Okay, it is from a

saw the catfact API. Okay, it is from a different uh I guess link but these APIs

different uh I guess link but these APIs they don't want any authentication. So

they don't want any authentication. So for example when NA10 is connecting to

for example when NA10 is connecting to your Gmail it is having the

your Gmail it is having the authentication that is why it is able to

authentication that is why it is able to do that else tomorrow anyone will come

do that else tomorrow anyone will come and just update that right now you are

and just update that right now you are able to go to a restaurant because let's

able to go to a restaurant because let's say they let you in maybe you are

say they let you in maybe you are showing some reservation right without

showing some reservation right without reservation they don't do that in a

reservation they don't do that in a similar manner this is what your uh

similar manner this is what your uh authentication is so think of this as

authentication is so think of this as showing your VIP card or whispering a

showing your VIP card or whispering a secret password to the waiter in a

secret password to the waiter in a similar sense these APIs they don't need

similar sense these APIs they don't need any of those authentication. So for the

any of those authentication. So for the testing purpose it is pretty good but

testing purpose it is pretty good but ideally I would want that yes my API

ideally I would want that yes my API should have some authentication just

should have some authentication just like Gmail ask you to do ooth 2 via any

like Gmail ask you to do ooth 2 via any okay now uh these are the two which we

okay now uh these are the two which we are going to use everyone now here you

are going to use everyone now here you will see if I just open this one

will see if I just open this one API genderize okay so this is a free API

API genderize okay so this is a free API which you can use

which you can use in this you can pass any parameter if

in this you can pass any parameter if you remember I just showed you this

you remember I just showed you this parameter so if I let's say pass may

parameter so if I let's say pass may it gives me that hey this is a male

it gives me that hey this is a male probability is one so it is gender it is

probability is one so it is gender it is telling the gender of the person via

telling the gender of the person via name now again it can be wrong as well

name now again it can be wrong as well but the idea is that yes it is giving

but the idea is that yes it is giving you that probability okay in a similar

you that probability okay in a similar manner this nationalize if I open it is

manner this nationalize if I open it is also a get API everyone now this is

also a get API everyone now this is giving me the nationality so if I do

giving me the nationality so if I do pretty print and let's just search for a

pretty print and let's just search for a name may

name may it is giving me the nationality that hey

it is giving me the nationality that hey seems like 40% there is a chance it's an

seems like 40% there is a chance it's an Indian I think in is India only LC I'm

Indian I think in is India only LC I'm not sure honestly we will have to go to

not sure honestly we will have to go to this uh link and check for the

this uh link and check for the country ID etc so okay it is saying that

country ID etc so okay it is saying that nationalizio so nationalize

nationalizio so nationalize io yeah nationalizio

io yeah nationalizio here again they would have listed that

here again they would have listed that if like this is a nice way of doing

if like this is a nice way of doing this. If I search like this, maybe it

this. If I search like this, maybe it will show me in a better graphical way.

will show me in a better graphical way. But in the back end APIs are only

But in the back end APIs are only running, right? So

running, right? So I guess if I go on API docs, it should

I guess if I go on API docs, it should be able to tell me the country ID,

be able to tell me the country ID, right? So yeah, I think there's agi.co

right? So yeah, I think there's agi.co as well, estimate age from names and

as well, estimate age from names and nationaliz.io. So these are the few

nationaliz.io. So these are the few things which we can use. Now I can just

things which we can use. Now I can just go to API docs and basically these are

go to API docs and basically these are documentation through which you can

documentation through which you can understand. Now why am I showing you all

understand. Now why am I showing you all this? Because if you use any of the

this? Because if you use any of the application or any of the integration

application or any of the integration which Nit has done, you will find

which Nit has done, you will find documentation there. And for nonpresent

documentation there. And for nonpresent authentication, you will have to know

authentication, you will have to know about these documentation. Okay. So just

about these documentation. Okay. So just as an example, let's say if we go on n

as an example, let's say if we go on n okay and normally notion is also there.

okay and normally notion is also there. So I can do notion notion API

So I can do notion notion API and here all the things about notions

and here all the things about notions are there. We can have the API reference

are there. We can have the API reference as well or some documentation. So this

as well or some documentation. So this is kind of like a documentation only.

is kind of like a documentation only. Okay. So this thing is very very

Okay. So this thing is very very important if you want to build system

important if you want to build system which are actually robust and which are

which are actually robust and which are useful. Now you can see many tutorials

useful. Now you can see many tutorials where they would be directly using it

where they would be directly using it but I wanted to tell you the use case

but I wanted to tell you the use case the understanding so you can use it for

the understanding so you can use it for other things as well. Now let's get back

other things as well. Now let's get back everyone and I will be closing this.

everyone and I will be closing this. Now we know that we have to make two

Now we know that we have to make two calls. So I will be selecting HTTP here

calls. So I will be selecting HTTP here and doing a HTTP call here. The base URL

and doing a HTTP call here. The base URL everyone will be this genderized. Let me

everyone will be this genderized. Let me just copy this. This is what the URL is.

just copy this. This is what the URL is. Okay. Now I can select this send query

Okay. Now I can select this send query parameter and I can maybe do it like

parameter and I can maybe do it like this. So pay attention. I can maybe have

this. So pay attention. I can maybe have a name here and value. I would now like

a name here and value. I would now like to drag and drop like this. So see if I

to drag and drop like this. So see if I execute this. We can just quickly check

execute this. We can just quickly check if this will work or not.

And it is executing. Have we missed something? Doesn't seem like

something? Doesn't seem like maybe the request this makes s okay. Oh,

maybe the request this makes s okay. Oh, should not take that much time. Let me

should not take that much time. Let me do one thing. Let us stop this. Maybe

do one thing. Let us stop this. Maybe stop it. Okay,

stop it. Okay, let me don't send any query. Okay, it

let me don't send any query. Okay, it was able to get the answer. I guess

was able to get the answer. I guess maybe it was okay, let me hit it

maybe it was okay, let me hit it quickly.

Okay, let it run. It shall be easily able to get this answer. So, it did get

able to get this answer. So, it did get the answer but not sure why it is not

the answer but not sure why it is not stopping. You can the raw request this

stopping. You can the raw request this node makes in your browser development

node makes in your browser development console should be fine. Nothing setting

console should be fine. Nothing setting related is there.

related is there. Hm strange. So let me refresh this.

Hm strange. So let me refresh this. Maybe uh we have missed out on

Maybe uh we have missed out on something. Let me save it first.

something. Let me save it first. So it is showing right like it is

So it is showing right like it is successful but not sure that why it is

successful but not sure that why it is not getting updated. Okay. So we will do

not getting updated. Okay. So we will do one thing. No worries. Let me close

one thing. No worries. Let me close this. And again you can also face these

this. And again you can also face these kind of errors. Not cutting anything.

kind of errors. Not cutting anything. Now if I execute workflow, it is

Now if I execute workflow, it is running. It is getting the data and yes

running. It is getting the data and yes everything is fine now. Okay. So we are

everything is fine now. Okay. So we are able to see that how I got the message.

able to see that how I got the message. Now in a similar manner I will be having

Now in a similar manner I will be having another request HTTP

another request HTTP request

request and I will be making a nationalized call

and I will be making a nationalized call right this is the one which I will be

right this is the one which I will be making here I would like to send it as a

making here I would like to send it as a query parameter. So let me do name and

query parameter. So let me do name and let me send the value as may because see

let me send the value as may because see the idea is that I cannot send this uh

the idea is that I cannot send this uh name I cannot uh just hard write or

name I cannot uh just hard write or override this name. This should be not

override this name. This should be not fixed right. So let me get rid of this.

fixed right. So let me get rid of this. Now if I execute this step

Now if I execute this step see easily we are able to get it. I

see easily we are able to get it. I would like to have one more thing here.

would like to have one more thing here. So I would like to have another call

So I would like to have another call here.

here. Uh ideally if you want you can also

Uh ideally if you want you can also parallelize the flow. So something like

parallelize the flow. So something like let's say if I have just a second to

let's say if I have just a second to show you I can have HTTP request here

show you I can have HTTP request here and I can maybe connect them and make

and I can maybe connect them and make them parallel right so we can have them

them parallel right so we can have them in parallel as well right but I am just

in parallel as well right but I am just showing you this in uh sequence shall be

showing you this in uh sequence shall be great so I would like to have another

great so I would like to have another one the AG51 which we saw so HTTP

one the AG51 which we saw so HTTP request now if I go back

request now if I go back I think it was Agi. Let me check it.

I think it was Agi. Let me check it. Agi.io

Agi.io name. I hope it gives my age fine.

name. I hope it gives my age fine. Okay, 40 way way off but should be fine.

Okay, 40 way way off but should be fine. So yeah, this is some more thing which

So yeah, this is some more thing which we can use everyone. Now just one thing

we can use everyone. Now just one thing uh there can be multiple APIs, right? It

uh there can be multiple APIs, right? It is not a problem I guess for you because

is not a problem I guess for you because again your restaurant can be as easy as

again your restaurant can be as easy as just giving you a single thing or it can

just giving you a single thing or it can give you maybe arrays or multiple object

give you maybe arrays or multiple object etc of data but at the end of the day if

etc of data but at the end of the day if you are good with JSON which I now know

you are good with JSON which I now know that you are you shall easily be able to

that you are you shall easily be able to handle it. Okay. So just for an example

handle it. Okay. So just for an example if I run this API it is saying not

if I run this API it is saying not found.

found. Maybe if I run this API so it is giving

Maybe if I run this API so it is giving us so many things. See there's an object

us so many things. See there's an object inside this there's a longitude langu uh

inside this there's a longitude langu uh latitude all these things are present

latitude all these things are present okay so if I just run it maybe for 5 6 0

okay so if I just run it maybe for 5 6 0 0 1

0 1 let's see okay so I think this is for us

let's see okay so I think this is for us only maybe

only maybe yeah so yeah this is for I think US only

yeah so yeah this is for I think US only should be fine so the idea now is that

should be fine so the idea now is that you can easily run any of the API my aim

you can easily run any of the API my aim here is to not show you the most

here is to not show you the most advanced API or something although So

advanced API or something although So there can be those but you should be

there can be those but you should be comfortable that yes I have to hit API

comfortable that yes I have to hit API and if you hit it you are getting the

and if you hit it you are getting the data. Now if we go back onto our uh

data. Now if we go back onto our uh workflow here I can have the AG51 in a

workflow here I can have the AG51 in a similar manner. I would like to have

similar manner. I would like to have query parameters name and I will drag

query parameters name and I will drag and drop this. Okay.

and drop this. Okay. And I can just quickly check this if

And I can just quickly check this if this is hitting. Seems like it is able

this is hitting. Seems like it is able to hit and give me the answer. Now just

to hit and give me the answer. Now just let us correct this as well. Let us be

let us correct this as well. Let us be little good in sending this name and let

little good in sending this name and let me drag and drop it. Okay, let's get rid

me drag and drop it. Okay, let's get rid of this because uh there will be then

of this because uh there will be then multiple parameters which I don't want.

multiple parameters which I don't want. Execute.

Execute. Seems like it is working. Okay, so now

Seems like it is working. Okay, so now we have some extra information. If I go

we have some extra information. If I go back, we are able to load a sheet. Then

back, we are able to load a sheet. Then we have the API request as well. Ideally

we have the API request as well. Ideally it should be inside this but uh again we

it should be inside this but uh again we are just reading this and I will tell

are just reading this and I will tell you how I have made it a trigger based

you how I have made it a trigger based so we will be doing that as well. Now

so we will be doing that as well. Now enrich sheet and this. So I just have to

enrich sheet and this. So I just have to my sheet. For doing that what I will do?

my sheet. For doing that what I will do? I will have another node here. Everyone

I will have another node here. Everyone node I will have this as sheet Google

node I will have this as sheet Google sheets.

sheets. I would say append or update a row in a

I would say append or update a row in a sheet. So let's select that.

sheet. So let's select that. Now again s we have already connected to

Now again s we have already connected to this. I just want to select my document

this. I just want to select my document potential customer and I want to select

potential customer and I want to select the first sheet. Okay. So these are all

the first sheet. Okay. So these are all the things which I'm using.

the things which I'm using. Now let me go back to my sheet here. Let

Now let me go back to my sheet here. Let me add age as well because now we have

me add age as well because now we have the age information as well. Right? So

the age information as well. Right? So if I go back it will most probably show

if I go back it will most probably show some error here. See so this is very

some error here. See so this is very important. Anytime you make any changes

important. Anytime you make any changes now in the back end you will have to in

now in the back end you will have to in a way make another call of API. This

a way make another call of API. This also in the back end is an API call just

also in the back end is an API call just like it is showing you like this right

like it is showing you like this right because as I said on the internet JSON

because as I said on the internet JSON is the way through which you uh just

is the way through which you uh just exchange the data and via API is how we

exchange the data and via API is how we hit to the service. Now again there can

hit to the service. Now again there can be different protocol uh just like let's

be different protocol uh just like let's say we have swiggy or zumato or any door

say we have swiggy or zumato or any door dash or any service to order but still

dash or any service to order but still the data will be in JSON. So let me

the data will be in JSON. So let me refresh it and seems like it has got age

refresh it and seems like it has got age as well. Okay.

as well. Okay. So now it is first asking me column to

So now it is first asking me column to match on. Let me first run all the

match on. Let me first run all the previous node. Okay. So let's run this.

previous node. Okay. So let's run this. All the previous node has been ran. Now

All the previous node has been ran. Now everyone we see few things here. Okay.

everyone we see few things here. Okay. Get row in sheet and everything. Now

Get row in sheet and everything. Now what I want first is ID. So it is saying

what I want first is ID. So it is saying that hey I am matching the row with this

that hey I am matching the row with this ID. So all it is saying is that hey this

ID. So all it is saying is that hey this ID is via which I am matching the row.

ID is via which I am matching the row. So I should use this ID here only

So I should use this ID here only everyone. Now I should use this name.

everyone. Now I should use this name. Now you can again if you want you can

Now you can again if you want you can easily write it down as well. You can

easily write it down as well. You can rename this particular node. You can

rename this particular node. You can write it down. I know that all of you

write it down. I know that all of you are so smart because we have just seen

are so smart because we have just seen in the last section. After this I can

in the last section. After this I can have number. So let me have a number.

have number. So let me have a number. Then I can have budget here. So ideally

Then I can have budget here. So ideally what we are doing is to avoid any

what we are doing is to avoid any problem we are just updating them again.

problem we are just updating them again. Okay. Then I can have a gender. So

Okay. Then I can have a gender. So gender is not from here. Gender I got

gender is not from here. Gender I got from this API gender.

from this API gender. Okay. I can have the what is the last

Okay. I can have the what is the last one? This is the gender.

one? This is the gender. This is the age.

This is the age. But now the nationality is a problem

But now the nationality is a problem because here we have a list. Okay. So

because here we have a list. Okay. So yes you can easily drag and drop it

yes you can easily drag and drop it down. But I would like to show you few

down. But I would like to show you few more things here. Everyone pay

more things here. Everyone pay attention. So I have created another

attention. So I have created another very nice. So I'm saving this another

very nice. So I'm saving this another very nice uh such workflow here

very nice uh such workflow here which was in the template. So yeah this

which was in the template. So yeah this is the no this is not the one this is

is the no this is not the one this is the API one this one.

the API one this one. So now what happens everyone is that

So now what happens everyone is that when you are in NAN and since you are

when you are in NAN and since you are working with this uh expression kind of

working with this uh expression kind of a thing right it supports uh some

a thing right it supports uh some functions some easy way of doing things.

functions some easy way of doing things. So what do I mean by this is pay

So what do I mean by this is pay attention. Now for the nationality what

attention. Now for the nationality what I can do is I can do something like this

I can do is I can do something like this dollar then I can have http request one

dollar then I can have http request one dot item dot json. This is something

dot item dot json. This is something which we already know we have seen the

which we already know we have seen the same in depth. After this I would like

same in depth. After this I would like to go inside country. So dot country

to go inside country. So dot country is a separate object. I hope you

is a separate object. I hope you remember this. Let me show you this in

remember this. Let me show you this in JSON for yeah see this is a separate

JSON for yeah see this is a separate object altogether.

object altogether. Now in this country I could have the

Now in this country I could have the first one. So there you will see many

first one. So there you will see many many functions here right? See I could

many functions here right? See I could get the length which is going to be

get the length which is going to be five. Uh I guess there are five right?

five. Uh I guess there are five right? See it is giving me five. Then I can

See it is giving me five. Then I can have last. So it is giving me this BH I

have last. So it is giving me this BH I think Bhutan. But the idea is I want to

think Bhutan. But the idea is I want to use first right? See this will give me

use first right? See this will give me the country which is present and I guess

the country which is present and I guess that makes a lot of sense because first

that makes a lot of sense because first is the country with the maximum

is the country with the maximum probability.

probability. So this way of getting the data this is

So this way of getting the data this is what I've explained in this particular

what I've explained in this particular uh workflow everyone in this if you will

uh workflow everyone in this if you will pay attention what we are doing. It is

pay attention what we are doing. It is saying that now welcome you know what

saying that now welcome you know what JSON is now let's learn how to use it.

JSON is now let's learn how to use it. So this template is present in the init

So this template is present in the init template gallery only. Okay, I plan to

template gallery only. Okay, I plan to create this just like I created the one

create this just like I created the one for nodes which you have used. But then

for nodes which you have used. But then I thought that yes, a pretty nice

I thought that yes, a pretty nice template is present. So let's go through

template is present. So let's go through it. And expression is a small piece of

it. And expression is a small piece of code inside doubly curly braces. Now

code inside doubly curly braces. Now don't again be uh like don't turn away.

don't again be uh like don't turn away. It's not still code code. It's just a

It's not still code code. It's just a way of writing or accessing things

way of writing or accessing things nicely. The data gets replaced with a

nicely. The data gets replaced with a dynamic value when the workflow runs. So

dynamic value when the workflow runs. So we already know this thing. I have shown

we already know this thing. I have shown you that it's the glue that connect your

you that it's the glue that connect your nodes. So it is all it is saying is that

nodes. So it is all it is saying is that hey using this double quote and if you

hey using this double quote and if you write this expression here it is going

write this expression here it is going to get you some data. We have already

to get you some data. We have already seen this thing right. Let me run this

seen this thing right. Let me run this full flow so that everything is there.

full flow so that everything is there. Now it is saying that hey this is our

Now it is saying that hey this is our data source. So you can see the same in

data source. So you can see the same in JSON.

JSON. Uh more or less each and every type of

Uh more or less each and every type of data is present here. Alice 30 is active

data is present here. Alice 30 is active boolean number. then it is an object

boolean number. then it is an object uh sorry it is an array not an object my

uh sorry it is an array not an object my bad it is an array then it is a uh array

bad it is an array then it is a uh array of objects so this one is array of

of objects so this one is array of objects everyone if you will pay

objects everyone if you will pay attention this is from here to here so

attention this is from here to here so we just don't have a single object here

we just don't have a single object here we have array of options something

we have array of options something similar we had here as well right so in

similar we had here as well right so in this as well you see this is an array of

this as well you see this is an array of objects it start with a square bracket

objects it start with a square bracket not directly with a curly braces okay So

not directly with a curly braces okay So since this is array of objects, it is

since this is array of objects, it is just showing that how can you access it.

just showing that how can you access it. So this is the data through which it is

So this is the data through which it is explained. Let's go forward and again I

explained. Let's go forward and again I will be sharing this with you. So please

will be sharing this with you. So please go through this. It is going to be very

go through this. It is going to be very helpful and it is a lot

helpful and it is a lot self-explanatory. I want that you spend

self-explanatory. I want that you spend time in working on this. Okay. Now all

time in working on this. Okay. Now all it is saying is the same thing which I

it is saying is the same thing which I showed you that hey to get this get this

showed you that hey to get this get this name we know that how we will be

name we know that how we will be constructing that right? Pay attention.

constructing that right? Pay attention. We will be doing something like this.

We will be doing something like this. Then dollar then we select source data.

Then dollar then we select source data. After that item then JSON

After that item then JSON and after that we know that we have to

and after that we know that we have to get the name and we can easily get our

get the name and we can easily get our name right. So for this I think it was

name right. So for this I think it was name only. Yeah. And I can run this 1

name only. Yeah. And I can run this 1 minute and if I execute this step node

minute and if I execute this step node is executed successfully. Username is

is executed successfully. Username is the name. In a similar manner, it will

the name. In a similar manner, it will show you that how can you do first, last

show you that how can you do first, last and all. Let us open this.

and all. Let us open this. Inside this, it is saying username from

Inside this, it is saying username from first. So if I go on this source data,

first. So if I go on this source data, then where is it trying to get that

then where is it trying to get that source data last

source data last JSON name? Let me execute this step.

JSON name? Let me execute this step. Okay, so it is also again it is just

Okay, so it is also again it is just saying that from last user source data.

saying that from last user source data. Now if we would have multiple things

Now if we would have multiple things here then it would have first last

here then it would have first last something like this for example here

something like this for example here this is my first country everyone this

this is my first country everyone this is the first country I have then this is

is the first country I have then this is the last country if I would have had

the last country if I would have had only one country then that is the first

only one country then that is the first that is the last so it is saying that

that is the last so it is saying that hey in this last one okay in this from

hey in this last one okay in this from this source data last JSON and file I

this source data last JSON and file I think if I do first here as well it will

think if I do first here as well it will give me the same answer because first

give me the same answer because first and R star same let's run this and yeah

and R star same let's run this and yeah it is giving me the same answer okay so

it is giving me the same answer okay so we are going first then JSON then name

we are going first then JSON then name so source data it gets the first one

so source data it gets the first one which is this then JSON and then name so

which is this then JSON and then name so again just these expressions are there

again just these expressions are there where we have multiple functions now you

where we have multiple functions now you can easily run about these function but

can easily run about these function but I believe that they are a little little

I believe that they are a little little bit advanced right so once you are have

bit advanced right so once you are have comfortable with this thing then you can

comfortable with this thing then you can easily do that then it is showing that

easily do that then it is showing that how can you access array elements. So

how can you access array elements. So for example here now we have an array

for example here now we have an array like this. So this skills in an array

like this. So this skills in an array here you can specify that what you want.

here you can specify that what you want. Okay. So for example if I run this it is

Okay. So for example if I run this it is saying skills one. Pay attention here.

saying skills one. Pay attention here. It is saying skills one. So this skills

It is saying skills one. So this skills one correspond to Python. Okay pay

one correspond to Python. Okay pay attention. If I do skills zero and

attention. If I do skills zero and execute we will get JavaScript.

execute we will get JavaScript. Now pause the video and tell me what we

Now pause the video and tell me what we will get if I do uh skills two

will get if I do uh skills two and we get nit. What we could also do is

and we get nit. What we could also do is dot now you can see that first

dot now you can see that first and if I run this now we get JavaScript.

and if I run this now we get JavaScript. So I hope you're able to understand that

So I hope you're able to understand that how exactly this thing is working and we

how exactly this thing is working and we have multiple uh functions like this.

have multiple uh functions like this. They are kind of very nicely explained.

They are kind of very nicely explained. length, last,

length, last, includes, map, filter. Okay, so these

includes, map, filter. Okay, so these are some functions which are there again

are some functions which are there again can be used for the library but shall be

can be used for the library but shall be fine if you don't have an idea about

fine if you don't have an idea about that for the time being. Okay. So there

that for the time being. Okay. So there are many many things which you can use

are many many things which you can use here. Uh unique uh union sort all these

here. Uh unique uh union sort all these things we can easily use right but for

things we can easily use right but for the time being I think the one which I'm

the time being I think the one which I'm sharing that is more than enough with

sharing that is more than enough with time when future automations I will show

time when future automations I will show and use the complex function as well.

and use the complex function as well. Okay

Okay dot uh let's say maybe first only I can

dot uh let's say maybe first only I can dot first

dot first and again there is no no like second

and again there is no no like second third. I hope you understand why because

third. I hope you understand why because the list is very long uh like it will

the list is very long uh like it will not be 999

not be 999 then,000. So that's why first last and

then,000. So that's why first last and else you can specify what you want. So

else you can specify what you want. So this was accessing an array element.

this was accessing an array element. Now it is showing how you can access

Now it is showing how you can access nested data. Okay. So let me show you

nested data. Okay. So let me show you this as well. Now this is trying to

this as well. Now this is trying to access uh source data

access uh source data in the contact. So again I think this is

in the contact. So again I think this is also very easy. We could just use item

also very easy. We could just use item here as well. Once you select contact,

here as well. Once you select contact, then you can do a dot here and select

then you can do a dot here and select that what you want. So I can do either

that what you want. So I can do either have a name, right? So what is there in

have a name, right? So what is there in contact? Email. My bad. So I could have

contact? Email. My bad. So I could have a email here or I could have a phone

a email here or I could have a phone here. So just easily you are able to

here. So just easily you are able to access this email or phone. Okay. In a

access this email or phone. Okay. In a very simple sense. Uh next it will show

very simple sense. Uh next it will show that how can you access inside this

that how can you access inside this array of object. I hope that is very

array of object. I hope that is very easily understood to you as well.

easily understood to you as well. Accessing data in array of object. So if

Accessing data in array of object. So if I now go inside this source data last

I now go inside this source data last JSON projects zero. So projects let me

JSON projects zero. So projects let me close everything else or let me go to

close everything else or let me go to this JSON

this JSON source data. In this project we have two

source data. In this project we have two projects.

projects. This is the first project or project

This is the first project or project zero. So uh normally in programming we

zero. So uh normally in programming we follow zero indexing. Okay. So counting

follow zero indexing. Okay. So counting start from zero. That is why we see that

start from zero. That is why we see that how here we have projects 0 dot status.

how here we have projects 0 dot status. So again it is very simple. Uh till here

So again it is very simple. Uh till here if I just select projects pay attention

if I just select projects pay attention till here I will get the full uh full as

till here I will get the full uh full as it is in schema. Right? So I'm getting

it is in schema. Right? So I'm getting the full overall

the full overall my object. Okay. If I do projects dot

my object. Okay. If I do projects dot first now I get a I will have to add a

first now I get a I will have to add a comma or this brackets here. Now I get

comma or this brackets here. Now I get the first object which is this. And from

the first object which is this. And from this if I want to get let's say status

this if I want to get let's say status then I can do status. So again just we

then I can do status. So again just we are expanding the logic nothing very

are expanding the logic nothing very difficult and I will get the status

difficult and I will get the status done. Now in the last a touch of magic.

done. Now in the last a touch of magic. So this is what I was saying everyone.

So this is what I was saying everyone. JSON functions. You can do more than

JSON functions. You can do more than just retrieve data. You can manipulate

just retrieve data. You can manipulate and inspect it. So this is where your JS

and inspect it. So this is where your JS functions came into picture. So as I

functions came into picture. So as I showed you first and second they are

showed you first and second they are first and last. They are functions which

first and last. They are functions which you can work. Transform text source data

you can work. Transform text source data last JSON name to uppercase. Okay. So it

last JSON name to uppercase. Okay. So it will trans transform it. Do math then we

will trans transform it. Do math then we can use math.round round and we can use

can use math.round round and we can use something like this then check data type

something like this then check data type we can just have type of and then

we can just have type of and then whatever we are sending now again I

whatever we are sending now again I would highly highly suggest just go

would highly highly suggest just go through this thing I am pretty sure you

through this thing I am pretty sure you will be able to understand it and yes as

will be able to understand it and yes as we will go and inside more automations

we will go and inside more automations we will learn this in depth as well so

we will learn this in depth as well so here just they are doing the same thing

here just they are doing the same thing it is getting this in uh your upper case

it is getting this in uh your upper case so this you are getting in JSON age so

so this you are getting in JSON age so the idea is pretty simple we are just we

the idea is pretty simple we are just we are just manipulating the data by using

are just manipulating the data by using the inbuilt JSON function nothing else.

the inbuilt JSON function nothing else. Okay. So with that everyone let me close

Okay. So with that everyone let me close this and now you will see inspecting

this and now you will see inspecting object as well. So how we can get keys

object as well. So how we can get keys here as well and then some utility

here as well and then some utility function if you want to use so

function if you want to use so JSON.stringy file which can convert I

JSON.stringy file which can convert I guess to string right. Then working with

guess to string right. Then working with multiple items uh item and narrow

multiple items uh item and narrow function. So I will just suggest that

function. So I will just suggest that you go through it. uh this will just

you go through it. uh this will just derail us from what we are trying to do

derail us from what we are trying to do but in the future one I would like to

but in the future one I would like to surely walk you through these function

surely walk you through these function as well for the time being I guess that

as well for the time being I guess that the understanding which we have from a

the understanding which we have from a beginner point of view that is way more

beginner point of view that is way more than enough okay so now if you go back

than enough okay so now if you go back everyone here what I just want to do now

everyone here what I just want to do now is for my nationality I just I either

is for my nationality I just I either want to get so pay attention body

want to get so pay attention body country then first and Then I want to

country then first and Then I want to get the country ID. See this is all what

get the country ID. See this is all what we want to do. Item JSON count first and

we want to do. Item JSON count first and then country ID. So this is the country

then country ID. So this is the country ID. Now let me execute this

ID. Now let me execute this and see this has been done since this

and see this has been done since this was an append or update row.

was an append or update row. This one. Yeah. See the same has been

This one. Yeah. See the same has been updated. Now just think how many

updated. Now just think how many possibilities are there. Like

possibilities are there. Like possibilities are genuinely endless.

possibilities are genuinely endless. you could uh connect your sheet and do

you could uh connect your sheet and do so many of these things which you might

so many of these things which you might do manually as of now right and frankly

do manually as of now right and frankly speaking this was easily doable with the

speaking this was easily doable with the code as well uh so we have written

code as well uh so we have written Python code for this now if I show you

Python code for this now if I show you in Python or rather any language we have

in Python or rather any language we have the Google Sheets library and again in

the Google Sheets library and again in that we have so this G sheet is a

that we have so this G sheet is a library okay it is based on Google

library okay it is based on Google Sheets API as well so I'm just showing

Sheets API as well so I'm just showing you that how things are more or less the

you that how things are more or less the same. It is not that a lot of difference

same. It is not that a lot of difference is there. It is in the back end also

is there. It is in the back end also using the APIs only, right? But yeah,

using the APIs only, right? But yeah, Nit makes our work a lot simple. So with

Nit makes our work a lot simple. So with that everyone, now let's go back and

that everyone, now let's go back and let's close this.

let's close this. So now I would like to have a email now.

So now I would like to have a email now. Gmail

Gmail here I would like to send a message. So

here I would like to send a message. So send send

send send a message

a message and the message can be pretty simple. So

and the message can be pretty simple. So to ai with may at the rategmail.com

to ai with may at the rategmail.com subject is new client.

subject is new client. Then this message is where I would like

Then this message is where I would like to add something. Uh hey may

to add something. Uh hey may let me add like this

let me add like this a new client and we can easily use this

a new client and we can easily use this inside. I hope you know this. Okay. So

inside. I hope you know this. Okay. So see just as I tried to use expression it

see just as I tried to use expression it kind of bought me out. Now if I expand

kind of bought me out. Now if I expand this it will show me a updated UI. So in

this it will show me a updated UI. So in this UI as well it is pretty simple.

this UI as well it is pretty simple. This is all the inputs which you have.

This is all the inputs which you have. This is the result. So a new client

has signed up below. I think I'll bring out that. So

below. I think I'll bring out that. So name minute name.

name minute name. Okay. So if you could not not have done

Okay. So if you could not not have done that, we could have easily used our case

that, we could have easily used our case as well. Signed up. Below are the

as well. Signed up. Below are the details and using this you can genuinely

details and using this you can genuinely automate lots of things, right? So I can

automate lots of things, right? So I can have number.

have number. Now you can easily drag and drop or

Now you can easily drag and drop or write them down. Totally on you. Then

write them down. Totally on you. Then budget.

budget. So this is the budget.

So this is the budget. Below

Below is the

expected or uh we can say yeah expected gender, age and nationality.

So I can have gender now and let's say something like this. Then I can have age

something like this. Then I can have age something like this

something like this and I could have nationality

something like this. Do make sure to connect

Do make sure to connect connect with him at I can have the

connect with him at I can have the number here.

number here. Right.

Right. Thanks.

Thanks. your awesome

your awesome workflow. Okay, so yeah, seemed like a

workflow. Okay, so yeah, seemed like a pretty nice email everyone. Let me close

pretty nice email everyone. Let me close this and let's save everything. So I've

this and let's save everything. So I've just click saved. Workflow saved. As of

just click saved. Workflow saved. As of now, no option, nothing we want to send.

now, no option, nothing we want to send. So I can just remove this append edit

So I can just remove this append edit and attribution. BCC CC send in send a

and attribution. BCC CC send in send a name send a replies to nothing we want.

name send a replies to nothing we want. And I can just execute the step.

And I can just execute the step. See the same has been sent. And if I go

See the same has been sent. And if I go to my Gmail and if I refresh it maybe

to my Gmail and if I refresh it maybe see a very nice mail. Okay. So we have

see a very nice mail. Okay. So we have this is kind of showing like this

this is kind of showing like this because we have not used HTML or any

because we have not used HTML or any formatting. But yeah we can do that as

formatting. But yeah we can do that as well. Okay. So that should not be a

well. Okay. So that should not be a problem. We can just copy that and it

problem. We can just copy that and it can provide us this all the things in

can provide us this all the things in HTML. Right? And we will be seeing a

HTML. Right? And we will be seeing a better way better way mail. So that is

better way better way mail. So that is not problem. But the idea I hope which

not problem. But the idea I hope which you are able to take away is that how

you are able to take away is that how you can automate this kind of a flow.

you can automate this kind of a flow. Right now based on this only we can have

Right now based on this only we can have other things as well. So just to give

other things as well. So just to give you an idea in what I was doing we were

you an idea in what I was doing we were also showcasing that how what can be the

also showcasing that how what can be the what can be the properties which are

what can be the properties which are valid. So for that we were making a in

valid. So for that we were making a in inbuilt API call for one of our

inbuilt API call for one of our services. Based on this detail it used

services. Based on this detail it used to get the properties and in the mail

to get the properties and in the mail only we used to send five properties uh

only we used to send five properties uh for the real estate broker so he can

for the real estate broker so he can make a better pitch overall. Okay. Now

make a better pitch overall. Okay. Now few things I would like to do or rather

few things I would like to do or rather I would like you to do is that instead

I would like you to do is that instead of this trigger what I guess we can have

of this trigger what I guess we can have is we can have a form trigger if you

is we can have a form trigger if you want right. So form trigger 1 minute

want right. So form trigger 1 minute where is the trigger here? Yeah trigger

where is the trigger here? Yeah trigger manually. Okay.

manually. Okay. So okay one. Okay, one thing I would

So okay one. Okay, one thing I would like to show you. So I think do we have

like to show you. So I think do we have any other trigger? No. So let me add a

any other trigger? No. So let me add a form trigger here everyone. So add

form trigger here everyone. So add another trigger on form submission.

another trigger on form submission. Right. So I know that you have already

Right. So I know that you have already done this thing. I'm not going to do

done this thing. I'm not going to do this for you. That is uh that is

this for you. That is uh that is something which we can do set that this

something which we can do set that this whole thing or rather let me correct

whole thing or rather let me correct this here. Stop this.

this here. Stop this. And

And now okay so there will be some change.

now okay so there will be some change. So I think you can do this thing. What

So I think you can do this thing. What you will be doing is that ideally now

you will be doing is that ideally now you don't need this Google sheet. What

you don't need this Google sheet. What you can do is you can just rather you

you can do is you can just rather you will be putting all the data. I like to

will be putting all the data. I like to show you some other thing. Pay

show you some other thing. Pay attention. So I'm just doing command Z.

attention. So I'm just doing command Z. You can do control Z to undo.

You can do control Z to undo. Now if let's say in case you have

Now if let's say in case you have multiple things here. Let's say second

multiple things here. Let's say second or let me use child GP. Okay. So

or let me use child GP. Okay. So okay I think this will work. So let's

okay I think this will work. So let's open child GPT everyone. So we're just

open child GPT everyone. So we're just showing you because you will also be

showing you because you will also be using this when you are using these

using this when you are using these things. Charge GPD

things. Charge GPD give me similar kind of data in a

give me similar kind of data in a commaepparated

commaepparated text form. Okay. So it didn't give me

text form. Okay. So it didn't give me the data.

the data. I just want to show you what you will be

I just want to show you what you will be doing if there are multiple things.

doing if there are multiple things. Okay. So let me copy this. Uh I would

Okay. So let me copy this. Uh I would just say can

just say can can you have names from

can you have names from different nationality so I can show you

different nationality so I can show you the whole thing.

the whole thing. So now it will be a little bit better

So now it will be a little bit better data right. So let's see how that will

data right. So let's see how that will uh fall out everyone. Let me copy this.

uh fall out everyone. Let me copy this. Now let's paste this here.

Now let's paste this here. Now to uh have this data across in the

Now to uh have this data across in the right form, I would like to do data and

right form, I would like to do data and I would like to do split text to column.

I would like to do split text to column. Okay. The second I do this, see

Okay. The second I do this, see everything is separated, right? So this

everything is separated, right? So this is something of an Excel here. You can

is something of an Excel here. You can use uh that as well uh edit in as well.

use uh that as well uh edit in as well. Now, yeah, this is your data. Now what I

Now, yeah, this is your data. Now what I will be doing, now what I will be doing,

will be doing, now what I will be doing, if I go back and if I show you this

if I go back and if I show you this thing and let's say normally I'm just

thing and let's say normally I'm just executing this. Okay. So I'm just

executing this. Okay. So I'm just executing this uh particular get rows in

executing this uh particular get rows in sheet.

sheet. You will see that how it will get all

You will see that how it will get all the rows. Okay. So it did got all the

the rows. Okay. So it did got all the rows.

rows. Now if you understand we have just done

Now if you understand we have just done this thing for a single uh thing right

this thing for a single uh thing right we have just done this full workflow for

we have just done this full workflow for a single row. Now why am I showing you

a single row. Now why am I showing you this? Because in many if you try to like

this? Because in many if you try to like me if you try to automate everything

me if you try to automate everything around you first you would like to try

around you first you would like to try it out without any form or without any

it out without any form or without any trigger just on the data it is present.

trigger just on the data it is present. Now the good thing is with your nit is

Now the good thing is with your nit is that either you could have a loop over

that either you could have a loop over items. Okay you can have a loop kind of

items. Okay you can have a loop kind of a thing where it can loop but it is

a thing where it can loop but it is saying that hey you may not need this

saying that hey you may not need this node. NA10 nodes automatically run once

node. NA10 nodes automatically run once for each input item. So all it is is

for each input item. So all it is is saying is that hey uh nit is smart

saying is that hey uh nit is smart enough. We will anyway be running one by

enough. We will anyway be running one by one. So I will pick this first then I

one. So I will pick this first then I will be running then second then I will

will be running then second then I will be running. So if that was not the case

be running. So if that was not the case we would have to loop over it. Right?

we would have to loop over it. Right? But for the time being because NA10 is

But for the time being because NA10 is pretty good. We don't need to do this

pretty good. We don't need to do this oursel. N will handle. So if let's say I

oursel. N will handle. So if let's say I close this and if I just delete this

close this and if I just delete this loop here everyone let me delete this.

loop here everyone let me delete this. Delete this. If I go on this, see it

Delete this. If I go on this, see it will say that will execute 10 times.

will say that will execute 10 times. Once for each input, right? This as

Once for each input, right? This as well. It will execute 10 times. Uh like

well. It will execute 10 times. Uh like one second. Sorry. Append will run.

one second. Sorry. Append will run. Execute step.

Execute step. Yeah, this is going to run 10 times.

Yeah, this is going to run 10 times. Okay. Okay. I think it is not able to

Okay. Okay. I think it is not able to get all the things here. So, if you will

get all the things here. So, if you will pay attention like here 10 items are

pay attention like here 10 items are paying. So, that's why it is showing

paying. So, that's why it is showing this. Let us run the full workflow.

And again it will send 10 mail. But I hope now you are smart enough that we

hope now you are smart enough that we can easily send a single main only. That

can easily send a single main only. That is not a problem. Right? So we can just

is not a problem. Right? So we can just if I go here go back refresh.

if I go here go back refresh. See so many emails right. So this is

See so many emails right. So this is required because now my whole thing have

required because now my whole thing have been kind of automated.

been kind of automated. for the newer one for the new entries

for the newer one for the new entries now which will come either I can have a

now which will come either I can have a form based uh trigger which will trigger

form based uh trigger which will trigger whenever there's a new entry or I could

whenever there's a new entry or I could have a trigger

have a trigger which is based on so if I show you

which is based on so if I show you Google sheets Google sheets

Google sheets Google sheets uh sheets we can have a trigger here as

uh sheets we can have a trigger here as well so in this trigger part right we

well so in this trigger part right we can have a trigger on row added on row

can have a trigger on row added on row updated or we could have on the row

updated or we could have on the row added or updated. So this is what we

added or updated. So this is what we will be using. Okay. So normally this is

will be using. Okay. So normally this is what I did when I was automating my

what I did when I was automating my workflow from starting first I have to

workflow from starting first I have to automate what is the leftover thing that

automate what is the leftover thing that has been automated. Now I will move

has been automated. Now I will move forward and set a trigger that hey

forward and set a trigger that hey anytime I receive an email please now

anytime I receive an email please now focus on that because you have already

focus on that because you have already automated the last one. So for that

automated the last one. So for that everyone now I want that you do that at

everyone now I want that you do that at your end where you will be focusing on

your end where you will be focusing on automating this part. Okay. I'm pretty

automating this part. Okay. I'm pretty sure that that shall be pretty easy and

sure that that shall be pretty easy and with that we have actually created the

with that we have actually created the automation thing as of now and next we

automation thing as of now and next we will be jing uh running on AI and agents

will be jing uh running on AI and agents in NA. Okay. So up till now you have

in NA. Okay. So up till now you have made a very very strong base in

made a very very strong base in automation understanding and the NA and

automation understanding and the NA and basic understanding. Now all is left is

basic understanding. Now all is left is that we will understand that okay what

that we will understand that okay what are agents? How can we integrate AI?

are agents? How can we integrate AI? Those are the things which we want to

Those are the things which we want to focus now on from the next module onward

focus now on from the next module onward where we will be integrating AI into our

where we will be integrating AI into our use cases first and then we will see

use cases first and then we will see that how agents can also help us. Okay.

that how agents can also help us. Okay. So agents and AI are as little separate

So agents and AI are as little separate thing as of now nothing AI we have used

thing as of now nothing AI we have used and don't worry if you have no key or

and don't worry if you have no key or something n is pretty generous in that

something n is pretty generous in that it will provide you with a dummy key at

it will provide you with a dummy key at least which you can just test out your

least which you can just test out your workflow on and I will also be giving

workflow on and I will also be giving you a way through which you can easily

you a way through which you can easily use a service through which you will get

use a service through which you will get a key to automate your flow right

a key to automate your flow right without any credit without any credit

without any credit without any credit card without any money okay so with that

card without any money okay so with that everyone now let's uh in the next

everyone now let's uh in the next section focus on integrating,

section focus on integrating, understanding and making sure that our

understanding and making sure that our workflows are a lot smart with AI and

workflows are a lot smart with AI and agents in NAN.

agents in NAN. Hey everyone, so now let's move on to AI

Hey everyone, so now let's move on to AI and agents in NAN. Now this is where the

and agents in NAN. Now this is where the things will get really useful and we'll

things will get really useful and we'll be taking up a notch as now we will be

be taking up a notch as now we will be learning that how can we integrate AI

learning that how can we integrate AI and agents into our NAN workflows which

and agents into our NAN workflows which are genuinely going to make them a lot

are genuinely going to make them a lot helpful. Along with that as earlier I

helpful. Along with that as earlier I will be making sure to share the real

will be making sure to share the real world use cases and we will also see

world use cases and we will also see that how can we transform our N10

that how can we transform our N10 workflows by some other application into

workflows by some other application into a into an application as well. So that

a into an application as well. So that we are not just thinking in terms of

we are not just thinking in terms of these workflows but rather we are

these workflows but rather we are thinking in terms of application

thinking in terms of application something which can genuinely be sell as

something which can genuinely be sell as well as something which can be used to

well as something which can be used to solve a real world problem. Along with

solve a real world problem. Along with that we will see that how can we

that we will see that how can we integrate them with other day-to-day

integrate them with other day-to-day applications which we use and yes that

applications which we use and yes that is where we will be now making or even

is where we will be now making or even taking the full power of innate in all

taking the full power of innate in all these workflows. Okay. So with that now

these workflows. Okay. So with that now first of all also a lots of

first of all also a lots of congratulation because I'm pretty sure

congratulation because I'm pretty sure that at this point till this point

that at this point till this point rather many students must have or

rather many students must have or learner must have dropped off. So if you

learner must have dropped off. So if you have taken up this far, I hope you're

have taken up this far, I hope you're liking it a lot and please make sure

liking it a lot and please make sure that you learn this because all the

that you learn this because all the learnings which we are doing here that

learnings which we are doing here that will be helpful in in numerous uh

will be helpful in in numerous uh automations which I will be creating and

automations which I will be creating and uploading to my channel on a weekly

uploading to my channel on a weekly basis starting with next week. So with

basis starting with next week. So with that now let's move forward. the

that now let's move forward. the learnings of AI and agents is going to

learnings of AI and agents is going to be very helpful comparatively easy to

be very helpful comparatively easy to apply and when in the future I will show

apply and when in the future I will show you that how can you integrate rag and

you that how can you integrate rag and other complex cases the same shall be a

other complex cases the same shall be a lot helpful so now let's move forward

lot helpful so now let's move forward the very first thing if you see on the

the very first thing if you see on the screen module 4 AI and agents let me

screen module 4 AI and agents let me just quickly run you through the flow

just quickly run you through the flow which we have already seen as well now

which we have already seen as well now if you all remember this was the flow

if you all remember this was the flow which we saw where there was a input

which we saw where there was a input then there was was an action and of

then there was was an action and of course the output was something which we

course the output was something which we were seeing. Now we have created

were seeing. Now we have created multiple workflows into our nitin where

multiple workflows into our nitin where we can easily see that easily see that

we can easily see that easily see that how can we able to just break down our

how can we able to just break down our work with having a trigger right and

work with having a trigger right and finally get some output. So to go a

finally get some output. So to go a little bit deep inside this let me just

little bit deep inside this let me just show you this particular diagram. So

show you this particular diagram. So just a second let me just make it a

just a second let me just make it a little bit bigger

little bit bigger and make sure that you download these

and make sure that you download these notes as well everyone. So for the

notes as well everyone. So for the timing just focus on this that this was

timing just focus on this that this was something which we were doing we were

something which we were doing we were doing a form submission right or let's

doing a form submission right or let's say any other trigger as well. So I

say any other trigger as well. So I would like to add this here form

would like to add this here form submission or some trigger. Now it can

submission or some trigger. Now it can be a manual trigger it can be a trigger

be a manual trigger it can be a trigger based on a email. It can be some trigger

based on a email. It can be some trigger based on some other application

based on some other application altogether. Then we were doing some

altogether. Then we were doing some action everyone. So sheet enrichment

action everyone. So sheet enrichment extra steps all what we wanted to do was

extra steps all what we wanted to do was being done here. And finally we were

being done here. And finally we were getting some output which in our case

getting some output which in our case was the email getting sent. Right

was the email getting sent. Right now this is where you have mastered

now this is where you have mastered automation. And I would like to just

automation. And I would like to just mention one thing here that many

mention one thing here that many students what they feel or many learners

students what they feel or many learners what they feel is that they can create

what they feel is that they can create automations out of the blue. Well, that

automations out of the blue. Well, that is a very very bad way of thinking about

is a very very bad way of thinking about automation. You can genuinely automate

automation. You can genuinely automate things only when you understand the

things only when you understand the process in depth. So if you do try to

process in depth. So if you do try to automate your end to end or let's say

automate your end to end or let's say any professional workflow as well,

any professional workflow as well, please first make sure that you

please first make sure that you understand the same in depth, the better

understand the same in depth, the better your understanding will be. Just as an

your understanding will be. Just as an example in this particular flow, the one

example in this particular flow, the one which we created, the better our

which we created, the better our understanding, the better we will be

understanding, the better we will be able to create them. Many of the

able to create them. Many of the learners just by seeing some or the

learners just by seeing some or the other course like which genuinely no

other course like which genuinely no crash course can teach you to automate

crash course can teach you to automate everything unless you know that what is

everything unless you know that what is happening inside without that knowledge

happening inside without that knowledge you cannot join the dots and automate

you cannot join the dots and automate anything. This is the easiest way of

anything. This is the easiest way of doing it and like in the future cases

doing it and like in the future cases which we will see and even in this crash

which we will see and even in this crash course you will see that how you are

course you will see that how you are able to automate so many facets of your

able to automate so many facets of your life but provided you have the full

life but provided you have the full understanding of them. If that is not

understanding of them. If that is not there then surely that will not happen.

there then surely that will not happen. So always make sure that you are someone

So always make sure that you are someone who is having the proper understanding

who is having the proper understanding else you will be unnecessarily making

else you will be unnecessarily making the process complicated which is

the process complicated which is something which I want my learners to

something which I want my learners to avoid. So this is coming from the direct

avoid. So this is coming from the direct experience which I have over building

experience which I have over building and working with AI like from the last 3

and working with AI like from the last 3 four years. So with that now let's move

four years. So with that now let's move forward. The very first thing which I

forward. The very first thing which I would like to now show you is how you

would like to now show you is how you can use a LLM inside your workflow. So

can use a LLM inside your workflow. So for example if we have chat GPT

for example if we have chat GPT something which we have seen earlier as

something which we have seen earlier as well. This is an LLM right? This is a

well. This is an LLM right? This is a large language model which all of us

large language model which all of us have used. You can send it a message

have used. You can send it a message that say hi and it's going to return you

that say hi and it's going to return you back the message. Okay. So the idea now

back the message. Okay. So the idea now is that can I make my automation okay

is that can I make my automation okay have AI in that. So pay attention this

have AI in that. So pay attention this is still having AI into my automation

is still having AI into my automation right. So here we saw that how I have

right. So here we saw that how I have created it in a way first AI and then

created it in a way first AI and then agents. So I would like to first show

agents. So I would like to first show you that in our automation the one which

you that in our automation the one which we are creating here we can click a plus

we are creating here we can click a plus sign and we can have AI in this. So this

sign and we can have AI in this. So this is where we can add AI into my

is where we can add AI into my automation. Let me add this automation.

automation. Let me add this automation. Uh let me add an AI and let's say I'm

Uh let me add an AI and let's say I'm just using open AI here. So we know that

just using open AI here. So we know that chat GPD is from open AI. I am just

chat GPD is from open AI. I am just using that. So open AI

using that. So open AI and let's say messenger model. Right? So

and let's say messenger model. Right? So pay attention now everyone. This is very

pay attention now everyone. This is very very important. First thing please focus

very important. First thing please focus on this. So all this is saying is that

on this. So all this is saying is that get 100 free open AI API credits. Right?

get 100 free open AI API credits. Right? So thanks to any even if you don't have

So thanks to any even if you don't have a key right you can easily use this

a key right you can easily use this model to test out and prototype your

model to test out and prototype your workflows. So I will very nicely claim

workflows. So I will very nicely claim this. And now you have 100 free open API

this. And now you have 100 free open API credits. Please note these free credits

credits. Please note these free credits are only one of the following models. So

are only one of the following models. So again it makes sense that it is having

again it makes sense that it is having some access models to some access to

some access models to some access to some of the models and not all. Now

some of the models and not all. Now surely you can of course use your own

surely you can of course use your own API key from any of the provider if you

API key from any of the provider if you want that access. Uh I will show you

want that access. Uh I will show you that how can you integrate Grock or open

that how can you integrate Grock or open router. So they do provide free keys and

router. So they do provide free keys and yes you will not be needing a credit

yes you will not be needing a credit card or anything. The idea is that for

card or anything. The idea is that for the time being though with nitin thanks

the time being though with nitin thanks and genuinely I believe this is a very

and genuinely I believe this is a very good thing so that every student every

good thing so that every student every learner can get started we do get the

learner can get started we do get the key right now I can say that okay this

key right now I can say that okay this is my uh free credits which I'm using or

is my uh free credits which I'm using or else I can create a new credential

else I can create a new credential uh along with that so 1 minute yeah

uh along with that so 1 minute yeah along with that everyone what I can do

along with that everyone what I can do is that in this resource I can say that

is that in this resource I can say that okay text is the one which is coming I I

okay text is the one which is coming I I can select message a model right and

can select message a model right and then I can select my model so let me

then I can select my model so let me select the model let's say for the time

YouTube TranscriptPreparing your results…

YouTube Transcript:Complete n8n Masterclass: Build Al Agents & Automate Workflows (Zero to Hero)

AutoDub

Video Transcript

Summary

Core Theme

YouTube Transcript:
Complete n8n Masterclass: Build Al Agents & Automate Workflows (Zero to Hero)