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.

Best answer

Find & Format Google Sheets Data

  • 13 April 2023
  • 4 replies
  • 65 views
M
Userlevel 1
Badge

Hello,

 

I am using the “Find Spreadsheet Rows in Google Sheets” function, to see if there are duplicate entries in separate rows of a spreadsheet.

 

As you can see from the screenshot the output is showing 3 rows containing the same number. 

 

I want to add a filter step so that the zap will only continue if there is more than 1 row in the spreadsheet with the same data in it. 

 

How would I achieve this? I have been trying using a format step with no luck  

 

Thank you 

icon

Best answer by chanelle 14 April 2023, 20:18

View original
1 Attachment
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

M
Userlevel 1
Badge

here is the screenshot if it is not loading

1 Attachment
chanelle
Userlevel 7
Badge +8

Hi @Mitchell Zezima, I’d love to help out with this. Can you please do me a favor and add screenshots of each Zap Step setup you have? This will help me determine any options you may have to accomplish setting up this Zap. Please be sure to blur any identifying or personal information from the screenshots! 

M
Userlevel 1
Badge

Hello Chanelle,

 

Here are the screenshots thank you

4 Attachments
chanelle
Userlevel 7
Badge +8

Hi @Mitchell Zezima thanks for sharing the screenshots! I do see that the screenshots start with the trigger and then move directly into action step 11. This may take a deep dive to help you figure out, and unfortunately in the Community, we aren’t able to take a look directly into your account. 

My advice for this situation based on your user plan, would be to reach out to our support team, or one of our lovely experts! 

Terms & Conditions