So now I hope you accomplish two previous exercises we had in this section.
So we were creating a chatbot for telegram, and also the system to synchronize files from Google Drive
to Airtable.
Now let's go ahead with another project.
So in this video I have for you something a little bit more complex because we'll create audio transcription
and summary.
And here we've got the trigger which is the new audio file, um, inside a specific Google Drive folder.
Then we've got some automation steps.
And by the way remember you can download this file in the resources of this material.
So here whenever you are creating this automation actually you can go over there open it.
And you know like know all of the details.
However we've got the step one with inside automation steps.
So here detect new audio file in Google Drive.
So use a Google Drive trigger to watch the folder.
Then we've got the step to transcribe audio to text.
And for that we'll be using OpenAI.
And the step three is to summarize um actually using GPT four.
Um so we'll be using our, um, you know, LLM to actually summarize for us this content, and at the
end we save the data inside notion and our system that will build in a moment looks like this.
So first we've got Google Drive trigger again.
Then we've got the step for Google Drive to download the file.
We've got OpenAI to transcribe the recording here.
This actual step actually summarizes that.
And then at the end we've got notion.
So we save that.
Now for an example.
Let me show you how it works.
So here inside my folder inside Google Drive I have the file which is uploaded and everything is set
up right there.
So let's click on Test Workflow.
And actually you can see firstly we've got the file which is this one.
Afterwards it downloaded our content from here.
Now it's transcribing that with using AI.
So let's wait a while.
Actually it may take a several seconds.
Nice.
All right.
So we've got our transcription right there.
Let's see.
We've got the text and we are waiting for yeah the response from our OpenAI.
And at the end.
Yeah.
It's cool.
We should have here a transcript.
So as you can see right there, we've got here the transcript and it works.
So we've got a main point action items, follow up stories, references arguments and more.
So so nice.
It works for sure.
So with all that being said, let's build it from scratch.
However, before that, I've got for you a very small request.
Actually, please accomplish this exercise along with other exercises from this chapter.
Actually, by that, by doing that, you get familiar with and then you practice, um, and you are
better at using that.
It's very, very important.
Nevertheless, let's start with the trigger, which is the drive.
All right.
So we've got Google Drive.
And here we want to trigger that on changes involving a specific a specific folder.
So here we can select from list.
And we've got our recordings.
All right.
I prepared a folder right there.
As you can see I've got my recordings.
So we need to prepare your own.
I'm also, again, if you don't have actually drive connected to an addon, and feel free to check out
our section and the video about how to do this.
It's very important.
And here we watch for file created.
Um, right there.
What I can do.
Let me actually go over here and provide my podcast.
All right.
Right here I would like to based on that I've got productivity.
It's not that long.
And all right it works.
Now let's go over here.
File created fetch test event.
So we've got it.
Let's search for the name.
All right.
And we've got productivity.
Nice.
It's cool.
Um, let's go back to canvas.
And here, um, add the step for drive because we want to download a file.
All right.
You want to take this file and download that.
Now what we can do, um, we can provide the ID.
That's right.
We want to pick the variable based on that.
We want to download this file.
We've got the id so JSON id.
Let's test the step.
Um yeah it should work.
Nice.
So we've got here this file the name productivity file extension.
Nice.
It's cool.
The next step what we want to do is actually to use open AI um to get the transcription for this audio.
So transcribe a recording as you can see right there and here what's very important um, we test this
step because actually previously we had this step and we've got this input.
We need to test the step and wait a few seconds.
So after a while we've got our transcription.
And then we need to go ahead and choose actually message.
Um actually no open AI.
We need to choose open AI.
And here a message a model.
Right.
We need to choose that.
And there we need to pick our model, which is GPT four.
Oh actually let's search for that for oh yeah I recommend you to pick that.
All right.
And here we've got um, actually our messages that we want to send to our, um.
Yeah, I.
Transcript.
Yeah.
Let's provide the variable for the transcript.
So here we've got from the OpenAI.
We've got here the text.
That's perfect.
So JSON text.
And there we can add new message for instructions.
And now actually I created some instructions that you can copy um actually from the resources of this
material.
So they are not complicated.
However you've got something like that instruction.
Summarize the audio content into plain text.
Following the structure below, we've got the rules, so the entire summary must not exceed 1500 characters.
Include the label all of the following sections.
Title summary.
Main points.
Action items.
Follow up stories, references and so on.
And we've got the example structure.
And that's something not very complicated however still.
Yeah it's nice.
All right.
We can test the step.
Let's wait a while.
Um, so in general, when you learn how to use an addon later on, you actually speedrun the entire
process because you know how to use, for example, nodes and different actually actions, you're more
familiar, you get experience.
Um, so it's very quick, I can say.
Right.
And the last output node, um, is actually our um, notion.
All right.
So here we choose notion and there we append a block.
So here actually no no the block we create the page.
That's right.
And now there is the point.
Um actually we need to create our credential.
I've got my own hover actually.
Let me show you how you can do this.
So you need to provide your secret key.
And now actually let me show you how how how you can do this.
All right.
So let's go over to notion Dot.
So and here provide slash profile and their integrations.
All right.
In integrations.
Um yeah that's bad.
All right let's go again.
Notion profile.
I had the misspelling integrations.
Okay.
Hopefully it works.
Yeah.
Nice.
And here we've got this entire page.
So we need to create the new integration and their provide the associated workspace.
Choose the type which is internal and click on save.
All right.
We've got also the name.
So let's name it as demo.
Okay.
Save it.
And we need to configure this integration.
And here um actually take our secret key.
That's right.
Also we need to enable actually we can enable read comments and insert comments.
So it's very nice actually to always enable that.
Let's click on save.
And here let's go back to our, um.
Yeah.
Our profile.
Let's save it.
So we've got our credential.
And now what's very, very important when we are here we need to click there actually.
And on connections right here you should see na den actually na den and testing this is my previous
credential I created.
And when I refresh that um, let me show you I've got the connection.
I've got a demo.
All right.
It's very, very important.
We need to click on that and click on confirm.
After we do this we've got our two connections.
And from now we can work on our page.
So let's go back here and I provide the URL of the page simply.
And we can go over.
We can go over right there to the URL, paste it here, or even choose from the URL.
Next we need to provide a title.
So for example let's search for the name of the file from Google Drive.
We've got Google Drive productivity.
All right.
And then we need to add some blocks.
So firstly we want to pick the heading and provide a heading for that.
Right.
So maybe let's provide a static text which is a summary.
And then also let's provide another block which will be for the text.
So we've got the message from our model.
Okay.
This is probably this one.
Yeah.
We've got the title the podcast episodes.
Yeah.
Okay.
We've got this content.
And now we can test the step.
That's correct.
Hopefully it works.
Let's see.
All right.
So we've got API token is invalid.
So we've got some problem here.
Actually let's maybe refresh that try again.
Um or we've got some problem with our credential.
All right.
So we've got here some problem.
So in general as I noticed.
And it was weird actually my secret key inside and then was very long and I didn't probably like copied
this entire secret key or I don't know.
However, here, um, yeah.
You know, I've got my secret key right there.
Let's save it.
And now set up everything right there.
All right, um, we've got our, um, connection.
Let's test the step.
Hopefully.
Yeah.
All right, it works.
It's simple as that.
And we've got our productivity.
Um, yeah, we've got our productivity podcast summarized inside our file.
It's so, so nice.
It works.
And now, with all that being said, let's test out the entire automation how it works.
So now actually let's make this automation active.
And right now I had to prepare some recording.
However I've got it.
So there we've got uh where is that?
All right.
Cooking cooking podcast Um, it's being uploaded and for sure.
Now everything you know should work.
You should get here.
Um, the file with the transcript.
So right there.
Um, the file, um, yeah, again with the transcript.
After one minute or so, we've cut our cooking podcast transcribed, summarized here inside.
And it's totally nice, actually.
Remember, you can take any file actually audio file.
And here without you doing anything create perfect summary.
It's also nice actually it took a one minute because here let me actually show you.
And the Google Drive we've got um pull times which is every minute.
So we need to actually wait some time.
However, it's very, very fast still.
And after, um, you know, let's say 80s, I had my summary created, which is so, so nice.
And for this video, this is everything.
I hope you created this entire project and you didn't have any problems here for now.
Thank you for watching.
I hope you enjoyed it and I will see you in the next material.