Hi @Ldgfy reporting, welcome to the Community!
What I need is for the trigger to be dynamic and not pull in only a new database item but any edits made within 1 hour. How can I achieve that?
Am I correct in thinking that you’re wanting the Zap to trigger on a new item, wait for an hour so that you can add the new item along with any edits that have been made to that same item in the past hour?
If that’s the case, you’d need to use a Find Database Item after the Delay action to get the current details for the item that triggered the Zap. I should note that it will not return the main content/body of the database item, only it’s properties.
If you are wanting to add the content of the database item to the Google Sheet let me know as there’s an existing feature request for the ability to access the content/body of the database item which I can add your vote to.
Alternatively, are you wanting to trigger for updated database items? If so you could have another Zap that uses Notion’s Updated Database Item trigger. Then you’d use a Lookup Spreadsheet Row (Google Sheets) action to find the corresponding row. Followed by a Update Spreadsheet Row (Google Sheets) action to update that row with the changes.
Hope that helps to get you pointed in the right direction. If you run into any issues on that or have further questions please let me know!