I would like to create a zap from an Trigger event update of the Notion database but this does not exist for the Beta version. Is it planned to have this functionality and if so when? The latter is really important to all of your users.
Thanks in advance.
Page 3 / 4
I wonder for these use cases where we need to be more granular if a Filter by Zapier step would work? A very similar workflow came up yesterday and they were using a filter to only trigger on a specific property:
Let us know if you think that could work!
It won’t work in general case. To determine which fields were changed you need to know their values before the update. But Updated Database Item event doesn’t give you the previous values, just the current ones.
I wrote a Zap and tested it today using the filter method and Notion’s Status field. One weird thing I discovered is that the “Status” property type doesn’t show in the properties when pushed to Zapier. As a workaround, I added a Formula field with “prop(“Status”)” to duplicate the status as text into the formula field. This comes across fine via API.
So my flow is: User changes status → Notion formula field auto-updates → Zap is triggered on status update → Whatever I want Zapier to do (in my case, Discord notification)
In testing it seems to work fine (around 1.5min delay, but usable)
@ColinM
Notion Zap triggers are “scheduled” (via API polling) and are not instant (via webhooks).
Scheduled app triggers can take from 1-15 minutes to trigger depending on your Zapier plan.
@ColinM
Notion Zap triggers are “scheduled” (via API polling) and are not instant (via webhooks).
Scheduled app triggers can take from 1-15 minutes to trigger depending on your Zapier plan.
Yep, they even have a notification for that when building the Zap. I have absolutely zero issues with that kinda delay. Just like we talked about on Twitter, it’s how Make has been doing things. Glad Zapier was able to implement!
I wonder for these use cases where we need to be more granular if a Filter by Zapier step would work? A very similar workflow came up yesterday and they were using a filter to only trigger on a specific property:
Let us know if you think that could work!
It won’t work in general case. To determine which fields were changed you need to know their values before the update. But Updated Database Item event doesn’t give you the previous values, just the current ones.
After further testing the limitations, Basil is correct. For example, I tried creating a “change log” of what users edited what things in a Notion database. While I can create “User X changed something about entry Y”, it is currently not possible to specify what specifically was changed.
For example, if I want to know what sales rep closed a deal, I can create a Zap with the trigger “Updated Database Item” and the filter to only trigger if “Deal Stage = Closed”. However, if a sales rep were to go back and change any field for a deal that is already in the stage “Closed”, the Zap will also run. It’s not actually looking for a change in Deal Stage, just checking to see if the field matches the filter. So unfortunately I will end up with a lot of erroneous “Closed Deals” that are really just deals being updated in other ways.
On the other hand, I have found that this works well for empty fields that require a date input to log when a specific change was made.
One of Notion’s shortcomings is that it cannot timestamp when changes occur at the field level. Using the above example of closed deals, I created a new date field in Notion called “Closed Date”. In my Zap, I have the trigger set to “Updated Database Item” followed by two filters.
Filter #1: if “Deal Stage = Closed”
Filter #2: If “Closed Date = Does not exist”
This way, the Zap will trigger the first time the Deal Stage is changed to closed, but will not continue updating the closed date on consecutive edits to that deal.
The real killer update from Notion would be the ability to have field-level update triggers. However, this is a step in the right direction as now I can capture dates of changes that I wasn’t able to capture before.
I wonder for these use cases where we need to be more granular if a Filter by Zapier step would work? A very similar workflow came up yesterday and they were using a filter to only trigger on a specific property:
Let us know if you think that could work!
It won’t work in general case. To determine which fields were changed you need to know their values before the update. But Updated Database Item event doesn’t give you the previous values, just the current ones.
After further testing the limitations, Basil is correct. For example, I tried creating a “change log” of what users edited what things in a Notion database. While I can create “User X changed something about entry Y”, it is currently not possible to specify what specifically was changed.
For example, if I want to know what sales rep closed a deal, I can create a Zap with the trigger “Updated Database Item” and the filter to only trigger if “Deal Stage = Closed”. However, if a sales rep were to go back and change any field for a deal that is already in the stage “Closed”, the Zap will also run. It’s not actually looking for a change in Deal Stage, just checking to see if the field matches the filter. So unfortunately I will end up with a lot of erroneous “Closed Deals” that are really just deals being updated in other ways.
On the other hand, I have found that this works well for empty fields that require a date input to log when a specific change was made.
One of Notion’s shortcomings is that it cannot timestamp when changes occur at the field level. Using the above example of closed deals, I created a new date field in Notion called “Closed Date”. In my Zap, I have the trigger set to “Updated Database Item” followed by two filters.
Filter #1: if “Deal Stage = Closed”
Filter #2: If “Closed Date = Does not exist”
This way, the Zap will trigger the first time the Deal Stage is changed to closed, but will not continue updating the closed date on consecutive edits to that deal.
The real killer update from Notion would be the ability to have field-level update triggers. However, this is a step in the right direction as now I can capture dates of changes that I wasn’t able to capture before.
Don’t listen to the last part of what I said. Come to find out, Filter #2 is not working as described on Zapier’s page about using filters. It turns out “Closed Date = Does not exist” is literally looking to see whether or not that field exists, not whether or not it has data in it. See the recent comments on this thread.
As a result, my actions on Zapier have been significantly eaten through as fields were updated that should not have passed the second filter. @christina.d, it looks like over 1,000 actions on my account were cannibalized due to this issue. What is the best path to getting those actions re-instated on my account?
Screenshots for reference. The first screenshot shows that there is data in the “Closed Date” field. The third screenshot shows that the filter for “does not exist” is still passing despite there being data.
Illustrating that the field “Closed Date” is passing dataData is passing through this step as expectedData should not be passing this step
@ColinM
You shouldn’t need 2 Filters.
1 Filter with 2 conditions will work.
That will also save 1 Task.
Also, the value would be ClosedDatestart, instead of ClosedDate, as start is a property of ClosedDate that has the actual value.
So the Filter was actually working as expected, because there is no value for ClosedDate, thus ClosedDate does not exist.
@ColinM
You shouldn’t need 2 Filters.
1 Filter with 2 conditions will work.
That will also save 1 Task.
Also, the value would be ClosedDatestart, instead of ClosedDate, as start is a property of ClosedDate that has the actual value.
So the Filter was actually working as expected, because there is no value for ClosedDate, thus ClosedDate does not exist.
“Closed date start” is not an option when selecting fields for filtering.
@ColinM
You shouldn’t need 2 Filters.
1 Filter with 2 conditions will work.
That will also save 1 Task.
Also, the value would be ClosedDatestart, instead of ClosedDate, as start is a property of ClosedDate that has the actual value.
So the Filter was actually working as expected, because there is no value for ClosedDate, thus ClosedDate does not exist.
“Closed date start” is not an option when selecting fields for filtering.
Apologies, I did find it after all. You have to search by “Start”. Thanks also for the recommendation on two filter statements in one step. I’ll do some more testing this afternoon and hopefully it will work.
And me too, please.
Please link me to this feature request. This is an essential part of the Notion <> Zapier integration.
@jammer.solijon I asked also to be linked to the feature request
Hi @shopping_jaws
I’ve added your vote for this feature request, and we’ll notify you via email once an update is readily available. Thanks.
Hi @Saden
I’ve added your vote for this feature request and we’ll notify you via email once an update is available. Thanks!
Hi @davislatham@patrickgreene
I’ve added both of your votes for this feature request, and we’ll notify you via email once an update is available. Thanks!
Would like to be added to the list as well… DESPERATELY need this
Hello @jammer.solijon I would like my vote added to the feature request as well. Can you please link the feature request so we can keep up with it?
As others previously noted, there was the option to do this for a short time. It would be amazing to automate this, tons of really neat things we could do with it….
Hi @Sathors, @Tinkin Transversal
I’ve added both of your votes for this feature request, and we’ll notify you via email once an update is available. Thanks!
Hi @annief
I’ve added your vote for this feature request, and we’ll notify you via email once an update is readily available. Thanks. And @davislatham, I already added your vote for this request too.
Hi @jammer.solijon , could you add me to the list as well? Thanks
Hi @tedjober and @ks-lovtsova
I’ve added both of your votes for this feature request, and we’ll notify you via email once an update is available. Thanks!
Hello! I’d love to be added to the list too, please
Hello.
This feature will be very useful.
Can you add me to the list?
Could you add me to that list as well? I struggle with creating a database item, and the Zapier trigger grabbing too early, leaving all of my data empty from what Zapier pulls.
I’d love to be added to the list as well!
Hey there - @MoonRoom, @AugustinLydia, and @Wrappr! I’ve got your votes added for this feature request.
Sorry to say, I don’t have any updates or an ETA to share but we’ll absolutely email you if and when that changes!