Hi! We are trying to push the information that we are receiving in Google sheets two different directions. (If they say yes I want them to go into one group in Agency elephant, if they say no I want them to be zapped into another)
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+1Hi Lindsey!
How do you want to determine where the data goes? Is it a column in the Google Sheet, or is it something different? I’m assuming a column for this answer, but let me know if it’s something else.
First, you’ll need to set up a trigger to be Google Sheet’s “New or Updated Spreadsheet Row”
You’ll key off the data in the column (Yes/No values) to decide what to do with it. There are a few ways to do this:
- Simplest would be to use a Paths action that puts them into 1 group in the case of Yes values and a different group in the case of No values. That said, Paths are only available on the Professional plan and higher. If you’re not on this plan, then you could:
- Create 2 different zaps that both start with the same Google Sheets trigger. Use a filter step in one zap to filter for “Yes” values and then send those to one group. Use a different filter in the other zap to filter for “No” values and then send those to the other group
+7- Zapier Staff
- 386 replies
Hi there
Let us know either way-
Rachael
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.