Remove Duplicates for Google Sheets – Automation

Learn 2 ways to find, remove & highlight duplicates in Google Sheets automatically. Save the settings into reusable scenarios or schedule their autostart.
👉 Install Remove Duplicates from the Google Sheets store: https://workspace.google.com/marketplace/app/remove_duplicates/347814268012

00:04 Intro
00:12 Why Remove Duplicates – recap
00:35 Create your 1st scenario
00:53 Run scenario – find duplicates in a click
01:06 Schedule Remove Duplicates autostart
01:47 Track the runs in a log sheet
02:11 Wrap-up

📚 Detailed tutorials on our website:
💡 How to work with scenarios: https://www.ablebits.com/docs/google-sheets-find-duplicate-rows/#use-scenarios
💡 Run scenarios on schedule: https://www.ablebits.com/docs/google-sheets-find-duplicate-rows/#schedule-scenarios

👋 Let's be friends on socials!
LinkedIn: https://linkedin.com/company/apps4gs/
Facebook: https://www.facebook.com/ablebits/

🎵 Upbeat Corporate by JP Bianchini | https://soundcloud.com/jpmbianchini
Music promoted by https://www.free-stock-music.com
Creative Commons Attribution 3.0 Unported License
https://creativecommons.org/licenses/by/3.0/deed.en_US

#spreadsheet #googlesheets #duplicate #removeduplicates #ablebits

---

Closed Caption:

Did you know that your Google Sheets 
can find duplicates automatically?
You just need one special add-on 
for that – Remove Duplicates.
Remove Duplicate Rows offers not only 
the advanced search
that can look for uniques
and even their 1st entries,
but also some extra ways
to deal with them
such as highlight, mark in a status 
column, copy, move, or delete.
And here's the best part:
you can skip all these steps in future 
by saving these settings into scenarios.
Scenarios will find & handle duplicates 
automatically, but you decide when it happens.
Once you name your scenario; assign a 
file, its tab and a range to process;
and review the options
you're about to save,
it's high time to decide on the way
to execute this scenario.
If you don't tick off this checkbox, next time 
you need to find duplicates in Google Sheets,
you will have to call for this scenario
from the Google Sheets menu.
The add-on will start & 
process your data immediately.
But! If this is still
too much participation,
you can make this scenario run on schedule
even when you're offline.
Go back to your scenario either from this 
scenarios menu or from the scenarios timetable.
Check this box to schedule its 
autostart and scroll to the bottom.
Here you are to select those hour intervals 
when you want your scenario to kick-start.
You can set 1 or 2 runs a day, 
provided they do not overlap.
See? This time is already taken by the 1st run,
so you need to pick another.
You will find more details on this necessary precaution 
in the add-on tutorial on our website.
You can also request a log sheet to make sure 
everything goes smoothly with both runs daily.
It will appear as an extra tab in the file altered 
by the scenario as soon as it does its job.
You'll see
what scenario was executed,
at what time exactly,
and if there was a problem.
And if so, you can always
troubleshoot our support team
at the suggested email
in your log sheet.
Install Remove Duplicates from 
the Google Marketplace
and make it handle your data
for you automatically.
If you have any questions,
feel free to leave a comment
or contact us directly –
we'll be happy to help! :)