Unlinked Brand Mentions Finder

by Jaco
84 comments

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.

FREE DOWNLOAD

Send download link to:

Subscribe to get free SEO tool updates.


  • Bitcoin
Scan to Donate Bitcoin to 19gHVYrSygFuUKXhZ2fDcfmk1WD2t1Yoym

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

Unlinked brand mentions finder tutorial

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.

SEMrush

Leave a Comment

84 comments

Jaco 2 December 2016 - 1:21 pm

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 :).

Reply
Mace 6 December 2016 - 2:15 am

Has a workaround been found yet? Dying for this tool to work

Reply
Jaco 6 December 2016 - 12:41 pm

Hi Mace, very close will be releasing a new version of the tool shortly!

Reply
2ablel5abar 18 March 2016 - 12:17 pm

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?

Reply
Ben 19 January 2016 - 1:36 am

Hey,

Awesome tool! But I can’t get it to work anymore 🙁
Is there a fix?

Cheers!

Reply
Jaco 13 December 2016 - 10:19 pm

Yes, version 2.0 fixes the issues with the previous version and IMPORTXML.

Reply
Kyle 11 January 2016 - 6:24 pm

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

Reply
Jaco 13 December 2016 - 10:19 pm

Hi Kyle, this has been fixed.

Reply
Kyle 6 January 2016 - 10:00 pm

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

Reply
Joseph Spadaro 9 December 2015 - 7:56 am

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.

Reply
Samantha 28 September 2015 - 3:51 pm

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?

Reply
Vincent 1 September 2015 - 7:27 pm

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

Reply
Sean Malseed 20 September 2015 - 10:04 pm

Hah 🙂 The IP address it uses isn’t yours, it’s a Google internal IP address. How did you see it was a captcha?

Reply
Victor 3 August 2015 - 10:29 pm

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?

Reply
Scott 3 April 2015 - 3:28 am

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?

Reply
Dan 12 May 2015 - 1:14 pm

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?

Reply
Matt Dimock 17 June 2015 - 1:48 am

I’m seeing the same exact issue. Made my own copy, changed out root domain and search query, but the tool isn’t processing.

Reply
Sean Malseed 17 June 2015 - 2:30 pm

Hey, could you share your sheet with me with edit privileges? I’ll take a look – [email protected]

Reply
Samantha Pena 28 September 2015 - 3:59 pm

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?

Reply
Franco 13 July 2015 - 4:31 pm

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?

Reply
Sean Malseed 19 July 2015 - 9:59 pm

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.

Reply
Sarah William 13 March 2015 - 7:39 pm

Sounds great! Thank you very much

Reply
Matt 12 March 2015 - 2:28 pm

Great tool! Is there any way to change the localisation of the Google search. i.e. to look at Google.co.uk results?

Reply
Berlin Search Engine Optimisation Tutorial | S.EO Videos For Internet 25 February 2015 - 10:53 pm

[…] One:* Download the RankTank Unlinked Brand Mention Finder at: http://www.ranktank.org/brand-unlinked-mentions-finder/ and follow the […]

Reply
Dope 19 February 2015 - 4:45 pm

Thanks broo, this tool rocks!!!!

Reply
How to Turn Brand Mentions into Links in Less Than 15 Minutes - Automotive SEO 11 February 2015 - 5:33 pm

[…] 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. […]

Reply
How to Turn Brand Mentions into Links in Less Than 15 Minutes | DealerNerd 9 February 2015 - 11:40 pm

[…] 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. […]

Reply
Peter 29 January 2015 - 4:37 pm

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?

Reply
Sean Malseed 29 January 2015 - 6:58 pm

Wow, that’s weird. Could you share the sheet you’re using with me with edit privileges? [email protected]

Reply
Gabe 18 December 2014 - 3:59 pm

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!

Reply
Sean Malseed 19 December 2014 - 1:44 pm

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.

Reply
Pedro Menezes 12 December 2014 - 5:15 pm

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?

Reply
Jabronson 30 December 2014 - 9:52 pm

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.

Reply
Sean Malseed 2 January 2015 - 10:03 pm

Thank you! Date would be a bit tough 🙂

Reply
Wiep 5 January 2015 - 1:58 pm

Just add [&tbs=qdr:] to the formula, with ‘d’ for results from the past 24h, ‘w’ for last week and ‘m’ for last month 🙂

Reply
Wiep 5 January 2015 - 2:20 pm

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 🙂

Reply
Sean Malseed 12 January 2015 - 5:06 pm

Thank you!!

jackson 24 February 2015 - 10:55 pm

Thank you!

Tom 20 August 2014 - 2:47 pm

Excellent tool, thanks! This really helps with link outreach and rep management tasks. Looking forward to seeing what else you come up with. 🙂

Reply
1 2 3

Free SEO Tools

RankTank uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More