I am trying to build a “stale bot”, that triggers whenever a Notion page hasn’t received any activity for a certain time. Specifically, when the Status property of the page is set to a certain state, e.g. “WIP” and then the page does not get any input for a week. Then a message should be send in Slack to the doc owner or a certain Slack channel.
You’ll likely need to log these events to then check against such as in a GSheet or an Airtable Base.
GSheets - Lookup Row
Airtable - Find Row
Thanks Troy! Can you elaborate on that a bit more? How would I log these events?
This would be a separate Zap to log the entries...
Action: GSheets - Add Row
Action: Airtable - Create Row
Problem is that Notion does not have any trigger on changes in the page or database, only “new database item added”, meaning I wouldn’t be able to log any changes, not even with GSheets - Add Row - or am I misunderstanding something?
Check to see if the Notion Find Database Item returns the Last Edited Time field.
Otherwise the Notion API would have to be used: https://developers.notion.com/reference/retrieve-a-page
App APIs can be used in Zaps with the Webhooks app as an action step: https://zapier.com/apps/webhook/help