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.

Question

Filtered GoCanvas Loop data to Google Sheet

  • 25 August 2021
  • 6 replies
  • 64 views
G

Hi,

 

I’m trying to figure out if there is a way to only send certain row data from a GoCanvas loop screen to Google Sheet based on a condition from another field.

For example, I have data such as below. GoCanvas would typically pass this data by Column separated by a comma. e.g. “Was removed” = Yes,No,Yes :
 

Was Removed Model Serial Number
Yes A 123
No    
Yes B 345

 

I only want Zapier to send the Model and Serial number data IF “Was Removed” = Yes. i.e. Only send Google sheets Model A and Model B.

My current ‘standard’ zap sends all three rows. I thought of using a filter between Gocanvas and Google Sheet, but that only appears to read the whole comma delimited data for a field. i.e Yes,No,Yes so always runs. 

 

Thanks.

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

Troy Tessalone
Userlevel 7
Badge +14

Hi @Grant 

Try using the Looping app to handle line items (aka arrays): https://zapier.com/apps/looping/integrations

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
G

Hi Troy,

 

Thanks for the info. I tried doing a few different scenarios but I couldn’t get it to do what I need it to do. My current Zap will take the GoCanvas data (Step 1) and creates 3 rows (in the example above) in Google Sheet (Step 2). I can’t put the “looping by Zapier” between GoCanvas and Google Sheet steps as its not allowed (i.e to try and filter the data passed through). If you put the “looping by Zapier” after the Google sheet step then it will won’t change my Google Sheets data as its run after the data transfer.

From my limited understanding the only way to get this to work would be to output my Gocanvas data to a temp Google sheet, do the Looping by Zapier step to action a copy to my main Google sheet which would be cumbersome and easier to write a script.

 

Troy Tessalone
Userlevel 7
Badge +14

@Grant

Looping can be added between existing Zap steps, which is the purpose of iterating over line items in an array to then perform action steps.

Can you post screenshots of how your Zap steps are configured?

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
G

Hi Troy,

 

The option is greyed out if I try and add between the two action steps.

 

 

Troy Tessalone
Userlevel 7
Badge +14

@Grant

You can only have 1 Looping app per Zap.

Do you already have another Looping step in the Zap (not pictured)?

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
G

Hi Troy,

 

Yes that was the cause for that problem. Now managed to slot it in the correct location and setup the loop. Now it is passing all data still and also sending every line for every loop match.

 

 

Terms & Conditions