In this article, we will discuss the process of integrating Google Drive with Notion, allowing you to automatically add any files uploaded to your Google Drive as an item into your Notion database.
This automation requires a one-time setup, for which we will use Pabbly Connect.
The first step is to establish a connection between Google Drive and Pabbly Connect, which will enable us to capture any newly uploaded files. Following this, we will link Pabbly Connect with Notion, allowing us to automatically add the captured files as items to your Notion database.
Steps to Automatically Add Google Drive Files to Notion Database
1. Sign In / Sign Up to Pabbly Connect and Create a Workflow
2. Setup Google Drive as the Trigger App to Fetch Files
3. Setup Notion as the Action App to Add Files
Step 1:- Sign In / Sign Up to Pabbly Connect and Create a Workflow
A. Sign In / Sign Up
To begin this process, visit Pabbly Connect and create your account by clicking on the ‘Sign Up Free’ button. You can also click on Sign In if you already have an account.
Click on the Pabbly Connect ‘Access Now’ button
B. Create Workflow
To create a new workflow, click the ‘Create Workflow’ button.
Name your workflow, and click on ‘Create’.
Step 2:- Setup Google Drive as the Trigger App to Fetch Files
We will now look at the steps through which we will establish a link between Google Drive and Pabbly Connect. This will enable us to retrieve files from a designated folder in your Google Drive.
A. Trigger App
Trigger allows us to choose the application that will retrieve the data for Pabbly Connect. In this instance, it would be Google Drive.
Choose ‘Google Drive’ as the Trigger App, select ‘New File in Specific Folder’ as an Action Event, and click on ‘Connect’.
B. Connect Google Drive Account
To connect with your Google Drive account, select ‘Add New Connection’ and click on ‘Sign in with Google’. Additionally, you will have to provide authorization.
Select the Folder that contains the files you want to capture, and then click ‘Save & Send Test Request’.
As soon as you click on Save & Send Test Request, Pabbly Connect will automatically capture the most recent file uploaded to the designated folder in your Google Drive.
Step 3:- Setup Notion as the Action App to Add Files
Action allows us to choose the application that will get executed by the workflow trigger.
Our goal is to save the files obtained from Google Drive into our Notion database. Therefore, Notion will be our Action App.
A. Action App
Choose ‘Notion’ as your Action App, select ‘Create Database Item’ as an Action Event, and click on ‘Connect’.
B. Connect Notion Account
To connect with your Notion account, select ‘Add New Connection’, and click on ‘Connect With Notion’. Additionally, you will have to provide the required authorization.
Choose the Database where you wish to store the files.
When you select your Database, the properties of this database will start reflecting as fields in your Action Step.
C. Map Necessary Fields
Now that you have successfully linked your Notion account, the next step is to map the file details from the preceding step. Mapping ensures our data remains dynamic and changes as per the received responses.
Map the File Link from the step above.
Likewise, map the File Name, and click on ‘Save & Send Test Request’.
Congratulations, your automation is now complete! You have effectively merged Google Drive with Notion. From this point onwards, any new file uploaded to your Google Drive will be automatically added to your Notion database.
You can copy this entire workflow by clicking this link.
Sign Up for a free Pabbly Connect account, and start automating your business
Subscribe to our Youtube Channel for more such automation
For any other queries, visit our forum