Finding unlinked brand mentions and link opportunities on Google has never been so easy with this free SEO tool!
A free SEO tool to check Google search results for unlinked brand mentions, built into a Google Sheet. It looks at the top 100 Google web search results, crawls each page, extracts all links from each page, and checks each one for a link to the domain in question. Help me make it better!
Get this SEO tool for free!
Click the "Free Download" button below...
Instantly receive a link to access this free SEO tool.
Send download link to:
Bitcoin
Donate Bitcoin to support RankTank
Scan the QR code or copy the address below into your wallet to send some Bitcoin to keep RankTank free forever!
Get this SEO tool for free!
You can also Make a Copy of this Google Sheet SEO tool, help fix and improve it for others.
Tutorial Video
Know Issues
1. Currently we only return 10-50 results from Google due to a recent update on their side. We are working on a solution to this issue and will release a new version as soon as the problem is fixed.
84 comments
Hi Guys, Google has blocked search requests from sheets, which is causing this sheet to not work anymore, at least sometimes. Currently looking for a workaround :).
Has a workaround been found yet? Dying for this tool to work
Hi Mace, very close will be releasing a new version of the tool shortly!
Iโm having the same issue. Iโve been trying to use it for a few days now and still cant get it to work. Is there a bug?
Hey,
Awesome tool! But I can’t get it to work anymore ๐
Is there a fix?
Cheers!
Yes, version 2.0 fixes the issues with the previous version and IMPORTXML.
Hey Sean,
Is this tool still working? Constantly getting an error in cell D5:
Error
Could not fetch url: http://www.google.com/search?num=100&q=&start=0
Appreciate any help! This tool is incredible!
-Kyle
Hi Kyle, this has been fixed.
Hi Sean,
Is this still working? Have been trying for the past few weeks and no results will load. No sure if this helps, but I’m getting this message in cell D25:
Error
Could not fetch url: http://www.google.com/search?num=100&q=mantelligence -site:mantelligene.com&start=0
Would really appreciate any help or a tool you recommend instead. This has been SUPER helpful for building my site’s authority!
-Kyle
Hello there,
I just want to say “Excellent Tool”. This tool is really helpful for our company. Waiting for some more Awesome gadgets from your site.
Hey Sean,
Awesome tool! Noticing the same issue as others above though – the doc processed my query once but not any other time. What am I doing wrong?
Hi Sean,
Found out the problem was due to the captcha from Google. I was playing too much with all your ranktank stuff I guess ๐ but there’s no fallback in this google doc for captcha (and also no option to pick a google domain, that would be awesome too).
Vincent
Hah ๐ The IP address it uses isn’t yours, it’s a Google internal IP address. How did you see it was a captcha?
I was using this to great success but now it’s not working for the projects I was using it with.
Is there a tutorial to rebuild it?
Hey there, I inputted my info but nothing happened. I also tried the info already populated but nothing happened as well. What do I need to press to
make it execute?
I’m having the same issue. I’ve been trying to use it for a few days now and still cant get it to work. Is there a bug?
I’m seeing the same exact issue. Made my own copy, changed out root domain and search query, but the tool isn’t processing.
Hey, could you share your sheet with me with edit privileges? I’ll take a look – [email protected]
Hey Sean, really awesome tool – thanks for building this. However, I’m seeing the same exact issue. It processed once for me, but then I tried processing again for a different query and nothing is showing. Did you discover the problem? If so, how can I get it to work?
I’m having the same issue. I even tried the example used in the video, and am getting no response. Nothing is happening. Was a solution for this ever found?
Hey Franco, what OS are you on? I checked OSX 10.10.3 and Windows 8.1, and they’re working.
P.S. we’re neighbors.
Sounds great! Thank you very much
Great tool! Is there any way to change the localisation of the Google search. i.e. to look at Google.co.uk results?
[…] One:* Download the RankTank Unlinked Brand Mention Finder at: http://www.ranktank.org/brand-unlinked-mentions-finder/ and follow the […]
Thanks broo, this tool rocks!!!!
[…] RankTank’s Unlinked Mention Finder is a free tool that taps into Google and uses Google Docs to create a spreadsheet of results that show up for a specific query and allows you to check if that site links to your site or not. […]
[…] RankTank’s Unlinked Mention Finder is a free tool that taps into Google and uses Google Docs to create a spreadsheet of results that show up for a specific query and allows you to check if that site links to your site or not. […]
Hi Sean,
When I first open the sheet it works and I see all the mentions appear in red but before any of them really have a chance to turn green they just disappear. Refreshing the page or changing any of the site or query info does nothing. Any Idea why?
Wow, that’s weird. Could you share the sheet you’re using with me with edit privileges? [email protected]
This is a really cool tool, but my spreadsheet didn’t seem to work properly. I get the following error message:
Error: Could not fetch url: http://www.google.com/search?num=100&q=“massage”&start=0
Is there something I am doing wrong? I input the domain url without the “www.” and then input a search term, but it doesn’t run. Any help would be appreciated. Thanks!
Hey Gabe, thanks for trying out the tool! Sometimes Google just times out. When that happens, you should cut & paste your URL back into the cell. That forces the sheet to retry.
Really awesome tool dude!
Cant wait for more cools things for SEOยดs!
One Question – Can I change to see the 500 results on Google instead of the 100?
Looks like you can set how many results pages you want to see. Great tool!
It’d be great to limit based on date, but that might be a bit complex.
Thank you! Date would be a bit tough ๐
Just add [&tbs=qdr:] to the formula, with ‘d’ for results from the past 24h, ‘w’ for last week and ‘m’ for last month ๐
Oh, and add [& “,lr:lang_1″& B5 & “&lr=lang_” & B5] for language filtering, with the language (en/de/nl/ whatever) in B5.
Very nice tool, btw ๐
Thank you!!
Thank you!
Excellent tool, thanks! This really helps with link outreach and rep management tasks. Looking forward to seeing what else you come up with. ๐