About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

Notion to Google Sheet: Zap not triggering on "Completed" status

  • 20 June 2023
  • 6 replies
  • 172 views
melaniegerbeaux
Userlevel 1

Hello everyone,

I need your help to solve an automation issue I'm facing. Here's the current configuration of my workflow:

I'm using the Notion application as a database. I've set up a filter in Zapier to filter new Notion pages. When a Notion page reaches the "Completed" status, I would like that page to be added as a new row in my Google Sheet. The issue lies in the filtering. Here's how I've configured my filter in Zapier:

"Continue only if... Notion - Status (text) contains Status: Completed"

Unfortunately, this configuration is not working. When my page in Notion changes to the "Completed" status, the automation doesn't trigger. Can you help me resolve this issue? I'm attaching screenshots to illustrate my problem.

Thank you in advance for your assistance.

Best regards,

 

 

icon

Best answer by christina.d 22 June 2023, 00:41

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

6 replies

melaniegerbeaux
Userlevel 1

And to complete my post, the status corresponds to a selection property in Notion. Thank you for your help.

christina.d
Userlevel 7
Badge +9

Hey there, @melaniegerbeaux! Thanks for reaching out in community. 🤗

Hmm, are you able to move this value to the first dropdown,:

keep (Text) Contains, and in the field below that type “Terminé”? Let us know how that works out for you! 🤗

 

melaniegerbeaux
Userlevel 1

Hello @christina.d , thank you for your quick response. Yes, I tried yesterday to write "Terminé," but it didn't work. I don't understand what's not working. 🤔

 

christina.d
Userlevel 7
Badge +9

Thanks for the screenshot! 

I reread and think I may have misunderstood the question. If you don’t mind would love to back up a bit to clarify something. 🙂

Is the item you’re looking to trigger off a new database item/page? Or is it an existing one that is changing to “completed”? If it’s existing we may need to switch to the Updated Database Item Notion trigger.
 

Does that sound more what you’re after? Keep us posted!

melaniegerbeaux
Userlevel 1

Hello @christina.d 
Great, thank you so much, Christina. That was my issue. Sorry for the trouble, it turned out to be a very simple problem...

Thank you for all 🙂

Mélanie

christina.d
Userlevel 7
Badge +9

Nothing to apologize for! Exactly what we’re here for!

Glad to hear it’s working now and appreciate you keeping the thread updated on your win. 🙂🎉

Terms & Conditions