Integrate Notion and Google Sheets to streamline data management!
How to Integrate Applications
・
2025-04-11
Integrate Notion and Google Sheets to streamline data management!
s.yamashita
"I want to streamline my work using Notion and Google Sheets, but I don't know where to start..." Are you facing such a dilemma? When you try to integrate handy tools like Notion and Google Sheets, it can be challenging without programming knowledge, making it difficult for non-engineers. That's why this time, I would like to introduce a method to easily integrate these tools, even for non-engineers! No programming knowledge is required, and it can be completed with simple screen operations, so please refer to it!
Recommended for
Those who are considering streamlining their work with Notion and Google Sheets.
Those who have just started using Notion and Google Sheets.
Those who are utilizing Notion and Google Sheets for customer management.
For those who want to try it immediately
In this article, we introduce a method of integration using the no-code tool "Yoom". No complicated settings or operations are required, and it can be easily achieved by non-engineers. You can also start immediately from the template below, so please give it a try!
[About Yoom]
How to Connect Google Sheets to Notion
First, I'll introduce how to embed and connect Google Sheets using Notion's standard features.
Step 1: Copy the URL of the Google Sheet
Click "Share" in the upper right corner of the Google Sheet you want to embed in Notion, and select "Copy link".
Step 2: Embed in Notion
In an empty block in Notion, type "/ (slash in half-width)", select "Embed" from the menu that appears, paste the URL you copied earlier, and select "Embed link".
With this, the embedding of Google Sheets into Notion is complete! However, a disadvantage of this method is that all information on the spreadsheet is displayed. While many teams use Notion as a knowledge base accessible to all members, embedding or importing does not allow you to hide information from specific members.
How to Connect Notion and Google Sheets with the No-Code Tool Yoom
This time, I'll introduce how to connect using Yoom, which allows no-code integration with various apps. With Yoom, you can intuitively and easily connect Notion and Google Sheets, and you can also set up periodic executions and import only specific information, which was not possible with traditional embedding or CSV import.
How to Update Notion Page Properties When a Row is Updated in Google Sheets
Using Yoom, I'll introduce a flow where information is updated in Notion when changes are made in Google Sheets. You can use the template below to copy and use the flow. If you haven't issued a Yoom account yet, you'll be redirected to the issuance page, so please complete the registration before starting the setup.
You can easily register in the following 3 steps!
Step 1: Connect My Apps with Google Sheets and Notion Step 2: Set up a trigger that activates when a row in Google Sheets is updated Step 3: Set up an action to update Notion page properties
First, prepare both the Google Sheets and the Notion database that will sync the update information.
Step 1: Connect My Apps with Google Sheets and Notion
Select "My Apps" from the left menu, click "+ New Connection" on the right side of the screen, and select Google Sheets and Notion from the list of new connections to connect the apps.
Step 2: Set up a trigger that activates when a row in Google Sheets is updated
Open the copied template and click "App Trigger: When a row is updated" in the flow bot. Select the linked account and action. Change the title if necessary and click "Next". You'll be redirected to the API connection settings screen for the app trigger, so follow the instructions to set it up.
Step 3: Set up an action to update Notion page properties
Click "Operate Database: Update Page Properties" in the flow bot and set up the database connection.
Click "Next" and configure the detailed settings for database operations. Perform a test, and if successful, click "Save". Finally, switch the trigger of the saved flow to "ON" to activate it.
With this, the flow "Update Notion Page Properties When a Row is Updated in Google Sheets" is complete!
Next, we will focus on explaining the setup method for "Adding information to any Notion database and also adding that information to Google Sheets".
How to add information to Google Sheets when information is added to Notion
Next, we will introduce how to use Yoom to connect Notion and Google Sheets, so that when information is added to Notion, it is also added to Google Sheets. You can easily experience automation in the following 3 steps!
Step 1: Connect Notion and Google Sheets to My Apps Step 2: Set a trigger to activate when information is added to any Notion database Step 3: Set an action to add to Google Sheets
Before Getting Started
First, if you don't have a Yoom account, please create one from the Yoom Account Creation Page. You can start in 30 seconds!
Step 1: Integrate Notion and Google Sheets with My Apps
How to Register Notion with My Apps
Log in to Yoom, click the "New Connection" button on the Yoom My Apps page, and select "Notion".
Please log in with the account you are using.
Next, specify the scope of permissions.
If there are no issues, press the blue button "Select Pages".
After the screen transition, you can specify the scope of page access for Notion, so please specify the desired pages here.
In the image below, all options are checked.
Finally, press the "Allow Access" button at the bottom right to complete the registration of Notion with My Apps!
How to Register Google Sheets with My Apps
Log in to Yoom, click the "New Connection" button on the Yoom My Apps page, and select "Google Sheets".
When you select Google Sheets, you will be redirected to the following screen.
Click the "Sign in with Google" button in the red frame and log in with the account you are using.
This completes the registration of each app with My Apps!
Step 2: Set a trigger to activate when information is added to any Notion database
First, click on "Create New Project" and select "Create from Scratch".
Next, you will be asked to set the condition to activate the flow bot, select "When a specific app event is received".
Then, you will transition to a screen to select an app.
Here, since we will proceed with the Notion settings, select Notion.
* You can also search for the app name in the search window at the top of the screen.
Check if the linked account information is correct, and for the trigger action, select "When a page in a specific database is created or updated".
Once the selection is complete, click the "Next" button at the bottom of the screen.
Next, set up the API connection settings for the app trigger.
The trigger activation interval can be set as desired. Here, it is set to 5 minutes.
The "Database ID" can be obtained from within the Notion URL.
* The part of the URL "/workspace name/●●●/" is the database ID.
This completes the Notion trigger setup!
Step 3: Set the action to add to Google Sheets
Next, select the ＋ mark below the Notion app trigger.
Next, a screen to select the operation type will be displayed, select "Operate the database".
Since we want to add information to Google Sheets this time, select Google Sheets.
First, check if the linked account information is correct.
For the execution action item, select "Add a record".
For the database linkage item, fill in all the fields according to the explanation below the input field.
As a note, you need to register headers in the spreadsheet to add records.
As an example, we have set "Company Name, Contact Person, Email Address, Status, Remarks" as headers.
Check if the headers are included within the table range and click the "Next" button.
Then, you will transition to the detailed settings screen for database operations.
You can confirm that the headers set earlier are registered.
There are also items for detailed settings at the bottom of the screen, which can be set optionally.
Please set it according to the situation.
Finally, click "Save" to complete all settings!
Good job!
Using templates makes it easier to link apps, so it's recommended!
Examples of Other Automations Using Notion and Google Spreadsheets
Besides what we introduced today, Yoom has many examples of automation using Notion and Spreadsheets, so let me introduce a few.
Templates are available for all of them, so you can start using them right away.
Examples of Automation Linking Notion and Spreadsheets
By linking Notion and Google Spreadsheets, you can synchronize data between them and also integrate with other tools such as chat tools.
Examples of Automation Using Notion
Integrate Notion Data with Various Databases
In addition to spreadsheets, integration with various databases such as kintone and Salesforce is also possible.
Create documents based on Notion data
It is possible to automatically generate various documents such as quotes and invoices based on the data within Notion.
Automation Example Using Spreadsheets
Send Emails from Spreadsheet Data
Automatically send emails based on the data in the spreadsheet.
Link information registered in the spreadsheet to various databases
Automatically link information registered in the spreadsheet to various databases such as kintone and Notion.
Benefits of Integrating Notion and Google Sheets
Notion is suitable for task and project management, characterized by its ease of organizing information hierarchically in databases. Its intuitive operation, easy tagging and filtering within databases, and well-organized visuals make it ideal for team knowledge sharing. However, it is not suited for numerical analysis or detailed data manipulation involving large amounts of data.
Google Sheets excels in managing large volumes of data and performing calculations using functions. It allows for easy graph creation and data analysis, making it perfect for tasks involving data processing. However, it is not suitable for hierarchical information organization and is less user-friendly for internal knowledge sharing.
By integrating both services, efficient data management that leverages the strengths of each becomes possible, eliminating the hassle of switching between multiple apps. Additionally, the automatic integration of both services eliminates the need for manual data entry or copy-pasting, preventing duplicate entries and improving work efficiency while avoiding input errors.
Conclusion
Yoom is attractive for its ability to integrate with various apps and manage them centrally on Yoom, making it truly convenient as there's no need to switch between apps.
This article introduced the integration of Notion and Google Sheets, but Yoom also allows for the automation of schedule management by integrating Zoom and Google Calendar. There may already be trigger actions like the ones set up in this article available in Yoom, and you can use those templates as they are, so be sure to take advantage of them!
The person who wrote this article
s.yamashita
I worked as an SV in the BPO division of a listed company for 4 years and experienced editing and writing media articles for about 3 and a half years.
I had the opportunity to use a wide variety of apps due to my job being in charge of outsourced work from other companies.
I still remember getting to know Yoom when I was worried about how to improve work efficiency, and I was moved by being able to easily link apps with each other to create an automated flow!
I would be happy if I could help improve everyone's work efficiency by making use of my experience working on media articles and conveying the appeal of Yoom in an easy-to-understand manner.
Conventional RPA can only automate simple repetitive tasks, and the setup process was very complicated. With “hyperautomation,” which combines various technologies such as AI, API, RPA, and OCR, it is possible to automate many tasks that could not be realized until now more easily than before.
Most tools simply connect one app to another, leaving the complex tasks to you. Yoom goes much further: From document creation and browser automation to OCR and generative AI, Yoom handles it all seamlessly in one platform.
Why settle for basic integrations? Streamline your entire workflow with Yoom’s powerful hyperautomation.
.avif)
.png)
