I’m trying to create an automation between Google Sheets and Notion using Make. Specifically, I have a Google Sheet where:
New rows are added regularly.
Existing rows are updated frequently.
What I need is for these changes in Google Sheets (both new rows and updates to existing rows) to trigger updates in specific fields of a Notion database. Essentially, I want my Notion database to reflect the most recent state of the Google Sheet.
Could you please guide me on how to set up this scenario correctly? I’m looking for the best way to achieve this, ensuring seamless synchronization between the two platforms.
Thank you for your assistance, and I look forward to your advice.
Oh man. I want to do the same thing only the other way around. I have a Database in Notion that I want to sync with a Google Sheet.
It pains me that no one has answered in more than 1 month to you.
Maybe now? Anyone? Help us?
Personally I managed to ADD new ROWS to the Sheet whenever I am doing an update, but this is adding a new ROW. I am also appending changes to Cells. Not only that, but in 1 “run” I could have new rows, but also changes to cells.
I managed to have huge success doing this. I can basically right now get new rows in, update rows that have modifications.
I am trying to make a new Automation that will compare the 2 tables and if the table doesn’t exist in Notion anymore, also delete it from the Spreadsheet. I’m having some problems here.
One thing that I have a problem with is that I have done this using Notion → Search Object. But ideally this script will run only when I do some changes in my Notion Database. I see that “Watch Database Items” exist, but how is that working? I still seem to have a timer that I configure.
“Watch database items” polls for new/updated database items in the selected Notion database. This check happens on the frequency you set in the scenario (the most frequent is every 1 minute). This trigger will run every time there is a change in ANY property in the selected Notion database.
If you want to save operations and trigger the scenario immediately upon specific property changes instead, you can use Webhooks (video explaining how they work here)
So basically the watch database items will only send new and updated rows. Right now the way I did it Notion sends all the tables. Not sure how it is ideal, but what I know is that this is an operation that should run only when I make changes. I will look into web hooks.
can you share the exact scenario structure, i can’t seem to make it work for me. Thanks!
