Skip to main content
Best answer

Filtering between two GoogleSheets


Hi I have a problem with Zapier automations. I have a Calendly account where I have 2 events that need to write data to 2 different Google Sheets. In the end, after writing in their respective Google Sheets, they send an email, also personalized. To do this I used Zapier's filters to distinguish the 2 Google Sheets. The problem is that subscriptions go to both Google Sheets and not the specific one. Because? Thanks Fabio

Best answer by GetUWiredBest answer by GetUWired

You will need to type the event name not use dynamic data. Right now you are matching dynamic data to dynamic data which will always be true. See attached. 

 

View original
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.

8 replies

GetUWired
Forum|alt.badge.img+12
  • Zapier Expert
  • 1030 replies
  • February 9, 2021

Hi @FabioSD 

Can you please share screenshots of how you have your Zaps configured? That will help us get a better idea of what could be going on.

Thanks!


  • Author
  • Beginner
  • 5 replies
  • February 9, 2021

Hi here are some screenshots.
As you can see, I have inserted a filter to distinguish between the 2 Calendly events and write either in one sheet or the other.

A curiosity what does Invitee B or Invitee A mean in the first step?

However, the problem is that filters don't sort into their respective sheets

Thanks
Fabio


GetUWired
Forum|alt.badge.img+12
  • Zapier Expert
  • 1030 replies
  • Answer
  • February 9, 2021

You will need to type the event name not use dynamic data. Right now you are matching dynamic data to dynamic data which will always be true. See attached. 

 


GetUWired
Forum|alt.badge.img+12
  • Zapier Expert
  • 1030 replies
  • February 9, 2021

Invitee B and Invitee A are just generic names for the instances of the data you’ve pulled. They have no concrete meaning to them. 


  • Author
  • Beginner
  • 5 replies
  • February 9, 2021

Hi so I have to manually write the name of the event?
See screenshot
Thanks Fabio


GetUWired
Forum|alt.badge.img+12
  • Zapier Expert
  • 1030 replies
  • February 9, 2021

@FabioSD Yep!

 

That way its checking to see if the event exactly matches the name you typed.
That should fix it!

 

 


  • Author
  • Beginner
  • 5 replies
  • February 10, 2021

It is true by manually entering the name of the Calendly event now the filter works!
Thank you very much


GetUWired
Forum|alt.badge.img+12
  • Zapier Expert
  • 1030 replies
  • February 10, 2021

@FabioSD 

Glad to help!