How to integrate Google Sheets with Notion to create a page in Notion when a row is added in Google Sheets

When you receive a lot of emails every day, it can be quite a hassle to save files to Dropbox each time.
Moreover, many people might have experienced the struggle of missing a file save or saving a file in the wrong folder, making it difficult to find later.

In this article, we will introduce a method to automatically save files received in Gmail to Dropbox!

By using no-code tools, you can easily set up automation between Gmail and Dropbox.
You can start using it right away, so be sure to give it a try!

Recommended for

Those who want to automatically upload files attached to Gmail to Dropbox
Those who want to integrate Gmail and Dropbox to facilitate smooth file sharing within the team
Those who want to prevent the loss of attachments and ensure proper document storage

For those who want to try it immediately

In this article, we will introduce the integration method using the no-code tool "Yoom".

No complicated settings or operations are required, and even non-engineers can easily achieve it.

You can start right away using the template below, so please give it a try!

With the evolution of digital tools, streamlining operations and sharing information within teams are becoming increasingly important.
In particular, the integration of apps used daily contributes significantly to smoother data management and collaboration between teams, thereby enhancing overall productivity.
This time, we will explain how to further improve data management efficiency by integrating Google Sheets and Notion.
We will introduce a method that can be easily set up without programming knowledge. Please use it as a reference!

Benefits of Integrating Google Sheets and Notion

Benefit 1: Centralized Data Management

Integrating Google Sheets and Notion allows for centralized data management.
For example, if you record detailed information in Google Sheets and use Notion to share an overview with the entire team, you can add data to Notion simply by adding information to Google Sheets.
This is expected to smooth out information dissemination and reduce information discrepancies.

Benefit 2: Reduction of Manual Work

With the integration, when a row is added in Google Sheets, a page is automatically added in Notion, reducing the need for manual data entry.
For instance, when the sales team adds a new lead to Google Sheets, it is automatically added to Notion, saving the effort of data entry and allowing focus on more important tasks.

[About Yoom]

How to Create a Google Sheets and Notion Integration Flow

Step 1: Register/Login to Yoom and Register Apps

First, please access the official Yoom website and create an account.
If you already have an account, please log in.
Yoom Account Issuance Page

After logging into your Yoom account, register the apps you will use.
1) Click "My Apps" and select "New Connection."

2) Select the app you want to register and log in with the account you use for each app.

3) Once registered, an icon will appear in My Apps.
Check if the icons for the two registered apps are displayed.

Step 2: Select a Template

This time, we will create a flow that [Creates a Page in Notion When a Row is Added in Google Sheets].
By using this template, you can automatically create pages in Notion, reducing manual work and minimizing the risk of human error.
This is expected to lead to smoother and more accurate information sharing.

Step 3: Setting Up Integration Between Google Sheets and Notion

‍
0) Since this flow adds information from Google Sheets to Notion, you need to create a corresponding Notion database in advance. Please prepare the database with the necessary fields.

1) Click the "Try this template" icon on the previously introduced template and copy it to My Projects.

2) The following display will appear.

Follow the instructions and click the flow icons with "!" on the right in order to edit them. You can change the title and details by clicking on them. Please modify them to make them user-friendly.

3) Click "App Trigger: When a row is added".

4) Select "When a row is added" for the trigger action and click "Next".

5) Select "Trigger Interval" and enter the required fields. The Spreadsheet ID and Sheet ID are registered in the app, so you can select them from the options. Once all entries are complete, click "Test". If the test is successful, click "Save".

‍

6) Return to the flow and click the "Integrate with App: Create Page" icon.

7) Select "Create Page" for the action and click "Next".

‍

8) Enter each field.

Select the database you created earlier for the Database ID. You can reference the output information from the Google Sheets you integrated earlier, so quote from the options as needed. Once the entries are complete, click "Test". If the test is successful, click "Save".

9) Return to the flow and click the "Operate Database: Update Record" icon.

‍

10) Select "Update Record" for the action and enter the required fields. Once the entries are complete, click "Next".

11) For the condition of the record you want to update, select "Equals" and enter the value for the updated record. You can reference the output information from Notion you integrated earlier, so quote from the options as needed.

Once the entries are complete, click "Test". If the test is successful, click "Save".

‍

12) This completes the flow of 【Creating a Page in Notion When a Row is Added in Google Sheets】.

Step 4: Testing and Verification

‍13) Once the setup is complete, the following display will appear, so click "Turn on Trigger". Start the flow bot and check if it operates correctly once.

Here is the template used this time

Other Examples of Automation Using Google Sheets and Notion

There are other automation templates using Google Sheets and Notion available on Yoom, which I will introduce.

The following two examples have similar flows, but the final action in Notion differs.
In the previously introduced template, a page was created, but there are also templates for updating Notion properties or adding text.

1. Flow to Update Notion Page Properties When a Row is Updated in Google Sheets
‍When information is added to Google Sheets, the Notion page properties are automatically updated, eliminating manual input and reducing the time spent on tasks.

‍

2. Flow to Add Text to a Notion Page When a Row is Added in Google Sheets
When information is added to Google Sheets, text is automatically added to a Notion page, eliminating the need for manual input and reducing the time required for the task.

‍

There is also a flow that notifies Google Chat after storing it in Google Sheets.

3. When information is added to the Notion database, store it in Google Sheets and notify Google Chat
Newly added information is automatically stored in the Google Sheets database and notified to Google Chat, which can help prevent omissions or leaks in information management.
Additionally, since the trigger is activated by registration or update in the Notion database, you can create a complex flow that uses creation or update dates to separate registration and update routes and notify Google Chat through branching operations.

Summary

By integrating Google Sheets with Notion, you can automatically create a page in Notion when a row is updated.
This reduces manual work, improves data management efficiency, and minimizes human errors.
Additionally, using Yoom allows you to easily set up the integration without any coding.
Please use this article as a reference and try integrating the apps!