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.

Best answer

Find & Format Google Sheets Data

  • April 13, 2023
  • 4 replies
  • 76 views
M
Forum|alt.badge.img+1

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 

Best answer by chanelle

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! 

1 Attachments
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
Forum|alt.badge.img+1

here is the screenshot if it is not loading

1 Attachments
chanelle
Forum|alt.badge.img+8
  • chanelleZapier Staff
  • Zapier Staff
  • April 13, 2023

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
Forum|alt.badge.img+1

Hello Chanelle,

 

Here are the screenshots thank you

4 Attachments
chanelle
Forum|alt.badge.img+8
  • chanelleZapier Staff
  • Zapier Staff
  • Answer
  • April 14, 2023

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 & ConditionsAccessibility statement