Question

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

  • 21 September 2022
  • 2 replies
  • 53 views

Userlevel 1

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? 

 


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

Userlevel 7
Badge +14

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.

Userlevel 7
Badge +9

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