Best answer

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

  • 23 August 2023
  • 6 replies
  • 329 views

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

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! 🤗 

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

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

Userlevel 7
Badge +14

@blueguy 

Try these Zap steps:

Action: GSheets - Lookup Row

Action: GSheets - Delete Row

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!

 

 

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/