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.

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

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

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!

 

 

@blueguy 

Try these Zap steps:

Action: GSheets - Lookup Row

Action: GSheets - Delete Row

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

 

thanks

 

gml

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

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