So far in this chapter, we had four different projects and now let's build a Summarizer actually a
document Summarizer that actually triggers whenever the new file is uploaded to Google Drive.
Then it gets the content from this exact file, and it uses AI to generate a summary, and also the
Wikipedia as the extension.
And at the end it saves the data inside Google Sheets.
If you want to get more advanced description for this project and the resources of this material, I
prepared for you the file you can download and here read everything about it.
But now, without speaking too much, let's create this automation.
So let's start with the trigger which is drive Google Drive.
And here on changes involving a specific folder we want to trigger this automation.
So here I've got my folder which is named and testing.
And there we are searching for file created.
Now what we can do actually we can fetch test event.
However we need to add some specific file before.
So right there let's create.
Actually it's also very important this automation actually works on Docker extension.
So here we are providing only doc documents.
Let me actually create some file.
I've got a data prepared for that actually here as you can see.
All right.
So um let me actually take it here.
All right.
Um, and there let's provide um, there the title for this document and also, um, the content.
Yeah.
That's right.
And now, um, we are done.
Let's go over here, click on file created and fetch test event.
We've got our file.
As you can notice.
Um, can we search for the name.
Name?
Um, yeah.
The surprising benefits of doing nothing.
Yeah.
Very surprising.
Um, now what we can do, we can provide the next node, which is docs.
Um, actually Google Docs.
And here we want to get a document, so get the content actually.
All right.
And now what we can do, um, we can actually take, um, the link or ID maybe.
Let's take ID, um, from our Google Drive.
Yeah.
From our Google drive.
Step.
So the trigger, let's see if that works.
So we've got a content by this way.
Um, as simple as that.
We actually extracted the content from our Google Drive file.
Let's go ahead.
And we've got now the a actually model OpenAI model that uses Wikipedia.
So here we can message a model and we've got the prompt.
So let's actually choose the model which is um let's pick for GPT four.
Oh yeah.
And here I've got the following prompt.
Either you can type or write, take the content and summarize it in a few sentences.
However, I can type something like this, summarize this content into let's say 3 to 5 sentences.
All right.
Let's take the content from Google Docs right here.
And what's actually what's actually very important.
Let's add the tools.
Either we can click here or just click here.
And now let's provide the Wikipedia extension.
So what we do we we enable our OpenAI model to search the Wikipedia which is truly nice.
And the last step for now is Google Sheets.
So as you can notice, these exercises don't take a lot of time.
They are very simple in general.
And the main point is you're getting familiar with Nadine like getting familiar with the software,
how to use it, all of the options and so on.
What we can do now.
All right we've got Google Sheets and we need to append row and sheet.
We've got the document.
And what's very important we need to create some document.
So blank spreadsheet.
And now what we can provide here the name.
Um all right there the summary.
So this is the name of the file summary.
we and what we can type here the link to the Google Drive file.
So link let's say URL.
Yeah.
URL.
All right.
Let's make it like this.
Also I can go over here, select the entire document and um change actually to wrap.
That's cool.
Let's pick the document from the list.
We've got untitled spreadsheet.
Spreadsheet.
We could have and change that.
So for example demo.
Let's do it by this way.
Let's refresh the list.
Do we have the demo?
Yeah.
Choose the sheet.
And here let's provide our name.
Let's let's actually execute the previous notes to have the inputs.
All right.
We've got our name.
Let's search for the name.
Um, we've got the surprising benefits of doing nothing.
Yes.
Um, here.
The contents.
Um, so we have the content from, So where do we have that?
We have the content from OpenAI.
We want to get this summary.
And at the end let's, um, take the link.
That's right.
Let's take the link.
Um, where do we have that?
Probably right here.
Web view link URL.
Nice.
So we've got everything name, summary and URL.
Let's test it and see how it works.
So here it should appear in a matter of seconds.
Nice.
We've got a name summary URL.
Of course, we could have formatted that previously.
So this entire file still, it's really enough.
We created our workflow, which is which contains actually four different nodes.
So we've got first the input which is Google Drive, Google Docs, OpenAI and at the end and at the
end output node.
So that's everything I hope you actually accomplish this exercise.
You had a lot of fun meanwhile doing that and you didn't have any problems.
Meanwhile the entire process.
Thank you for watching and I will see you in the next lesson.