The update of customer dashboard from Notion to Google spreadsheet

How To
,
1

Hello, everyone.

I would like to link the customers database in Notion with Google spreadsheet database with the real-time update
Below is the scenario I made;

  1. Notion “Watch Database items”
  2. Google sheets “Search Rows” (Filter: Database item ID in Notion will be the key for filtering)
  3. Router, Total number of bundles is 0 or more.
  4. If this is more than 0, Google sheets “Update a Row”.
  5. If this is 0, Google sheets “Add a Row”.
    image
    image1596×1048 71.6 KB

    image
    image1057×1291 88.3 KB

It was successful to update the data from Notion to Spreadsheet at any time.
But when something in the Notion database is deleted to the blank, anything will be changed in Spreadsheet.

I guess my scenario cannot capture the change from “something” to “blank”.
Do you have any complementary way for my scenario?

2

Hello, in the Google Sheets modules, you could try to use the “ifempty()” function to override existing cells with blank values. For example:

ifempty({{notionPropertyXYZ}};{{emptyString}})

3 Likes
3

Thanks, Simo!

I tried to use ifempty function like the below.
image
But when I delete some property, in the spreadsheet, the property has still remained.
If I see the input of Google sheet module, it looks like just the blank cell(column F) has not picked.

image
image655×970 40.2 KB

My usage of formula is correct?
I highly appreciate!!

4

Did you select emptyString from the helper functions in Make, or just typed {{emptyString}}? If the latter, try selecting emptyString from the Make functions and let us know how it goes

3 Likes
5

I succeed with your advice!!

Thank you so much!!

3 Likes