How to update Notion page properties when a row is updated in Google Sheets

[About Yoom]

‍How to Create a Workflow for Integrating Google Sheets and Notion

Let's set up the integration between Google Sheets and Notion, and automate your workflow.

Using a template, we will introduce the steps to create a workflow that "updates Notion page properties when a row is updated in Google Sheets".

Before You Begin

Please prepare both a Google Sheet and a Notion database to sync the update information.

*The diagram below is an example.

Step 1: Connect Google Sheets and Notion to My Apps

*If you have already connected the apps, please proceed to Step 2.

1. Log in to Yoom, select "My Apps" from the left menu, and click "+New Connection" on the right side of the screen.

2. From the new connection list in My Apps, select both Google Sheets and Notion, and connect the apps.

3. Next, copy the template to My Projects and create a Flowbot.
If you haven't copied it yet, please copy the Flowbot template from below.

Step 2: Setting a Trigger to Activate When a Row in Google Sheets is Updated

1. Open the copied template.
*You can change the title to any desired one from the red-framed part in the image below.

2. Click on the Flowbot's "App Trigger: When a Row is Updated".

3. Select the linked account and action.
Change the title if necessary and click "Next".

4. Set up the API connection settings for the app trigger.
Refer to the notes at the bottom of the section for input and selection of each item.
*The image below is an example input.

5. If the test is successful, click "Save".

Step 3: Setting an Action to Update Notion Page Properties

1. Click on the Flowbot's "Operate Database: Update Page Properties".

2. Set up the database integration.
・Title: You can change it to any desired name.
・Database Integration "Database ID": Enter the target ID referring to the notes at the bottom of the section.
*Reference: Common Errors and Verification Methods for Notion IDs

3. Click "Next".

4. Configure the detailed settings for database operations.
1) Conditions for the record you want to update: Set the conditions to specify the record to be updated.
2) Values of the record after update: Set the content you want to sync with Notion.
*You can refer to the output obtained in Step 2.
*The image below is an example.

5. Conduct a test, and if successful, click "Save".

Finally, switch the trigger of the saved flow to "ON" to activate it.

This completes the flow of "Updating Notion Page Properties When a Row is Updated in Google Sheets".

Other Automation Examples with Google Sheets and Notion

Besides the flow introduced this time, you can achieve various business automations using the APIs of Google Sheets and Notion. All of them can be used with simple settings, so if you find something interesting, please give it a try!

Automation Example Using Google Sheets

1. Create a folder in Google Drive when a row is added in Google Sheets

The timing of folder creation becomes consistently accurate, which can improve the efficiency of data organization. This allows you to quickly find the necessary files, contributing to increased work speed.

2. Notify Slack when a row is updated in Google Sheets

This is recommended for those who want to receive notifications every time data is updated in Google Sheets. When information is updated in Google Sheets, a notification is automatically sent to Slack based on the updated content, preventing errors from manual input. Additionally, notifications can be sent quickly after updates, facilitating smooth information sharing within the team.

3. Update kintone records when a row is updated in Google Sheets

This is a flow to automatically update kintone records when information in Google Sheets is updated. It quickly reflects the updated data and maintains consistency of information between the two databases.

Examples of Automation Using Notion

1. Create a folder in Microsoft SharePoint based on information from Notion

Not only can you add data to Notion, but you can also synchronize Notion data with other tools. It becomes even more convenient if you differentiate the flow depending on which tool you use as the core.

2. Summarize the contents of the minutes registered in the Notion database and notify Google Chat

You can also notify chat tools of the contents in Notion. When the minutes reach the chat tool, it becomes easier to check the contents of the meeting.

3. After the Zoom webinar ends, add the list of participants to Notion

This allows you to quickly compile participant information, saving time on organizing data. Additionally, because the participant list is promptly reflected in Notion, you can swiftly move on to the next actions.

Benefits of Integrating Google Sheets and Notion

1. Improved Data Consistency and Accuracy

Since the data in Google Sheets and Notion is automatically synchronized, the risk of input errors and omissions due to manual updates is reduced. It also helps in quickly sharing and utilizing the latest and consistent data among team members and other stakeholders.

For example, if you manage project progress in Google Sheets, you can automatically reflect that data on Notion's project page. This makes it easier for everyone to work based on the latest information. Additionally, if there are any concerns about the updated data, you can point them out using Notion's comment feature and keep a record of the Q&A.

2. Increased Work Efficiency

Automating repetitive update tasks can lead to a significant reduction in work time. Eliminating the need for manual data updates allows you to focus on other important tasks.

For instance, when a sales representative enters daily sales data into Google Sheets, that information is automatically reflected on Notion's dashboard. The time previously spent on data entry can now be used for preparing proposals or engaging in sales discussions. Moreover, managers can quickly grasp the overall sales situation on Notion's dashboard, issue instructions for additions or changes, and request reports.

Conclusion

By integrating Google Sheets and Notion, you can automate data synchronization during updates. This is expected to improve data consistency, accuracy, and work efficiency. Stop manual data updates and focus on other important tasks with the time saved. With Yoom, you can easily set up the integration without any coding, ensuring peace of mind even without technical knowledge. Please try the methods introduced.