Linking Notion Database with Google Spreadsheet: A Guide for Make Users

Hello, everyone. Today, I'm going to share with you a solution to a problem that some of you might have encountered while trying to link your customer database in Notion with a Google spreadsheet for real-time updates.

The Problem

The scenario is as follows: You have set up a Notion 'Watch Database items' and a Google Sheets 'Search Rows' with a filter based on the Database item ID in Notion. You have also set up a router to check if the total number of bundles is 0 or more. If it's more than 0, Google Sheets 'Update a Row' is triggered. If it's 0, Google Sheets 'Add a Row' is triggered. This setup successfully updates the data from Notion to Spreadsheet at any time. However, when something in the Notion database is deleted to the blank, nothing changes in the Spreadsheet. The problem seems to be that the scenario cannot capture the change from 'something' to 'blank'.

The Solution

The solution to this problem is to use the 'ifempty()' function in the Google Sheets modules to override existing cells with blank values. For example, you can use 'ifempty({{notionPropertyXYZ}};{{emptyString}})'. This function checks if the Notion property is empty, and if it is, it replaces it with an empty string in the Google Sheets.

Troubleshooting Tips

If you try this solution and find that when you delete some property, the property still remains in the spreadsheet, check the input of the Google sheet module. If it looks like the blank cell has not been picked up, make sure you have selected 'emptyString' from the helper functions in Make, rather than just typing '{{emptyString}}'.

Conclusion

In conclusion, the 'ifempty()' function in Google Sheets can be a useful tool for ensuring that changes from 'something' to 'blank' in your Notion database are reflected in your Google Spreadsheet. Remember to select 'emptyString' from the helper functions in Make to make this work. I hope this solution helps you in your automation tasks!

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.