Assistance Needed: Syncing Google Sheets with Notion for Row Updates

[Ricardo_Sue]

Hi, thanks for the suggestion regarding filtering bundles where column F exists. Just to understand, why is that particularly relevant in this case? I’m using the Watch Rows module, which returns all bundles by row, and the first two rows are headers from an automation I set up with Coefficient. As you can see in the video, starting from row 3 the fields are captured correctly.

Additionally, in the video I show that when I copy and paste an email value from column F, it seems to include a space—even though that space isn’t visible in the Google Sheet. That’s why I applied the trim() function in the Notion module to see if it would help, but it still didn’t work.

Do you think the issue might instead be related to how Make transfers data from the Google Sheets Search Rows module to the Notion Search Objects module? Any further insights would be appreciated.

Thanks again!

[Andrew_Saba]

Hello again, I tried that but it didn’t count any page as “archived = true” I searched the entire database, all pages returned “archived = false”

I also tried the same with the “in_trash” parameter, didn’t work. Do you think there’s another way to do this? Or does the “search database” module not account for archived/deleted tasks? Thanks for your time and help!

[Andrew_Saba]

Just tried the “Watch Database Items” module, it seems that it also doesn’t detect deleted or archived tasks.

If I select “choose where to start” then select “select manually”, it gives me a list of pages that the module has detected.

I then deleted the top page from my Notion database, and re-selected “choose where to start”, it wasn’t on top anymore, neither did I find it anywhere on the list.

Maybe another way to delete rows is to search all rows on google sheets, then search the Notion database, and delete rows where PageID does not exist in the Notion Database.

[Simo]

Hi Ricardo,
maybe that might be the issue. Based on my experience and knowledge, I think the Modules are working as expected. If the “Search objects” module receives a null value from column F (for example, from bundle 1 in your video), it returns an error

[Simo]

Ah sorry about that - yes it looks like archived pages are not included.

@Andrew_Saba

Maybe another way to delete rows is to search all rows on google sheets, then search the Notion database, and delete rows where PageID does not exist in the Notion Database.

Exactly, your proposed solution would work well in this case and I have used it in the past when syncing Google Sheets and Notion.

[bennbennett]

I know this is an extremely old thread, but I wasn’t able to find anything else that addresses this particular request (Sheets>Notion rows AND cells/properties). I’ve always had a difficult time setting up make.com scenarios for some reason (I’ve had a paid subscription for >1yr and I barely use it lol). If anyone can help me with this one, that would be hugely appreciated! I have:

I ran it once, and it found 199 “items” to update, but nothing was updated.

Any help would be greatly appreciated. Thank you!

[Simo]

Hi Benjamin,
It looks like you’re using the “Update a Database” module, but you would like to “Update database items” in Notion instead?

If so, use the “Update a database item” Notion module, in which case you need a way to map the desired database item ID (either you have it stored in the Google Sheets, or you can add a “Search objects” Notion module before “Update a database item”