Update Google Drive File List Information to Notion Database Monthly
This flow is recommended for those who want to reduce the hassle of file management, as it allows the latest file list information to be automatically reflected in Notion.
.png)
・
"Is this the latest version of the file?" "Where did I save it?"
The more documents you manage on Google Drive, the harder it becomes to know which is the latest or to avoid sharing oversights. Do you have such concerns? In such cases, the integration of Google Drive and Notion is convenient. For example, you can automatically create a record in Notion when a new file is added to Google Drive or reflect the latest file list in Notion every month. By reflecting file update information in Notion, you can reduce the effort and errors of manual transcription. This is a recommended method for those looking to improve daily work efficiency.
By using Yoom, you can easily integrate Google Drive and Notion without any coding.
Yoom provides templates for integrating Google Drive and Notion, so you can achieve integration immediately just by registering, even without API knowledge.
By integrating the APIs of Google Drive and Notion, you can automatically sync data from Google Drive to Notion!
You can immediately experience the integration of Google Drive and Notion by simply clicking "Try it out" on the automation example you're interested in and registering an account. Registration takes only 30 seconds, so feel free to give it a try!
This flow is recommended for those who want to centrally manage file information and prevent the creation of duplicate files.
This flow is recommended for those who want to reduce the hassle of file management, as it allows the latest file list information to be automatically reflected in Notion.
This flow is recommended for those who frequently update files or want to reduce transcription errors in Notion.
Let's go ahead and create a flow that integrates Google Drive and Notion!
This time, we will use Yoom to proceed with the integration of Google Drive and Notion without any coding. If you don't have a Yoom account yet, please issue one from the registration form here.
[What is Yoom]
This time, we will create a flow bot that creates a record in Notion when a new file is added to Google Drive!
The creation process can be broadly divided as follows:
Click "+ Add" from "My Apps" in the left menu of the Yoom screen.
Enter the name of the app you want to connect in the search box.
When you search for the Google Drive app, the login page will appear.
Click "Sign in with Google".
Select the account you want to connect.
When the screen regarding sharing with Yoom appears, check the content and press "Next".
When the screen for granting access permissions appears, check the content and click "Continue".
This completes the connection of Google Drive with My Apps!
When you search for the Notion app, the login screen will appear.
Enter your login information.
After logging in, the screen for granting access to Yoom will appear.
Check the content and click "Select Pages".
Check which pages you want to allow access to.
Once you have made your selection, click "Allow Access" to complete the connection!
Next, copy the template to be used this time.
When the template is copied to "My Project", a screen like this will be displayed.
Open the copied template from "My Project" in the menu on the left.
Click on "When a new file or folder is created in a specific folder".
Enter the necessary information.
"Title": Can be changed as needed
"Account information linked with Google Drive": Confirm if correct
"Trigger Action": Select "When a new file or folder is created in a specific folder"
First, select the "Trigger Interval".
You can choose the trigger interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
If you want to add to Notion quickly, set it to a shorter interval!
※ Please note that the selection of trigger intervals varies depending on the plan.
Next, enter the "Folder ID".
This time, as a test version, we created a folder called "Test", so we will enter this folder ID!
Entering the folder ID is easy!
Click the input field, and suggestions will appear, so choose from them.
Create a new folder or file in the folder.
Then click "Test".
If the test is successful, the message "Test Successful" will appear along with the folder information you just created, which will be displayed in the output.
This output will be used when performing integration tasks, so make sure to check it!
Then click "Save".
※ For more detailed explanations about the output, please check here.
Click on "Retrieve File and Folder Information".
Enter the necessary information.
"Title": Can be changed as needed
"Account information linked with Google Drive": Confirm if correct
"Action": Select "Retrieve File and Folder Information"
Enter the "File ID".
If "File ID" is already entered, it's okay as it is.
If not entered, follow the steps below.
① Click the input field to display the output
② Click "When a new file is created in a specific folder"
③ Select "File ID"
After entering, press "Test".
If the test is successful and the output is displayed, click "Save".
Click on "Add Record".
Enter the necessary information.
"Title": Can be changed as needed
"Account information linked with Notion": Confirm if correct
"Execute Action": Select "Add Record"
Next, integrate with the database.
This time, as a test version, we created a table like this in Notion!
Therefore, enter the ID of this table.
When entering the "Database ID", choose from the suggestions.
Click the input field and select the table you want to integrate with.
Enter the "Values of the record to be added".
Input fields corresponding to the Notion table will be displayed, so use the output obtained in Step 3 and Step 4 to enter the values!
① Click the input field to display the output
② Click "When a new file is created in a specific folder"
③ Select "File Name"
Enter other fields in the same way.
Once the input is complete, press "Test", and if the test is successful, click "Save".
Also, make sure that it has been added to Notion!
Finally, click "Turn on the trigger" to complete the automation setup.
Make sure the flow bot is activated correctly.
Thank you for setting it up!
This concludes the integration procedure for creating a record in Notion when a new file is added to Google Drive!
This time, we introduced how to integrate data from Google Drive to Notion, but if you want to perform data integration from Notion to Google Drive, please also use the following template.
This is a recommended flow to prevent missing file name changes when file name changes frequently occur in Google Drive.
This flow is recommended for those who find creating folders tedious or want to unify the names registered in Notion with the folder names in Google Drive.
By utilizing the APIs of Google Drive and Notion, various automations can be achieved.
You can automate tasks such as creating new folders, storing operations, and file management. Additionally, automatic notifications are possible by integrating with other tools.
It is recommended for situations where there is a lot of data entry work, as it allows for automatic data addition and updating. Additionally, automatic notifications are possible, reducing the effort required for information sharing.
How was it? By integrating Google Drive with Notion, you should be able to address challenges such as "wanting to centrally manage the latest file information with your team," "wanting to eliminate transcription errors to Notion," and "wanting to automate complex file management." Automatically reflecting file additions and updates in Notion significantly enhances the accuracy and speed of information sharing.
<span class="mark-yellow">By utilizing the no-code tool Yoom, you can easily integrate Google Drive and Notion without any programming knowledge!</span> If you're interested, start by creating a free account and see how it works for yourself. Registration takes just 30 seconds! You can experience automatic integration right away.
Would you like to make file management in Google Drive easier and streamline information organization in Notion?
.avif)
.png)
