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.
83 comments
#ref error, even when i change “the amount of results from 50 to 100 to 150 and vice versa”. tool doesn’t work ๐
Very nice article!, thank you very much! This really helps us with blog link outreach and pr management. Looking forward to other articles about this subject coming up.
[…] #1 Top Rated […]
Hi,Excellent tool, thanks! This really helps with link outreach and rep management tasks. Looking forward to seeing what else you come up with. ๐
Is there a version 7 coming? Version 6 doesn’t work for me anymore sadly..
Best tool in the world thanks!
Very nice tool for seo…. i wanna use them for my site ranking position….
Hi Guys, version 6 of the unlinked brand mentions finder should be working much better. The #REF error is due to Google blocking the request. To get by this you can change the amount of results from 50 to 100 to 150 and vice versa, this will recrawl. Let me know if this is working better than before.
Still getting a reference error and seeing no solutions here. Is there a fix?
Hi Ellie, this should be fixed in the latest version 6.
Hey, as some other users have commented, it looks like the tool is not working. I get a #REF error when I try.
If anyone has any solution for this I’d be really thankful.
Cheers,
Juan
Hi Juan, I’ve updated this tool so the Unlinked Brand Mentions finder should be back in business.
Hi, the tool worked the first time I opened it. After that, I keep getting #REF! in the results.
Also when I make a new copy from you’r original document, without changing anything.
I really think this tool is great when it works, so I hope you have a solution.
Already subscribed to you’r newsletter, in case you have to send a new upgrade.
Thanks already,
Gerjan
This does happen occasionally, still not sure why, but we’ll keep monitoring. Best is to try again later and let me know if this is still an issue?
Sorry, but I’m trying again after a long holiday and stil receiving the same error. Maybe there is an other problem?
Hi,
I’m getting an error that the reference does not exist. Can you help?
Thanks
I’ve released v4.0 of the unlinked brand mentions finder, it’s limited to the first 100 results returned by Google, enjoy :D.
Hello. Could you please help me? It looks like formula is not working.
I have changed B3 to
travelplanet.lt
and B4 to
travel planet -site:travelplanet.lt -site:travelplanet.pl -site:travelplanet.de -site:youtube.com
It shows in A10:
Error
SyntaxError: Unexpected token: u (line 6).
Where is the issue? please help ๐
This is a Google issue at the moment, we are releasing a new sheet within the next week to address this. Please subscribe to our newsletter to be alerted.
Okey, already did. Can’t wait for the new template :))
[…] There are also purpose-built tools that will do the hard work for you – like this one from RankTank. […]
[…] Achterhaal of er op het internet jouw bedrijfsnaam is gebruikt zonder link erbij met het programma Unlinked Mentions Finder. […]
Hi RankTank. First of all great tool. I tried for a few days but after sometimes I am getting an #errors!. Could you please throw some light on it? Looking forward for some more exciting tool as well.
[…] Unlinked Mention Finderย van Ranktank is een programma waarmee je kan achterhalen of ook er naar jouw website gelinkt […]
how do i controll the language? if i wanna get the results from swedish google search results?
awesome tool btw =)
Thanks, click cell C10 and change “=getURL(“https://www.google.com/search?q=” & B4 & “&num=” & B5)” to “=getURL(“https://www.google.se/search?q=” & B4 & “&num=” & B5)” you could also add “&hl=swedish” to set the interface language.
Hi Guys, I’ve update the free brand unlinked mentions finder to version 3.0. This fixes the error you have been experiencing (Google blocking automated searches). The tool now pulls the top 100 results by default and follows each to check for a backlink or possible opportunity (lack thereof).
I think we need a new version, all I get is #ERROR ! Am I doing something wrong ?
This has been fixed in version 3.0.
Hi Ranktank!
I tried using your tool for http://www.aquivemedia.nl but A10 only gives me #errors! Any idea how I can fix this?
Please check the new version Milan.
Seems to be something wrong: #ERROR!
Could anyone fix this?
Jelmer, the new version should fix this for you.
There is a problem with the script.
Guys really ask to check and make edits
This is a very cool tool, thanks!
Yarina, please try the new version and provide me with some feedback.
Jaco thanks! You the best.
seems not working anymore. At the beginning works but then breaks. Any bug fix?
Try the new version 3.0, Antonio.
[…] that allow you to monitor your brand mentions such as Mozโ Fresh Web Explorer and RankTankโs Unlinked Mentions Finder, however I find using Googleโs search modifiers does the job just as […]
[…] guarantee that you can reclaim 10 or more unclaimed links today. You can use the Rank Tankโs brand unlinked mentions finder tool to find these product mentions across the […]
Hey, how can I search for a two word or more phrase? I get an error if I search for something such as “hotel name”. The quotes don’t seem to work?
Hi Ben, please try version 3.0 just released as this should resolve the errors in the old version.
We have released a beta version 2.0 of the Unlinked Brand Mentions Finder. ๐
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. ๐