Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

  • Home
  • Get Help
  • How Do I
  • How do I filter Google Sheets data by specific parameters and send the results to a new sheet?

hello all,

Im trying to make automation that searching in exist and full google sheet specific name with specific parameters that i will give and send the specific name that he find to new sheet(this part i know hot to do)

for example: i have a sheet that have:Name, year of birth, starting month and gender.

and i what that in the end of May let say.. May 25 it will take all the names that they Starting month is July and they are Mans to a new google sheet.

 

thanks for you help

Hi @YairSabag 

Can you please clarify your question by outlining specific examples with screenshots?

I will try .. :)

I have spreed sheet with few columns(exemple): Name-Year of birth-Gender-Starting Month-Job-Group

The row look like that..Yair - 1981 - Male - May - Engineer - Devops.

So i want that every end of month lets say every 25th of any Month the automation will take all the rows that contain: Year of birth is not 1980, Male and from Devops Group, to a new spreed sheet that i will give him.

I hope its more clearly :)

Thanks!

@YairSabag 

If you are trying to use GSheets, then you may have to explore using the GSheets API to do advanced querying.

Try using the AI assist to configure the Zap action: GSheets - App Extensions

 

You may want to explore using Airtable instead of GSheets.

Airtable has Views, which are segments of data. (sort, filter, group, show/hide fields, reorder fields)

 

Thanks for that, i’m trying something but i cant see on the Value the words that appear on my Sheet like i see on the Column Field.

 

@YairSabag 

There are 2 fields that work together.

  • Lookup Column
    • This will be a specified column header
  • Lookup Value
    • Here you will provide the value to search for in the selected Lookup Column

 

i understand but at the Domain Column i have dropdown in my Sheet with few words, and at the Lookup Value i dont see them to choose what to filter..

@YairSabag 

In the Lookup Value field you need to either provide a static value or map a dynamic variable from a previous step.

thanks again but im misunderstood..:)

 what should i pick at Lookup Value if i need one of this? i dont see this parameters on the Lookup Value filed

o.k i was secced! but how i let him to pick multi rows with the same parameters?

 

o.k all done except one thing...how can i add more Lookups? there is just 2(Lookup and supporting Lookup)

Any idea how to do it?

@YairSabag 

You would need to create a field in the GSheet with concatenated values if you are trying to search for 3+ conditions.

Terms & Conditions