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.