In the previous lesson, we created our fully functional telegram chatbot and now is the time for another
exercise, which will be simple and relatively easy to accomplish.
So we'll create a system that synchronizes new files from Google Drive to our table.
And as usual in this chapter, I prepared for you the file that explains everything.
So in this exercise, you will build an automation that helps you organize and share files.
When a new file is added to a specific Google Drive folder, your workflow will detect the new file
from Google Drive.
Send the file by email to a recipient.
Save file details into Airtable.
So here again, I can say it's relatively easy to create.
However, the most common problem can be with, you know, connecting creating credentials for Google
Drive.
However, remember Damien explained everything step by step how to do this in the section about creating
credentials.
So now you can stop the video.
Go over here and you know like connect your Google Drive to And then as you can see, the automation
you will build in this material contains only three nodes.
So first things first we've got Google Drive.
So whenever a new file appears inside some folder inside Google Drive we would like to trigger this
automation.
Then what we do we share the file with the recipient that we provide right here.
And at the end we log the data inside Airtable.
And that's simple as that.
So we've got only three different nodes.
And now with all that being said let's create that.
So to begin with the automation let's add our trigger.
So firstly we've got here Google Drive.
And let's pick that.
And now we've got a trigger which is on changes involving a specific folder not the file however however
folder.
And then what's very important actually you need to create a credential for Google Drive.
Again actually I refer to the section where Damian explains that step by step.
So if you haven't done it yet, actually I'll go over it there and set up a credential.
So I've got my account.
And here I need to set up a specific actually choose the specific folder.
I can choose either from list URL or ID.
So let me pick from list.
However, for now I need to create my very own folder for this project.
So let's go over there and create my folder.
So new folder and let's name it as demo.
All right.
And inside let's add some file as a file to base on.
Let me add that.
So Q&A for my company.
All right.
And now let's click here and refresh the list.
So we should see demo.
All right.
And watch for a file created.
All right.
File created.
Uh yeah.
File created.
Now I can fetch test event and wait for my file.
It's nice.
We've got it.
Now let's go back to our canvas.
And here set up the second node which will be again Google Drive.
So we can search for drive.
And here we want to share the file with our recipient.
And right there again we need to actually connect our account.
So we've got our credential.
We've got the resource which is file operations.
So we want to share that.
And here we want to choose the file.
And we do this by providing here the ID and there let's search for that.
We've got ID that's perfect.
We can provide it actually here the ID and also enable the permissions.
So we can add the permission.
And there let's provide actually maybe the right error there the type which is the user and the email.
So actually let me go over there and you know actually provide my email.
And now that's all we can actually test the step.
So see if we have an access.
All right.
So actually now let me go over to my email and check it out.
So as you can see, this file is shared on my email.
And there what we can do, we can go back here and set up the last actually output node, which is um,
an Airtable.
All right.
So we can pick Airtable.
And here I create a record okay.
And right there we've got the resource which is record Operation Create.
And here we need to choose our base, which is for me the untitled base.
And here I created the one.
So as you can see we've got the file ID creation time and recipient email.
All right.
So again I can pick that the table.
So I've got the table one.
And here I've got the fields to fulfill.
Let's go over there and provide the ID um creation time.
And lastly we've got the recipient email.
And this is the static value.
So we can provide the email we typed previously.
All right.
And now let's test the step.
So we've got a problem.
File ID expects a number but we've got.
All right so we've got the wrong field type.
Let's click here and there and provide the long text.
That's cool.
And right there let's refresh.
Um there.
Yeah.
Um the columns and let's test the step.
So let's see.
All right.
It works.
And we've got it.
All right.
So we've got our file ID creation time recipient email.
So everything works perfectly.
So in general I hope you enjoyed I'm creating um this entire system.
So synchronizing our Google Drive files.
So whenever we've got the new file here it's shared our recipient.
And then like the data is stored in Airtable.
So for tracking purposes.
So thank you for watching again this video for now that's everything.
And in the next materials we are going further and further into more advanced and projects A agents
and a automations.