Skip to main content
Question

How to push and create a spreadsheet row(s) in google sheet only if a value is present?

  • September 21, 2022
  • 2 replies
  • 62 views

I have set up a catch hook in webhooks by zapier from our ecommerce store to a google sheet (Create Spreadsheet Row(s)) and in between created a filter action to only continue if a variable exactly matches a specific name. The problem is that with our ecommerce store users can buy different products at once and the way it is pushing to the google sheet is that if that value exists, it pushes all of the other values too. But what I basically want to do is to only push to the google sheet rows that contain the filter and to disregard everything else. I thought of adding a second action filter and a second spreadsheet row(s) in google sheet but it is still pushing all the variables that if the filter exists, pushes everything into the google sheet. How can I get through this? 

 

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30982 replies
  • September 21, 2022

Hi @Eduardo13 

Good question.

Try using the Looping app to handle 1+ line items: https://zapier.com/apps/looping/help

Within the Looping app you can add the Filter step.


jesse
Forum|alt.badge.img+9
  • Architect
  • 1348 replies
  • September 26, 2022

Hey @Eduardo13 Were you able to try out Looping as Troy suggested? How are things going? Anything we can lend a hand with?