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
Best answer
How do I identify and remove duplicate rows in Google Sheets automatically?
- Beginner
Best answer by blueguy
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
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Good question.
Some articles to reference:
https://support.google.com/docs/answer/6325535?hl=en&co=GENIE.Platform%3DDesktop
- Beginner
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!
+14- Zapier Orchestrator & Solution Partner
Try these Zap steps:
Action: GSheets - Lookup Row
Action: GSheets - Delete Row
- Beginner
I know those tools exist and I could conceive of a way of doing this; let me take a crack at it….
thanks
gml
- Beginner
- Answer
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
+11- Community Manager
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,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.