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

How do I identify and remove duplicate rows in Google Sheets automatically?

  • 23 August 2023
  • 6 replies
  • 254 views
B
Userlevel 3
Badge +3

Is there a tool or a work around where you can identify a duplicate row within a Google Sheet and remove that row?  Of course, all of this has to be done seamlessly, daily and automatically.

 

Just curious…..thanks

 

gml

icon

Best answer by blueguy 25 August 2023, 03:06

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

6 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @blueguy 

Good question.

Some articles to reference:

https://support.google.com/docs/answer/6325535?hl=en&co=GENIE.Platform%3DDesktop

https://zapier.com/blog/remove-duplicates-google-sheets/

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
B
Userlevel 3
Badge +3

Troy

Thanks as always!  I know how to do that basic task in Google Sheets; I was looking for away to automate that process in Zapier.  That would be a cool feature!

 

 

Troy Tessalone
Userlevel 7
Badge +14

@blueguy 

Try these Zap steps:

Action: GSheets - Lookup Row

Action: GSheets - Delete Row

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
B
Userlevel 3
Badge +3

I know those tools exist and I could conceive of a way of doing this; let me take a crack at it….

 

thanks

 

gml

B
Userlevel 3
Badge +3

Some follow up…

 

Using the look up row and then delete row feature does work; of course you have to look from the top of the sheet because if you look from the bottom of the sheet you will always get the row that triggered the result in the first place

 

Otherwise, good call and easy to do.  Thanks

 

gml

SamB
Rank
Userlevel 7
Badge +11

Thanks so much for circling back in here to let us know how you got on with Troy’s suggestion of using a Lookup Spreadsheet Row and Delete Spreadsheet Row action, @blueguy. The Community greatly appreciates it! 🤗 

Terms & Conditions