Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Notion-Zapier google sheets delay function

  • May 27, 2024
  • 1 reply
  • 21 views
L

Hi there! 

 

I have set up an automation between Notion-Zapier and Google sheets but I am looking for help on working with the delay. 

 

How I have set it up currently is New database item in Notion database- Delay of 1 hour- Create spreadhsheet row in Google Sheets. This has allowed me to import historical data from Notion tables but does not bring in new data. 

 

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?

 

 

Screenshots attached.

 

Thank you! 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • May 29, 2024

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!

Terms & ConditionsAccessibility statement