-: We are going to talk about Make another no-code
integration tool that you can use to connect ChatGPT
with many of the apps you use every day.
This is one of my favorite integration tools that
we can use to put in practice what we learned
in previous lessons without the need to code.
Something really cool about Make,
it's that we have lots of templates that we can use
to avoid starting from scratch.
And we can search for the apps
that we want to use especially.
Let's type OpenAI and explore all
the templates that have ChatGPT.
For example, I'm going to choose this one that says,
"Analyze sentiment in customer feedback on
Google Sheets using ChatGPT."
And we can start a guided setup for the automation we chose.
So let's try it.
So on the first step it's going
to ask for a Google connection.
So there we had to sign in.
Then we have the spreadsheet ID.
I'm going to add one that I already have created.
Customer sentiment spreadsheet, there we go.
Then we pick the sheet name and we continue.
And here on the ChatGPT module,
it's going to ask for a connection.
We have to add here our API Key,
and there we have our connection.
Then we select a method,
create a champ completion, it's okay.
We pick a model.
Let's see here we have this one.
Here we have a prompt, the one on the template, it's okay.
And then we continue.
And here we have also to add a connection.
And then we also have to choose the spreadsheet here,
select the sheet name.
And there we have to choose the cell where
the ChatGPT answer is going to be generated.
So there we click continue.
Our template is ready.
So let's go and test it.
Here we have our template and we are going to write
the restaurant was awesome.
And here we can configure,
yes, when it's going to run our scenario on demand.
Just every time we click on the button
or we can schedule when it's going to run.
So let's run it and see if it works.
So looks that it works.
And there we go.
The sentiment was positive.
So that's it on Make.
I hope you enjoy this tool as much as I do,
and create really cool automations.