use Scrapebox, mate! SB is the big daddy of everything related to scraping, sorting, trimming, cleaning, tracking, harvesting, etc...
Ahrefs and Semrush combined could not do what SB does if you know how to use it. If you learn how to automate it you can have SB run 24/7 from a VPS (you'd probably need 100s of good proxies, though) and...
1) automatically harvest millions of sites / keywords, and then...
2) analyze / trim / sort / organize / do whatever the hell you want with those KWs / sites, then...
3) outreach to those sites to ask for guest posting opportunities, or to get blog comments from them (although, blog comments are pretty useless with google, but you can do this still), then...
4) monitor the backlinks for liveliness / indexation / d0follow, etc. and then...
5) have SB send you a report daily / weekly of the results while - at the same time and unless you stop it - continuing to harvest sites and KWs while also continuing to sort / clean / organize / submit to / outreach to sites...
6) rinse and repeat everything indefinitely while you're on vacation drinking Martini and living your life...
SB is such a beast of a tool and does everything that Ahrefs and Semrush can't do... You just need to learn how to use it as it does have a learning curve... also, the sad thing is that it might not be supported / maintained anymore, I've heard that their owner is not active on BHW anymore (they've not been active for over an year I believe), so it's possible that you'll have to figure out how to use the software yourself, without much support... if you even manage to activate it that is, because you need to wait for manual activation from SB support IIRC...
Such a shame as SB is the best SEO tool of all time (not even joking). Sure, it doesn't do what Ahrefs or Semrush do (keyword and competition analysis mainly), but when it comes to scraping, organizing, tracking, and cleaning huge lists of links SB is the supreme leader...