You're going to need:
Make a copy in your own account.
You'll notice it has 2 tabs, one for process and one for unprocessed.
You will be working first in the unprocessed tab, dumping in the information quickly before moving it into the processed section and completing it with email address and other specifics.
Feel free to edit your copy of the template so it includes more branched links (instances of a single broken URL found linked in multiple places on the web).
Attached below is the template in case you'd rather use it in Excel.
Your search terms should be based on the content you want to give backlinks to, so should be relevant. If you're trying to rank your productivity app, for example, you might want to look for lists of productivity tools and see if any of the tools have been discontinued. For this, you'll build a list of potential queries like this:
Read more about queries for broken link building here — they suggest queries such as:
Broken link scraping is about covering a ton of ground, not about being careful. Get to it by shoving your first query into Google, opening the first page up and copying the URLs into a text document.
For a quicker method, put your query in Ninja SEO Tools' Google URL Scraper and get all of the results as a text file for less time spent copy-pasting.
Now you should have several Google results (99 in one go if you used the Ninja SEO Tool I mentioned).
Open up your list next to SEO Spider, and start pasting in.
Make sure you have SEO Spider configured in 'Spider' mode, and select the '4xx' filter from the righthand menu:
Around 100 seed links should do for a campaign.
Now you'll be left with a sheet with hundreds of broken links, it's time to move them over to the 'Processed' sheet and find the contact details for every site owner with a broken link you want to replace.
For every broken link, make a new column in the Processed tab and build it out until it's done. Then, use the process I'm going to link below to find their email addresses:
After you've filled in the emails, go ahead and progress to the next template: