G̃ooberSug̃g̃est SEO Keyword Research Tool

by Jaco

A free keyword research and expansion tool made in a Google Sheet!

GooberSuggest is a free keyword research tool built to find SEO opportunities from Google’s auto-complete keyword suggestions! Going a step further than other tools, you can add your SEMrush API to activate powerful features, such as automatic opportunity highlighting!

Another RankTank tool crafted with care by Jeff Louella and Sean Malseed
Keyword research and expansion tool

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:

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.

How do I use this thing?

It’s easy! Just enter your keyword in the “Base Keyword” box and press enter! Let’s use screenshots to show off some of the deeper functionality:

1. Do I need some paid API key to use this?

GooberSuggest no API key needed

Nope! Sure, you can use a SEMrush API to greatly expand the functionality, but it’s totally not required! If you don’t have an API key, the sheet will still query Google for autocomplete keyword suggestions, making this tool quite handy for fast keyword research and digging for opportunities.

2. How do I see search volume and opportunity highlighting?

GooberSuggest keyword opportunity highlighting

We put some fancy stuff in the sheet to make use of the SEMrush API if you happen to have access to a key (hint: if you have an SEMrush account, you have an API key already). With the API key entered in the Config tab, and “View Enhanced Data” changed to “Yes” on the main tab, the sheet will import Search Volume and Number of Results from SEMrush. Then, a formula will highlight keyword rows that have high search volume and low number of results – strong keyword opportunities, or “low hanging fruit”. We’re super proud of this feature!

3. Can I export this data? For like, Excel and stuff?

GooberSuggest export keywords

Excel is lame, but we know it has its place. So, we’ve made exporting this data simple with the “Keyword List (for Copy/Pasting)” tab! This tab lists out all results, including Search Volume, Number of Results and Opportunity (if you have your SEMrush API key in the “Config” tab). You can then paste this data into Excel, OpenOffice, or whatever!

Know Issues

1. This tool needs to be updated to function correctly on all systems.

Leave a Comment


Peter 30 April 2023 - 11:01 am

Great work done by the team. i have managed to ranked my site following this tool.

Lottoz Results 3 February 2022 - 11:49 am

thanks for sharing. it is very nice tool

Saipixels 26 January 2022 - 2:58 pm

Thank you so much for this fabulous information about the good work

Jonathan 19 February 2020 - 3:54 pm

hmmm NO UK option? Not useful for us BRITS 🙁

James Oliver 8 April 2020 - 3:43 pm

A UK option would be amazing

Sayan Das 22 April 2017 - 7:06 am

What an article,
I was little confused about keyword research. But finally, I found a name (Semrush).
Really enjoy it. thanks again for this article.

Roland 10 December 2016 - 3:52 pm

No change to run it in DE

James 14 July 2015 - 1:33 pm

How do I get this to work for the UK ?



Maxx 14 July 2015 - 10:04 am

Add each keyword to your basket clicking on the plus sign on its left.

James Kong 29 June 2015 - 10:25 am

Is there a way to look at data from .co.uk ?


teddy 22 June 2015 - 8:13 am

Awesome Sean ! Congrats for your work again!

Can you confirm me that it doesn’t use our own IP to scrap results… So no risk to have a captcha asked by Google?

Thanks again for all your stuff ! Really impressive ^^

Bryan 18 June 2015 - 3:42 pm

Am I able to get the semrush api for just the $15 with out having a paid monthly account? this seems like a good way to get around their high monthly charges.

Sean Malseed 18 June 2015 - 4:04 pm

First, yes – the starting level account is only $15 per month and includes API access and some web interface. Super low cost, especially considering the value.

Second – SEMrush is worth every penny. Seriously. Like really seriously. The standard plan is $70 bucks and does 10x what other services charge $99+ for. If you learn the software, you’ll get way more value back on that $70/mo. I use SEMrush daily for every single client.

Cory 17 June 2015 - 5:11 pm

To run a complete query (e.g. all tables for a single keyword), how many API units does the sheet utilize?

Sean Malseed 18 June 2015 - 2:02 pm

It uses 360 units for all the tables.

morav 17 June 2015 - 12:57 pm

Can you explain, how it works, how do you do this?

Sean Malseed 17 June 2015 - 2:29 pm

The suggest keywords come from Google, and the optional SEMrush API adds search volume, number of results, and opportunity highlighting 🙂

morav 17 June 2015 - 10:05 pm

How do you get Google keyword suggestions?

Sean Malseed 18 June 2015 - 2:04 pm

They come direct from Google. If you’d like to see exactly how, look at the formula in cell C2 in the ‘Data’ sheet (unhide it first).

morav 18 June 2015 - 5:31 pm

Thanks, I just want to localize it for Russia

Sean Malseed 18 June 2015 - 5:40 pm

It’s super easy actually. In the formulas in the Data tab, just change hl=en to hl=ru. Then, enter some Russian words and test it out 🙂


teddy 22 June 2015 - 8:27 am

We can do that as well ^^

just replace all the formula by this one
Iferror(IMPORTXML(“http://suggestqueries.google.com/complete/search?output=toolbar&hl=”& ‘G̃ooberSug̃g̃est’!$C$7 &”fr&q=”& ‘G̃ooberSug̃g̃est’!$C$5, “//suggestion/@data”),””)

Sean do you agree with that ? Or I miss something…

teddy 22 June 2015 - 8:29 am

I made a mistake the right one : Iferror(IMPORTXML(“http://suggestqueries.google.com/complete/search?output=toolbar&hl=”& ‘G̃ooberSug̃g̃est’!$C$7 &”&q=”& ‘G̃ooberSug̃g̃est’!$C$5, “//suggestion/@data”),””)

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