Free Keyword Position Rank Checker SEO Tool by RankTank
There is a new RankTank keyword position and rank tracking tool! It’s also available in a limited free version.
The RankTank Google Sheet Add-on, is an improvement over the legacy tool. It therefore comes with many enhancements including the ability to automatically re-scan failed keywords.
Free Keyword Position Tool
Note: This version of the legacy free keyword position rank checker tool (below) now supports the ability to save your rankings to a new tab. You therefore never lose any historical data when you re-scan. It also provides for desktop and mobile user agents when scanning.
This Google keyword rank checker allows you to paste in a list of keywords, enter your domain, and pull back all of the Google keyword rankings in real-time. Above all the keyword position tool is totally free and built completely into a Google Sheet!
This free SEO tool includes support for SEMrush API in order to pull in MSV (Monthly Search Volume) data to show alongside your keyword ranking within the Google Sheet.
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!
Keyword rank checker SEO tool
This free SEO tool will let you check keyword rankings relative to your domain, right inside of a spreadsheet. There’s a lot of free keyword tools out there, however this tool is completely open and transparent. All of the code is right there for you to view, modify, and tweak to your needs? Create something cool out of this? Hit me up and let me know!
Keyword position rank monitoring on a schedule?
Set this sheet up to run on a schedule, and you’ve got yourself a free automated SERP rank checker. It’s totally free! Automate keyword ranking reports, track and set alerts on Google position changes. In other words you get a full understanding of what keywords you do rank for on Google – and where – totally free!
Lift the 100 keyword limits of the “legacy” free keyword position rank checker tool, Make a Copy of the Pro Keyword Rank Checker Google Sheet SEO tool.
This is a RankTank Pro SEO tool which requires a RankTank Pro Subscription @ $149.95/month.
Know Issues
1. I get some blank rows without a result, even after waiting a few minutes. The request failed and you need to retry it by cutting and pasting the keyword in the cell again. Alternatively select “Reset” and “Run” again to re-scan all keywords. In addition you can also look at using the new RankTank Google Sheet Add-on with automated intelligent retries.
2. I am getting no results or not ranked for all keywords. Make sure you’re online, not blocking any sheet permission and that you’re only using your desired domains TLD e.g. domain.com and not http(s)://domain.com/page.html etc.
WIP: How does local results affect rankings?
The beta version of the local result keyword position rank checker tool allows you to set your region, language and local area (city, airport, municipality etc.). Importantly you can now pull all of the Google SERP local keyword rankings. We use the “uule” parameter or “near” parameter in order to filter by locale.
You can also Make a Copy of the Local Keyword Rank Checker Google Sheet SEO tool.
This is a RankTank Pro SEO tool which requires a RankTank Pro Subscription @ $149.95/month.
In conclusion the local search rankings tool is a complex work in progress, hence the beta tag. In short we use the Google Adwords location information to generate local search results based on the “uule” parameter. Most importantly this is the same parameter Google uses in it’s own SERPs. Should it not be possible to calculate the “uule” parameter we fall back to using the more general “near” parameter in order to filter the results.
637 comments
I loved this software but I also use keyword researcher most of the time mainly for my work
I added a addon in our Google sheet. When I enable addon and trying to sign-in with Google account then getting an error message i.e. Encountered Error: This operation is not supported in the environment this application is running on. “location.protocol” must be http, https or chrome-extensions and web-storage must be enabled . So kindly assist on it.
If you access the add-on in normal mode instead of Incognito mode on your browser, this should resolve the issue.
[…] tracker you must already have a Gmail account to download the Google Sheets. Then you can visit RankTank, click “Free download,” and enter your name and email […]
The new version 26 of the RankTank Add-on now supports Ad rankings, Featured + 3-Pack (Product, Location Question) rank tracking via Google SERPs: https://tools.ranktank.org/rank-tracking-add-on
Thank you for this lovely seo tool
nice update but the tool is not working on my phone
It will only work on a desktop computer.
nice one. The tool not downloading please. good narratives.
If you enter your email address you will receive links to make copies of the tools.
Thanks, JACO.
I love this site so much
Thanks for your great contribution in SEO field. Keep it up.
Thank you so much, I love all the features. Keep it up!
A free copy to see progress and testing is not used. I want to use before see how new results decide to buy pro
Am so happy about this thanks
Hi Jaco, thanks for this helpfull tool. How can I do this: “Set this sheet up to run on a schedule, and youβve got yourself a free automated SERP rank checker.”???
I have no experience with google sheets. Please can you point me in the right direction?
Hi Jaco,
there a way to see how a kwsmovement without going from tab to tab?
Doesn’t seem to be working.
Tried with two domains. A .com and a .services.
All keywords failed over and over again.
Hi Andy, we are not aware of any issues, perhaps send me a screenshot of your sheet and I’ll assist. Also ensure you’re entering only domain.com and not http(s):// or www.
Can I somehow search for keywords of any given website URL or I’ll have to enter specific keywords to see the rankings?
Hi Jenny, you should be entering specific keywords to obtain rankings.
Great tool Jaco!! Is there a way to see movement of a keywords on one sheet or do you create something in data studio?
Hi Allana, thanks for the positive feedback, you could custom develop something in the Google Sheet, but Data Studio may be your simpler bet.
thanks Jaco, is there a way to see how a kw is moving without going from tab to tab?
Thanks, JACO.
I love this site so much
Very helpful tool.
KEYWORD IN MY YOUTUBE CHANNEL HOW TO GET
Great Tool! Thank you! Best Regards, Nick Freund
What are the limitations of the free RankTank Google Sheet Add-on?
Thanks for sharing us
[…] All #1 Top Rated #2 Fix Me Business Development Keyword Position Keyword Research Link Building On-site SEO Search Appearance Technical Utilities #1 Top Rated […]
Getting a 429 error now on both the version 30 and version 27 Keyword Position Checker tools, even though I am using the same list of keywords that I have for years. Somehow the API is now being overwhelmed with requests, even though it is the exact same 50 requests. Any ideas on a fix?
Hi, yes that’s possible as the free usage is incredibly high at the moment, about 10 million requests a day. The best would be to upgrade to get a API key for $10/month (https://www.ranktank.org/upgrade) on the legacy sheet or $9/month on the Google Sheet add-on (https://docs.ranktank.net/ranktank_google_sheet_add-on). This guarantees your requests get priority.
Awesome trial…. I like the E-book
Thanks, JACO. I know your website from Bing Search
Thanks for sharing this method it will help me
it is very important and useful for seo. thank you
Thanks for the great tools, very nice article
[…] All #1 Top Rated #2 Fix Me Business Development Keyword Position Keyword Research Link Building On-site SEO Search Appearance Technical Utilities #1 Top Rated […]
Nice SEO tools
You are problem solver of millions of SEO guys. Thanks Rank Tank for this amazing spreadsheets.
Awesome, thank you for the SEO tools!!
[…] RankTank Google Sheets AddOn – Never tried it but looks interesting. Maybe not for automated tracking but if you just need to check your rankings once every few days/weeks and prefer to have your data saved into your Google Sheets it might be worth giving it a try. […]
I think this app is Very nice
Thanks for the great tools
Thank you for all of these free SEO tools ….
[…] RankTank Google Sheets AddOn – Never tried it but looks interesting. Maybe not for automated tracking but if you just need to check your rankings once every few days/weeks and prefer to have your data saved into your Google Sheets it might be worth giving it a try. […]
Thanks for the great tools
Thank you. This tool is very helpful.
This is a great blog to look at SEO performance. Thanks to the one who made me learn so much from this information.
nice tool very usefull to seo
Thank you so mutch for sharing free tools
This is just amazing. Thanks for sharing for free π
Actually, this tool is very nice
I want to check my rank in google for my website but there are multiple tools available in google that tell me about ranking, some off them shows me in top 100 or some are not what should i do now?
Awesome I personally realy liked this tool
First off I would like to say this is awesome! I have been looking for a method to check my rankings as much as I would like without getting banned by Google. I do have one question for you though. Is there anyway to have the rankings only pull for my domain? I have a few keywords that are showing up with the ranking and ranking URL for walmart or amazon. Granted they are my products but I would like to just have only my domain itself. Other than that this tool is epic. Thanks Again
Very Useful tool for searching many keywords. I usually search many types of nonprofit fundraising keywords. This tool helps me a lot.
This tool is no doubt a neat and clean tool with very accurate result.
For the free legacy version, I wanted to know exactly what are the limits?
I see somewhere 1000 KW. What does that mean?
1. Can I fetch as many KW ranks ( within 1000) as I want or
2. Total rank fetch is 1000?
3. What will happen after that?
4. In case fetch is attempted after 1000, will it block the ranking domain? Will the block go off after some time or it is prermanent?
Hi Jeniffer
1. You can fetch 1000 SERPs for any amount of domains/keywords.
2. Total fetch per month is 1000 on the free sheet.
3. You will get a limit exceeded message after this.
4. Your limit resets on the 1st of the new month for the legacy sheet and 30 days from signing up on the add-on.
Thank you, @Jaco for the pointed replies.
–===–
RankTank Legacy Google Sheet v.30 Released
– Supports up to 1000 keywords in the sheet.
– 1000 free scans per month.
– Desktop and mobile user agent support.
–===–
RankTank Google Sheet Add-on v.20 Released
– Supports unlimited keywords in the sheet.
– 1000 free scans per month.
– Desktop and mobile user agent support.
RankTank is very good. i liked it.
Just wondering, how do I manage multiple websites in one sheet?
You would need to make a copy of the sheet for each domain, or you can look at using the new Google Sheet addon which will support a new tab for each domain, language or locale configuration.
[…] 1. Rank Tank […]
This is a very nice tool and I like it. It is very simple and easy to use.
I’ve released v30 of the free keyword position tool. The new version now supports up to 1000 keywords in the sheet (as scan limits are imposed for free users) and also includes support for desktop and mobile device rankings. Let me know what you think and stay safe.
this could be extremely helpful. Yet, for me, it just continues saying “need to retry” when I include my watchwords. In any case, possibly I am accomplishing something incorrectly.
Hit me up on Twitter with your domain and share your sheet or a screenshot and I’ll help out.
its really nice and working tool thank you admin
when a Google Sheet grabs a URL, it does it from a Google internal IP address and not yours. Itβs really awesome
its really work for me.
I could get a copy of that spreadsheet you created? Iβve been looking for that type of tool for automated analysis. Thank you!
Remember to try the new RankTank Google Sheet Add-on: https://docs.ranktank.net/ranktank_google_sheet_add-on.
It features automated retries and improved scan credit management. We are therefore also offer 1000 scan credits per month to all users.
Complletely Perfet SEO Tools, But Expensive for Some User , Specially Me . I wish Will You Give Some Opportunity
Awesome tools. Thanks for sharing
I Really loved this tool, thank a lot for adding awesome stuff to your site, it helped me a lot to find mine niche relevant keywords
Hey there, this is a amazing tool and I want to purchase it for my website and also I have many site. What’s the price.
Great tool
This is indeed a very useful Google rank tracker. Congrats on the effort.
You only need to consider upgrading to version 28 if you experienced issues with keyword branded domains being detected as ranking incorrectly. For example: domains containing your domain name as keyword showed as ranking for your keyword instead of your own domain.
I need to know is this a paid tool or a free tool as i am having issues in finding a suitable free tool for keyword rank checking.
We now allow for 1000 free scans per domain per month. Limits reset every month.
personally google planner does it.
I don’t get it, how does Google planner show you in real-time where your domain ranks for specific keywords and phrases?
Great tool, I would like to say this is awesome! I have been looking for a method to check my rankings as much as I would like without getting banned by Google. I do have one question for you though.
When a keyword gets stuck, simply copy it, delete it, and paste it back in the cell. This will force the keyword to crawl again.
it’s free or paid tool?
This tool is free with limitations on how many times a free domain can be scanned.
For several days, although I have updated version 27, it does not work. All keywords indicate the option to buy the pro version
We’re currently limiting free use due to Google limitations, this should again improve over time.
I am using paid version but it still takes slower and return https://mydomain/google-rate-limiting-your-account-try-again-later. Please resolve it
Hi Mary, This is a Google limit and not a RankTank limit. It happens to some accounts, we are looking into it and will release an update in the next few days.
One of the best tool of keyword research, I have ever used.
I’ve released v27 of the “free” keyword position tool, the new version has much more liberal limits and can again be used for free granted we don’t detect commercial use. Please upgrade to the new version to try it out π
Keyword position tool versions prior to 27 will cease working over time so I urge everyone to upgrade at their earliest convenience.
Is this tool paid or free yet?
Semi-free with lower limits, the Google keyword rank checker sheet add-on releasing soon will have more liberal limits and would be able to be used free for personal use.
I am trying to rank my keyword but It’s not working for me.
Can u help me how I can get rank my blog.
When a keyword gets stuck, simply copy it, delete it, and paste it back in the cell. This will force the keyword to crawl again.
Hyyy
I have a problem with the tracker. When I put in the keywords they all just turn to 0 MSV. How come this happens?
Did you add your SEMrush API key under Settings tab?
Try to log out of Google and back in, and then copy, delete and paste the keywords back in. That usually refreshes the IP address that the doc is using.
Nice, Love it,
I also tried to put some keywords to check their ranking. but i am failed. can you explain the trick one by one.
I am not able to use the sheet as it asks me to upgrade even for 4 keywords. Is this error or a trick?
Please ensure you don’t add a trailing “/” after your domain name. The match is exact.
Hi, I added a few keywords, but none of them were crawled successfully. I tried to copy and delete some keywords, but it didnβt help. Do you have any idea why it doesnβt work?
Thanks a lot for an answer! naukrigadget.blogspot.com
Be sure to enter only the TLD (example.com) not https:// or www, also remember to choose “Run” in the dropdown :D.
Hello,
I am using the free tool in a spreadsheet in docs.google.
In a table cell is the following message :
Version 21
UPDATE
CLICK HERE
VERSION 25
When I click on “CLICK HERE” nothing happens
The content of the cell is “=checkForUpdate(internalFunctions!A3,internalFunctions!A5)”
Could you let me know how to update to Version 25 ?
Thnak you in advance for any reply.
Patrick
Hi Patrick, just click the “Open in Google Sheets” button on this page to make a copy of the latest version.
[…] Rank Checker Tool by RankTank.org […]
Hi, I added a few keywords, but none of them were crawled successfully. I tried to copy and delete some keywords, but it didnβt help. Do you have any idea why it doesnβt work?
Thanks a lot for an answer!
Hi, you can message me on Twitter and I’ll take a look for you.
Can you please advice me any free tool to check my 240+ keywords list but please refer me to a tool whose results are acurate
Hi.
Once we make the $10 payment, how can we contact you to activate our account?
Hi, you can contact me on Twitter or jaco at ranktank.org via E-mail.
u have upgrade RankTank Basic -> $10/domain/month via email [email protected] for domain ictsaigon.vn. Please active me
Will send you an email with your key shortly, thanks!
So great
I love it
excellent work
I wish I found this before
When it’s not free don’t use the word”Free”. It’s misleading and annoying
Hi Charles, we are working on increasing the free limits so soon this tool will effectively be free once more.
I also want to check keyword position correctly kindly guide me
Unfortunately, this great free keyword position checker tool is not working anymore, it is not free anymore. I had not been opened any sheet file on Google docs in more than a month, i opened it today, i have only 30 keywords that i wanted to check their positions, and i only get that annoying message again “Upgrade to RankTank Basic -> $10/domain/month ->” so i think you should completely remove the free from the name of this tool, it is obviously not free and a misleading tactic, it’s a pity! time to look for another tool
Hi Alex, we cannot offer this tool completely free anymore as Google made changes that does not allow us to crawl from within Google sheets. Since we’ve all had many years of free usage I don’t think it’s unreasonable to get the same for a small fee to cover crawlers and bandwidth cost.
Keyword position checker for free tool is not working, check it. it is really free tool?
Hi,
I don’t rellay understand what “RankTank Basic -> $10/domain/month” means.
Only one domain, 100Kw per sheet, but I can change Keywords and crawling frequenzie as often as I want to?
Thanks!
Hi Roland, you can change keywords and crawling frequencies for a single domain, your RankTank Basic key allows you to do unlimited scans, but is limited to your chosen domain.
Hi Jaco,
i add 28 keywords row but only works for the 3, for all keywords appears
Upgrade to RankTank Basic -> $10/domain/month ->
Hi Mark, that domain must be hitting the free monthly limit, you can share your sheet with me on Twitter and I’ll check if you like?
The new version 23 of the free keyword position checker tool now supports the ability to save your rankings to a new tab so you donβt lose any historical data when you re-scan. This feature is still in beta so let me know how it works for you.
This is great tool to check your website keywords position in google and it has also many features that increase your knowledge about your domains performance. It’s really awesome and I using it for a couple of months. Thanks.
Do you create SEO tool with all the features for us. We are ready to pay for API too. Please let us know Jaco.
Keyword Position Tracker is not working as free in 22 Version and I always used this tool to track my keywords ranking and recommend to many people….but all they are put question…that is not free. Can i know reason behind this why this tool is paid now…..
Hi Balvir, sure, the tool has a free limit now as it’s no longer free to crawl Google. They made changes to block free crawling via sheets, we now ensure we use our own crawlers which have bandwidth and server costs. Please consider supporting our efforts, as we scale we may be able to again offer more free scans.
Dear Jaco,
I bought the license but I’m not getting the RankTank API key. how I can find out it?
RankTank API keys are issued within 24 hours as they take time to activate.
Brilliant and exceedingly helpful tool!
Awesome tools.
Thank you for sharing.
Great stuff! A really awesome tool.
Hey, Thanks. How can I donate here.
Nice. Thanks for sharing.
Hi Jaco, On the $10 per month subscription of 100 Kw per sheet, 1 Domain is that 100 Kw per month?
Hi Mandy, this sheet supports 100 keywords per domain, but you can do unlimited checks on demand, there is no limit per month on the $10 subscription.
Great! Thanks for the quick response.
Hi, I added 9 keywords, but none of them crawled successfully
Hi! It’s my first time to use the tool but it wants me to upgrade even though I only have 4 keywords to fetch. Can I request to have the limit cleared off like Julie please so we can determine if this tool is for us? Thank you so much!
Hi Kate, we working on improving the sheet and this shouldn’t be an issue that occurs too frequently.
Hi Jaco,
On my file, I get the “Upgrade to RankTank Basic -> $10/domain/month” message however this is the first time in several days I am using one of RankTank tools and I only had 70 keywords to fetch.
This means I shouldn’t have hit the daily limit you mention on your membership page : “From 1 July 2019 any RankTank free user running more than 1000 queries per domain
per dayper month will be rate limited and asked to upgrade to either of the two RankTank paid options below (…)”Why do I get this message ? Could you explain ?
Thanks,
Hi Julie, your usage was detected heavy enough to validate the upgrade notice by our API, this notice does not clear unless you upgrade. As a once-off courtesy I have cleared it for you, but to avoid it in future please do consider upgrading as crawling does have inherit costs attached to it.
Thanks for your explanation and gesture (I actually thought there was a reset each day) and totally got your point on the costs generated by this tool. Gonna think seriously about upgrading π
Thanks !
If you’re receiving “No response” then your usage is too heavy for the free service and you can contact me to upgrade to a paid package to lift the restriction. Alternatively check your upgrade options here: https://www.ranktank.org/upgrade/
This tool is really useful.. thanks
If you’re getting “No response”, assume you’re hitting some limit and consider RankTank Pro or try again later. You can contact me if you’re unsure, just include your domain (the one you’re checking rankings for…). π
It sucks :-/ There is always “no answer”. It’s no longer useful.
What domain are you checking? (You’re probably blocked, I’d recommend paying to use RankTank Pro if that’s the case :)).
I used the sheet for up to two years for the domain verbformen.de about twice a week for 100 keywords. I don’t need more, so the pro-sheet is oversized.
SEMrush has provided RankTank users a special SEMrush PRO subscription with an additional 500 keywords to track keyword position (value of $159.95) for a total of only $99.95 (valid until end of June 2019). This can be a great alternative while we working on a fix for the free keyword position tool sheet.
The RankTank Pro sheet still works and you’re welcome to also upgrade to RankTank Pro and access the other amazing PRO tools. π
Jaco, thank you for your all effort fixing the issue and getting us awesome tool such a this. I am waiting for a new version about 2 months but what a pity 20. version is still giving error as “No Response”.
Please do not abuse the free tool, if you’re getting no response please make a new copy of the sheet as I now log usage.
We are aware of the issue with the sheet being blocked by some recent Google changes. We are working on a fix and should be able to provide feedback shortly. Please keep in mind that many of the tools are provided free of charge to assist the community. Please consider a donation to RankTank in order to assist with future development.
We appreciate and will try our best, thanks for letting us know
Thank you for the update. Good luck with the fix!
Brother, Heartly thanks. I have used this keyword ranking sheet for 7 months. helped me a lot.
Willing to donate but low-salary. Will contribute soon. Thanks a lot to all RankTank Team.
Update 13 June 2019: I will be releasing a new version 20 within the next week which addresses the current issues with the sheet. Please subscribe to our mailing list to be the first to know or follow me on Twitter @Jaco_van_Wyk.
I want to donate. Where can I do that?
Please use the donate button at the top of each page π
This button is not allowing me to donate, i tried 4-5 times but always failed, i will send you screenshot to you Jaco
Hey Jaco, can not get keywords positions anymore, it shows only crawling..
Hello Jaco, this is sheet is not any more working and not demonstrate a solitary watchword position, it indicates just only crawling crawling crawling.
Hello Jaco, How are you?
since few days your rank sheet is not working, is there any issue, i am waiting for your reply, Thanks Srishti
Hey Jaco, this is sheet is no more working and not show a single keyword position, it shows only crawling crawling crawling.
Hey Jaco, This sheet is not working as it giving captcha error. I think you need to resolve this issue.
Yes we are aware and we’re working on it π
How to get rid of this “Google is asking to solve the CAPTCHA” issue?
We’ll try expose this to the user to complete the CAPTCHA, will keep you posted in the future update.
how to use this thing?
Enter your domain without http:// or www (e.g. ranktank.org) and set your desired keywords, then select Run in the dropdown at the top left.
Hi, Could you please show me how to check the keyword ranking? I did not see any tool which help me to find out the keyword position. Thank you alot and have a nice day!
Hi Jaco,
Any update on a working version of the file? I still get Google captca warns.
BTW, I also checked your “Infinite Google Suggest Keywords” link and it seems that infinitesuggest is no longer working.
Thanks !
Hi Julie, still working on it. Infinite Suggest was down for a pro-longed period, but it should be online again.
Looks like the V19 sheet is down, stuck on crawling for all keywords
Same here. Stuck on captcha or crawling for all keywords.
Same thing here. Stuck on crawling for all. No captcha shown.
I always use this tool to track my projects ranking. But facing problems to track. It show kind of error: “Google is asking to solve the CAPTCHA”
Hi Jaco,
In results there are more than fifty percent Google Captcha error. Looking forward to see the new version!
We are working on a solution, will let you know as soon as we have it ready.
I’ve released a new version 19 of the keyword position tool sheet which delays requests a bit and warns of Google CAPTCHA requests so you can manually retry them. We are working on a better fix for this, but in some regions the sheet already performs much better. π
Hi Jaco,
free sheet (newest version 19) and pro sheet (version 18) both are getting the following error: {“message”:”Service invoked too many times for one day: urlfetch.”,”name”:”Exception”,”fileName”:”RankTank_GoogleTricks”,”lineNumber”:1,”stack”:”\tat RankTank_GoogleTricks:1 (getRank)\n”}
The error persists since yesterday while two days ago everything was just fine. I hope you can find a solution soon.
TIA, Frank
Update: Everything ok again!
Hi Frank, you we’re hitting the Google Apps API limit for your account.
Hey Jaco, i think it is giving lots captcha than rankings. can you solve or we should wait for new version.π
Thanks
Not much we can do Raj, we will try improve this in v20.
This is such an awesome Tool. I have been using RankTank for quite some time now. I also encounter the error message. A quick fix is just to copy the keyword – then delete – then paste it back again. I am quite confident the developer would be able to come up with a solution on their next update π
This will work for now but we’ll find a better fix for you soon.
Hi,
Getting the following error message: {“message”:”Unexpected token: u”,”name”:”SyntaxError”,”fileName”:”RankTank_GoogleTricks”,”lineNumber”:1,”stack”:”\tat RankTank_GoogleTricks:1 (getRank)\n”}
Just to explain this error, it is due to Google asking us to complete a CAPTCHA, we will see if there is a way to work around this and will release a new version if we find one.
I’m getting this error too!
{“message”:”Unexpected token: u”,”name”:”SyntaxError”,”fileName”:”RankTank_GoogleTricks”,”lineNumber”:1,”stack”:”\tat RankTank_GoogleTricks:1 (getRank)\n”}
Thanks Lulu, we’re working on a new version to resolve this. Google is limiting sheet queries.
<3
Same error. Thanks for working on it!
Hello!
Actually lots of error messages: {“message”:”Unexpected token: u”,”name”:”SyntaxError”,”fileName”:”RankTank_GoogleTricks”,”lineNumber”:1,”stack”:”\tat RankTank_GoogleTricks:1 (getRank)\n”}
Can you please check that.
Thanks.
[…] can do the job, but for something quick where you just want to pick the current rankings once, try this free tool created by RankTank.org (no registration needed and you can get your rankings via Google Sheets in […]
Best keyword tool.
This is a excellent stuff for check all keywords position and backlinks source.
Thanks for sharing with us.
Hey, how many keywords can it crawl for at a time?
Does it work like the keyword planner on google? I need this for my websites keywords for my outdoor website.
Does it re-scan the rankings every time I open the file? If it is not, what can be done to scan.
awesome tool
This Tool Working Perfectly
Thanks for sharing this tool π
Its not working properly.
What is not working, please explain?
Iβve just released an update for the keyword position tool. The new version is 18, it features a massive code cleanup and speedup as well as minor adjustments to how we speak to the Google API. If you experience issues with the new version please let me know. π
Do grab the latest version here (Choose “Make a Copy”)
Hi Jaco, its not giving all keywords ranking, having issue in displaying ranking
{“message”:”Unexpected token: u”,”name”:”SyntaxError”,”fileName”:”RankTank_GoogleTricks”,”lineNumber”:1,”stack”:”\tat RankTank_GoogleTricks:1 (getRank)\n”}
showing this message in many keywords
Thanks
Hi Raj, please hit me up on Twitter or share your sheet with Jaco at RankTank.
Hey Olaf! I just tried it with Google.de tracking Amazon.de. Does it give you an error? What domain did you try to track in Google.de?
[…] RankTank Keyword Position Tracker […]
this is so easy to use thank you so much i like it
Hello!
Thanks for that Amazon tool. Is there a way to let it check Best -200 search results?
Thanks.
Hi, I think you mean Google tool. You can try the Pro or Elite versions which can do thousands.
Thank you!!I was looking for such tool long time.Great work!!
Hello!
Thanks for that great tool. Is there a way to let it check TOP-200 search results?
Thanks.
Hi Roland, yes you would need to look at using the paid for Pro sheet version.
Thank You So much
It’s a great tool. It helped me a lot to analyse keywords position for my website.
Great tool. It really helped me a lot.
this is very cool
outstanding tools . thanks for free these tools
wow! how you mass querying google without a proxy? cant google block you? or do they see the query coming from a google doc and so let you off. from my experience if i add say 1000 keywords β¦ G will block me.. and give me a captcha to solve. are they dtecting my IP?
Awesome and I will use these keyword position checker tools and will notify you
That is a jolly smart solution to simple rank tracking.
The beauty of this “rank tracker” is that it can be easily integrated into Google Data Studio for client visualisation.
Thanks for sharing this Jaco
Its really a great tools for check keywords !
Hi nice work keep on doing the nice work
One of the best tool of keyword research, I found over the internet. Million of thanks to ranktank team.
Thanks John, appreciate the kind words.
This is the best online research tool i have seen and it will make seo more easy. Much Thanks for sharing
Thank you so much for sharing your knowledge. Itβs nice to know there are friendly people out there! I do have a question though. Is there a way for me to check rankings from a specific location ! Mahesh Dhokale
Specific locations can be checked with the Pro “Local Result Keyword Checker” Tool.
Its really a great tools for check keywords and help a lot to get rank in Google.
Hi! Awesome tool. Thank you!
I tried it on my site. Work fine Thanx…
Hi,
i added some keywords, none of them crawled successfully.
-Cynthia
Thanks for sharing the posts. It is really simple to use
Its very easy to use. Copy , paste , i satisfied
Love your software – Keep up the good work!
Hi, I added a few keywords, but none of them were crawled successfully. I tried to copy and delete some keywords, but it didnβt help. Do you have any idea why it doesnβt works?
Is there a possibility that a ranking is displayed in the Google Map Pack. This shortcoming would have to be fixed so that the ranking is displayed correctly. Nevertheless, Rank Tank is a great tool.
Keyword checker tool is good
hi there is it still possible to get the free rank tank tool that shows the ranking a keyword phrases for A SPECIFIC DOMAIN ????
I have been here for 20 minutes and signed up to two different pages but i am unable to find any download
Regards
Phil
Hi Philip, it sure is, just click on the “Open in Google Sheets” button on the page. Then click on “Make a Copy” to copy the sheet to your own Google account.
I entered a few keywords but it still didn’t fit with google search….
These are live search results and may differ with each request.
Maybe a silly question, but will subdomains come up as well as the main domain under βRanked URLβ? Thanks!
Yes, they should also show as we match on TLD only.
It is not showing our website ranking.
Share your sheet with jaco at ranktank.org and I’ll check why.
Awesome tool. thanks for sharing.
Hi Sean,
Thank for your time to develop such great tool.
Nice ranktank. Thanks for sharing this tool.
Hii, m getting robots.txt error in search console can help me?
SEMRUSH is a paid tool. Can you tell me about the free tool?
Kwfinder is also one of the best keyword finder tool free for demo use.
This is by far the most unique tool we have ever come across and will be testing this tool over the course of the coming days. Great work by the way
What an awesome tool! It works perfect!
Very useful! Thank you.
great share.. But it showing different rankings than other tools.
Hi Shweta, yes this tool shows real-time keyword ranking, much more accurate than other tools.
Semrush and Google keyword planner have always been my best tools for getting keyword ideas for link removed.
Thanks for sharing.
My keyword rank in google page number is 40. How to increase the rankings of my article?
Really good for the keyword position checker.
does not working
The new keyword position checker is working correctly. If you have an issue make sure you only enter the TLD without http(s)://.
Send me path please
I tried to check keyword ranking. I am so impressed about rank tank. But it have limitation on the number of keyword rank checker. By the way, thank you for giving the useful information! Have a nice day!
The free sheet has a limit of 100 keywords. The RankTank Pro sheet can accommodate 2K+ real-time tracked keywords for only $149/month, this also includes access to all the RankTank Pro sheets. The Elite account will allow for up to 100K keywords, but you need to contact me directly to discuss this.
Hi Tankers, I’ve released an update for the keyword position tool. The new version is 17, if you experience issues with the old version please update and let me know what you think. π
the sheet only shows the website ranking first on the SERP. It is not showing my website ranking and other columns provided like above and below are not working.
Please only enter your TLD e.g. domain.com (not http:// or https:// or www).
Is Version 16 currently not working?
Released version 17 to resolve Google API issues.
Thanks.
I tried the free tool but it does not work since yesterday
Thanks for pointing this out. Grab the new version and enjoy!
Thank you! Really an awesome tool! Worked flawless first time!
hey i have asuggestion for you. why dont you use moz api for keywords? it will make work much easier
i was searching for “best demat accounts” for the domain http://bestdemataccounts.com/ but not able to found it anywhere and the competitor sites showed me the keyword position
Best keyword tool
Hi there,
This looks like a fantastic tool, and I’m sure it is! However, are there any instructions anywhere? As soon as I plucked in my first url to track my position, the rest of the data in that column disappeared. Do I need to get an API key from Semrush as a prerequisite to use this tool??
Please help…
I loved this tool!!!
It’s incredible, it’s smart and fast, it tracks the position right away!
Lately i’ve notticed a few of Need to retry in the Live Rank column, but it’s very OK overall!
Congrats for this awesome tools!
hey sean. thank you for this tool. In the latest version (15) i only get “not ranked” no matter what i try (setting google german language deutsch). version 13 still works though. any idea why this happens?
Hi Rene, looks like Google made changes then realised their mistake and reverted them. I have now defensively coded v16 to take into account both types of result sets. Please try and let me know if this resolves your issue?
hi jaco, thank you for the update! now it seems to work. i will notice you if this changes. π
I released version 15 of the keyword position checker to take into account the latest Google changes. The sheet now works better than ever π
Works like a charm!
π
Hi Guys, it looks like Google made some API changes which is causing the keyword position checker to fail. I’m currently look to release v14 with a workaround for the problem. Please be patient as we’re working on it.
I added version 14 as a *beta* fix making use of a proxy to fetch the result data. This may result in limiting from Google or even blocking so please keep me posted on how it’s working.
v14 version doesn’t work for me. Get an error “{“message”:”Empty JSON string”,”name”:”SyntaxError”,”fileName”:”RankTank_GoogleTricks”,”lineNumber”:49,”stack”:”\tat RankTank_GoogleTricks:49 (getRank)\n”}”
same here
Hello, can you please share with us latest version link once you are implemented, Thanks π
awesome Jaco
youre the best
i was wondering why my ranktank was not working
thank you soo much!
Hey suddenly rank tank shows that my site doesnt rank anymore to no keyword at all. But if i google them, I can still find my site. What could be the reason for it? Is there a bug in ranktank? Or do I have a problem with my site?
Very useful site
Thanks for providing me an amazing tool
Thanks for the software update! Maybe one of the best SEO tool π
Is there a way to track the ranking for a specific landing page with this tool?
Hi Leo, the free keyword position tracker currently only tracks domain, but this can be a future addition.
It would be amazing actually. Please let us know when it’s ready π
How/where do I edit region to get local (city) results?
One of the best free Google keyword position checker tools out there!
great tool. thanks
Hello dear
thanks for suggesting the best keyword position checker tool. However, I have a keyword and it was 3 position on the first page. It was still 2 month. After two months my keyword showing 1 position on the first page without any additional work or SEO. Now I have a question that what kinds of SEO worked behind of this result?
It’s a awesome SEO tool for us. Thank you.
Nope, I donβt see a 3 digit position for a few keywords . I guess this tool checks for the domain on the first 10 pages of Google result.
thanks for this very good tool
very good tools i am using it for 3 week.Hope to see new feature soon.
I found a locale issue after a Google November 2017 update. For this I used a new hack in sheet v13. Grab it and let me know your feedback. π
so i have to open new sheets and add all the keywords, can i update the older sheets?
You have to load up the new sheet Alex.
Just added a new version 12 of this tool as Google API rankings we’re varying greatly on each sheet load.
New awesome version of the Free Google Keywords Rank Checker Tool sheet (version 11) now available with many improvements including better updating, faster responses and revised links. Click “Open in Google Sheets” to get it now.
thank you for this tool very helpful for me
Its Just awesome. Fastest tool. Thanks for sharing!
—-
Editor, Infochola
best keyword research tool
Fantastic work, also the tools are very helpful.
Your tools are awesome.
Thanks for great contribution to seo community.
Do you not have your own keywords research tool?
Such a best tool to check your serp thanks admin for it.. .. thanks
Hi Guys, I have released a new version of this sheet (version 10) with many improvements including speed enhancements, a fix for with or without www and com.br domains. π
I’m still having an issue with Not Ranked showing for every domain I enter.
Hi Andrew, please do try from a different Google account and keep me posted if this works!
I am also having this issue. Even when I have a domain under “Your Domain” that is also showing as “Who ranks number one?,” it shows “not ranked” under “Ranked URL” and ” – ” under “Rank.” Obviously it’s ranked if it’s ranked number one…
I’ve tried different Google accounts.
Please help!
Hi Hillary, please share your sheet with me via twitter or jaco at RankTank.
I’m having a issue trying to use this tools in two of my domains. It shows me ‘not ranked’, but when i look at the SERP, its ranked. Can you help me?
Hi Lucas, there is a bug with .com.br will look into this!
Hi Lucas, this has been corrected.
This is awesome. Thank you so much!
hi Jaco,
sorry for noob question, but where is the tool for keyword ranking. I landed on this page but i see nothing
just knew, it is on the google sheet !!! I thought it would be like a software or something.. . Great job.
Thanks Harry, glad you found it π
Its really a great tools for check keywords and help a lot to get rank in Google.
Great tool,
Easy to use and very useful to follow your keywords
It is working very fine; some of my keywords though were not crawled successfully but this tool is pretty much better and great compared to others I have used before.
A free copy to see progress and testing is not used. I want to use before see how new results decide to buy pro
I have dealt with a LOT and I mean a lot of keyword position tools. Almost all of them are wrong placement lol. SMH. I don’t know how these companies get people to pay $40, $100, $500 for their software and then the software SUCKS. I used Rank Tank a few weeks ago; easy to set up, free, and what can I say its freaking correct on the placement all damn day every damn day lol. Plus, I asked Jaco a question (albeit stupid lol) on Twitter and he answered pretty damn quickly. So ya. I will never buy another keyword rank checker as long as Rank Tank is available! :o)
Can this tool provide a regular ranking update?
Excellent site!! I have a question: How do i know which are the right positions ?
[…] RankTank is an open source tool for SEOs. In fact, they brag about having over 10 million users. They have great learning materials, spreadsheets, and other tools for free. But the one tool that really got my attention was their Rank Checker Tool. […]
The keyword position tracker with row limits removed can be found as a “Pro Sheet”. You can also check the Monthly Keyword Tracking sheet for those who are looking to maintain ranking history using SEMrush API.
Awesome Tracker, but I canβt get it to work with google.de ?
Any help would be greatly appreciated : )
Hi, share your sheet with me and I’ll check π
Only 110 Keywords are showing the ranking details. More than that are not working. Also, how can I sort it by ranking? Please help
Hi and thanks for that great tool.
But I do not understand – where is the code?
How can I have a look inside code to modify?
Thanks and regards
Roland
I would like to know if the tool is broken. I check a lot of keywords last month, and most of them had good rankings. And now the tool says that the entire list of keywords is not ranked. How is that possible? Would appreciate your help.
Thank you, Ana.
Not that I am aware of, please share your sheet with me and I’ll take a look π
It seems the tool is broken. Itβs crawling forever for all my keywords and for several different domains. Iβve also tried your tool again (Open The Tool Here) but same result. Hopefully you can soon fix it again because itβs d*mn usefull !!
I am not experiencing the same issue. Please share a link to your sheet in a tweet to me or mail me a few screenshots.
Hi jaco,
Your tools is so easy to use but the tools using some problem. please correction it.
Hi mustakin, tweet or mail me through a list of issues.
Hi,
I am using this tool for a year now but for last two months I am facing issue, It is showing “not ranked” for some keywords which are ranked on 2nd or 3rd page. Although I track 60+ keywords at a time and it takes only 15 minutes to update ranks for all.
It is highly recommended and a huge request from the community to offer a premium version of this tool that can track keywords for multiple projects and an option to maintain record and export reports.
Hi Rameez, we are working on this with RankTank.Pro.
I just added 2 keywords one of which rank on Google at #22 and second was the domain it self. But both of them show not ranked. How is it possible when my site is ranking in google at #22 for keyword and #1 for domain it self. Why the ranking is not shown.
Hi Amit, please ensure you are only entering the TLD without http(s) or www.
Can delete my comment…just saw the tweet reply. Looking forward to pro version.
Hi Guys, I released version 9 of the Free Google Keywords Rank Checker Tool. It now respects language and regional data in API requests. Thanks to @_ThisChris_ for pointing out my oversight.
Hi, is there a limit to 100 kws (mine stop at row 111)? I am dragging down the cells but its blank. Any help would be greatly appreciated and would be happy to paypal donate to help keep this tool kickin’.
Been using Rank Tank for a while to check my keyword ranking. Last few times though that i have been in it has all my keywords as not ranked. Even though if I go to google and use those same keywords I can see I am #1.
google.ca
shop.skitakhut.com
Thanks for keeping this great tool free and up-to-date. Unfortunately, I can’t get it to work past row 110. Any ideas?
Hi Benji, as discussed I will release RankTank.Pro soon which will address current limitations as well as providing awesome managed SEO solutions.
One of the best keyword research tool that I ever seen.. thanks this tool…
Thanks Mukesh.
Jaco,
Yeah, seems like it’s not working anymore. Is there an approximate delivery date on the fix?
You guys are the best! :-*
Thanks!!
Hey Anton, we have released a new version of the Free Keyword Position Tool and now use a different Google API to obtain results. This should be quicker, more reliable and result in less limitations. π
You are amazing! I love you!!
hey guys, this doesnt seem to be working anymore which is a shame, is there a problem with it? I’ve tried deleting the keyword and re-entering, also logging out and back in again but getting errors, or just stuck on ‘crawling’
Thanks π
Hi Leanne, we are aware that Google is currently limiting queries via sheets. We are working on a better solution. π
very great tool i used it so many times thanks for sharing
Might be a great tool, but unfortunately it does not work for me. For some Keywords it sais, it does not rank (but it does on position 1) but most of the keywords are crawling hours for hours and nothing happens. Maybe it doesnt work for Germany?
Hi Krystian, I checked your sheet and removed http://www before your domain. Please only provide the domain name in the sheet. This resolves the issue. π
Great tool, I had used it for the last month and It worked ok.
But right now I’m getting the following error on almost every keyword: “Failed on CAPTCHA after 5 retries using proxies: 107.178.193.11, 107.178.193.8, 107.178.193.30, 107.178.193.11, 107.178.193.30 (503)”
I tried login out and login in, but it still does not work.
Hi Cristian, this may happen from time to time as Google chooses. Please allow some time and try again.
Wow dude … totally impressed that this even exists. Thanks so much for making this available!
Very nice post, this keyword position checker tool helps me a lot from time to time.
The free keyword position tool now uses a new way to get Google SERP’s and works beautifully. Remember you can use SEMrush $15 API to supercharge the sheet. Enjoy π
Hey Jaco! Thanks for the update. Could you please explain the “new way” that this sheet gets rankings, and how location data plays into it?
I noticed a few comments above talk about how the location of the server (California) affected ranking results in the sheet, and I wanted to know if this was still the case. I just want to make sure I’m understanding the data I’m looking at since the data can vary a LOT based on location, user history, etc.
I took a look at the code to see if I could figure it out myself, but I am no coder π
Hi Hillary, the server would not play a role as the data is obtained by crawling country specific Google locales directly as Google itself. The results should be 100% correct based on location.
Excellent tools, I was afraid when I get error. Now perfect and exact results showing.
Thanks for creating awesome tool in the web.
Oh man. I have been looking for at tool like this for so long. Seems like everyone today jumps right onto the business wagon with their software.
Nice…. Tool.
I have tried using your spreadsheet multiple times to no avail. What is wrong? Your website says you updated it in May 2016. But – It’s still not working.
Hi Cheree, the spreadsheet is updated and working better than ever!
hello
Is is possible to check rank for Persian language ?
this website support UTF-8 ?
Juwelier Genk
I love your keyword-position-checker-tool, thanks for sharing.
The googlesheet doesn’t work anymore π It says not ranked for all keywords
This should now be corrected and no longer pose a problem. π
I was using older version of ‘keyword position checker tool’ which was superb. But this new version is not working at all. Just showing ‘not ranking’ for any keyword. Even for website name used as keyword.
Can anyone help me in it? any instruction?
Thanks for previous version. Looking for help on new version..
Thanks a lot Rank tank team for their awesome products..
Thanks a lot
I have added 100 KW but none of them been crawled and i am still waiting for it. Any help would be apperciated.
Hi there,
RankTank keyword positioning tool isn’t working… it it just me?
Hey Marilie, the tool is working fine for me at the moment.
HI again – as a followup to my last question, it seems to be generating an error in all the saved copies:
Error
Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Col3
#VALUE!
I would love to be able to use this tool as it sounds amazing. Really hope you can help.
Thank you!
Hi there, I have made a copy of the spreadsheet in google docs – then logged out and back in – then deleted and repasted the keywords…
I’m still getting no data. It says “not ranking” ….however, that’s not true. I’ve tried it with multiple domains and a variety of keywords with the same results – and I know their current rankings, so “not ranking” is not accurate.
Please help.
Thank you!
I can’t get this to work at all. I update the domain and enter keywords and all it ever returns is Not Ranked. I tried keywords I know I rank for and some blatantly obvious domains and keywords that would rank as well and those appeared the same with Not Ranked. For example, espn.com doesn’t rank for ‘sports’ according to the tool. Do I need to configure something?
i think it’s still working, it just need some updating.
Copied the sheet, inputted my site URL and keywords (no SEMRush API) and the results for all of them are “not ranked” which is not accurate…How do I get the tool to refresh/update the ranks? Or otherwise display what is correct?
Jason
Hi Jason, this should be working fine with the SEMrush API.
I’ve tried this for 2 of my domains with keywords I know I rank top 3 for but it says not ranked. Set for UK. Any ideas?!
Does not work, no results att all even though I have several of them on google page one. π
I continue to receive “not ranked” in a gray color within the tool, can you help diagnose?
Thanks Jess! Iβd love to take a look at an example so I can see whatβs going on. What is the domain and search query youβre using
Does the rank checker us the user’s ip address/locality?
The keyword index google is work 100% keyword
You guys are amazing, this tool has helped me a ton with finding my domains positions on Google. Thanks.
Hi Sean,
Please clarify if the Semrush API Key is a once-off purchase for $15 or is it $15 per month.
Many Thanks
Need to retry on all keywords. Even if I download the sheet again the already inserted info is saying need to retry. Deleted multiple times.
Got also on every keyword “need to retry”. When it works it would be a awesome tool, everyone has a versions that works?
Hey, awesome tool, however I can’t get it to work π
Is there any update on this? Thanks!
SEMRush API Key goes for how long?
Nope, I donβt see a 3 digit position for a few keywords . I guess this tool checks for the domain on the first 10 pages of Google result.
Getting βNeed to Retryβ on all keywords.
Does this spreadsheet still work?
Nir
i have been getting lot of errors in the keyword position checker, are you still working on it? i know it is a beta version, i just want to know you are working on it to make it better; otherwise, i will have to look for another tool π
http://awesomescreenshot.com/0b85nwbu22
Sean, any update?
hey is the tool broken? Ive tried for a while and its hit an miss with google imporXML…
Thanks
I am getting “Need to Rety” for every keyword. Have tried deleting and pasting back in, logging in and out of Google, changing domains, copying the sheet again. Please let me know if there is anything else I should try.
You are freaking AWESOME. I’ve been looking for an automated rank tracker for a long while – in fact, your tool works so well that there is no more need for a 3rd party service. Thank you!
hi can you please make a sheet for find bulk urls (backlinks) in google indexed or not … just paste links and it will show the result the url indexed or not in google … thanks in advance .. sorry for bad english .. waiting for response …
I am also getting βNeed to Retryβ even with one keyword search. Is there any news on this issue? This tool could be amazing! π
Hey guys – been playing with these tools for a while… is there any new restrictions been placed on the importxml from the google results? I am having terrible trouble getting anything to return…. maybe they are blocking me :/
thanks
Not sure it is totally working properly for me. When I click to open it asks if I want to make a copy in google docs – i click copy and I get into the program. All the keywords say is needs to retry – if I copy, delete and paste it back in it says its crawling with however many keywords remaining – but seems to hang up there for ever and I never get a ranking
hello
Is is possible to check rank for Persian language ?
this website support UTF-8 ?
Doesn’t work NO API KEY
Hi Sean,
Tried to post, but don’t see it so I will repost
I am seeing the “need to retry” on almost every keyword, have deleted, signed out and tried again. Any thoughts?
Thanks for the help and thanks for the tool!
Hi Sean, Love the concept and thanks for the tool. However I cannot get it to work getting the “need to retry” every time. I signed off and on again, deleted and re-pasted, etc… Nothing. Any thoughts on how I can get it to work or is there a newer version?
Hi there,
no matter which Keyword I type in, I get allways “Need ty retry” back.
Any Idea why this happens?
Thanks and regards
Roland
Are you working out a bug for Keyword Ranker? Other tools work fine but in the Live Rank column on this one it’s always saying “need to retry”. Not just for my keywords but for the Zappos example.
Hi Blake, this bug has been corrected and the keyword ranker updated to work even better!
Hi why does it have need a retry error? How do we fix this? thanks
This was a bug which is now corrected. For improved performance please consider the SEMrush $15 API.
Bulk Keyword Rank Checker.
Dear Developer,
Was using your Keyword Rank Checker tool for few month and despite few dependencies was very happy.
But suddenly about month ago it stopped working completely.
Despite amount of keywords or internet connection all i get is “Need to Retry” for every single keyword.
Is there any ideas suggestion?
Kindest Regards
Ivan Hulka
hi
actult somehow i delete some rows but now i start from new 1 again and its saying me need to retry for crawl
please help
you made awesome thing
thx
Your tool are really awesome. Thanks
As digital marketers, we all know that the right tools can make a big difference. They can increase our efficiency, help us collaborate, and organize everything thatβs going on. With the help of these tools, we can do our jobs better.Thanks for developing such an awesome tool.
Hi Sean this seems really interesting, could you share with me the doc you created please π
Hey,
Is this working with google UK? I tried to run it for mobile non-friendly websites but nothing…
Hey,
Is this not working for google UK? I tried to run it for non-mobile friendly websites but nothing
Getting βNeed to Retryβ on all keywords and “No API Key” in the MSV column.
Does this spreadsheet still work?
thanks a lot
Hey Sean,
I try your spreadsheet, but got everytime βneed to retryβ. Test different domains and google localizations π
Does Google block your tool?
Gerd
Hi Sean, I just started using this amazing tool. I set up the semrush api at field 9 but when I add 1, 10, or 25 kwrds for my domain and google.co.cr for Costa Rica it says Need to retry.
Is there any way to fix this… it did not work even if I add google.com
Please advice on this.
Hi Sean, any update on this?
Hey,
Really awesome tool. I used it at office to check ~3k keywords and the five random ones I checked for accuracy gave like a 2-3 position discrepancy, which is more than tolerable.
However, I have a weird problem. I can’t get the tool to work on my home computer. Every and any keyword I add to the que times out and says to retry, but no matter how much I retry it never actually crawls it.
I tried the most common troubleshooting steps:
Log out / in from google
Get a new copy of the spreadsheet
Change the website
Try different samples – small and large, even a single keyword
Retried like 10 times to make sure it wont budge
I’m grateful for any help. I really want to keep using this tool for my personal projects as well. Thank and cheers !
Hello,
i’m tracking some keywords from google.it and google.com but the only response for different sites and many keywords is the same: Need to Retry
Same “Need to retry” error on several documents. One document works fine though. The errors seem quite random. Must be a pain to debug, but please keep us posted π
Hello,
I trust that this it best tools, because it is very simple. But it not support for my country (google.com.vn). Now, when i copy your sheet, it is not work. Please check or update.
For me too, I always get “Need to retry” since yesterday (23 Nov 15) from Singapore.
I have added only 20 keywords none of them crawled I tried both the ways but didn’t solve. please suggest me the next process
Same here, not working since Friday the 20th of November 2015 π
Is it a bug or Google stopped it?
I am also getting “Need to Retry” on all keywords, I have tried many different Google domains as well. None is working since yesterday.
Great! Keep up good job.
I’m also getting the “Need to Retry” every time now. Wasn’t before. Nothing’s changed. Try multiple times to paste in keyword. Re-downloaded your beta 4 also. Is this broken?
Hi Sean,
Thanks for sharring your KW Rank tool.
First i past around 200 KW into the tool and it’s almost work. Then i try with 100 other KW and know a have same issue like Michael. It says βneed to retry.β
The Search is in Google.dk
– Can you help / fix it ?
Best rank checker and you make it so easy…
Hello there,
Supertool I’ve been looking for years after something.
But with me I get no results. For each keyword is:
“Need to retry”
Please help.
Thank you
Hi Sean, awsome tool, thanks for sharing it, I was wondering how to remove the 713 row limit, I’ve tried adding rows but the rows are just blacked out and when i paste the keywords in it won’t check them, also tried changing the ranges but that just screwed it up. hope you can help, Regards
Michael
Hey Sean. Really great tool. Unfortunetly, everything worked fine the first 3 days and since, it just keeps saying βneed to retryβ for every keywords when I open the sheet. Is there anything i can do to change that? My ip is good in the FAQ, i haven’t changed any script. I tried to copy the file, same thing. Tried to delete a lot of keywords from my sheet, no change at all. Maybe is it because i left the sheet opened all day long yesterday? Is there a maximum number of tries? Am i banned in anyway?
Anyway, thanx for your work and your help.
Your tools are really awesome!
Not sure if the tool requires an SEMRush api key, but every keyword I have tried says “need to retry.” I have logged in and out of Google, and have tried to delete and reenter the keywords multiple multiple times. Thoughts?
Hey Michael! What Google country are you searching on?
Hello Sean, and thank you very much for this awesome tool.
I’ve used it happily for some weeks but now, suddenly, it won’t work.
Every keyword displays the “need to retry” message, no matter how many times i cut and paste them, or log out and in into my account.
In addiction, the “need to retry” box promptly appears in like 1 or 2 seconds for all the keywords at the same time, unlike in the past if a keyword failed it took several seconds to give the error message.
So I worried that google changed something in the way these requests are managed to avoid people using such kind of tools.
I’m using google.it.
Have you any idea?
Ey Sean,
Just bought the Semrush API, but I get a lot of “no data” or “#N/A” in cell’s and just 2 correct rows with data (out of 16 keyword rows). Any idea what the problem could be? I have enough credits for the API: 299000.
Thanks for the great tools on your site!
I guess those keywords have just too low volume
Hey Sean,
I just wanted to say thank you for this tool! I’ve been looking for something like this for years!
Thanks again.
Hi there,
thanks for developing this tool.
However the localization does not seem to work. For google.com or google.hr i get results, for google.de, google.co.uk, google.fr..I get “Need to retry”.
Any Ideas?
I would love to use this tool.
Michael
Hey Michael, happy to help. Could you share your sheet with me? [email protected]
Hi Sean,
thanks fΓΌr the quick reply.
I tried again in my office today and now it seems to work π
Micael
When I click the link, I am getting “Sorry, the file you have requested does not exist”…
Whoops, fixed!
Google Docs says “file doesnΒ΄t exist”, has the file been removed?
Fixed!
Hi Sean,
As always your tool rocks ^^
I think it can be usefull for others too (to invert the sparkline)
So if you want to see if your ranking growth change your formula like this SPARKLINE(J11:AG11,{“charttype”,”line”;”rtl”,true})
It will invert the sparkline accordingly ^^
Cheers,
Thanks Teddy!!
I think I’m going to try this tool out, looks cool.
Awesome tool.
Thanks Jak!
Hi I just tried the tool and it’s awesome.
Some of the keyword positions are not accurate, I think that is due to location set in the google settings. I hope soon you add the location (city/zip) with the tracker.
also is there any limitation on number of keyowords and sites this can track?
I have more than 50 sites with all over 3000 keywords to track daily. any solution?
Thanks and great effort !
Hey Sean,
Awesome tool… I read through all the comments and saw quite a few mentions of people having issues with “Need to Retry”, but it is happening for the majority of my keywords. Tried posting in smaller batches, but still keep getting the message on a bunch of the keywords. Trying to keep track of around 300 keywords, and if I have to manually copy, delete, paste for each of the ones that don’t work, it will take hours.
Any suggestions? Is there any way to make the doc continue to retry on it’s own until it gives you data? What about a button that retries all the cells that “Need to be Retried?
Appreciate the help.
To clarify more, I am using “Google.it” as locale engine.
Hum… I guess I have been banned by Google, because now I always get “Need to retry”, also for one single keyword… Maybe Google became smarter and now avod such scraping through itself… Can you check it, please?
Thanks!
Hey Francesco! The beauty of using Google Sheets is that it doesn’t use your IP address π It uses an internal Google IP address instead. Sometimes Sheets just goes slow when it needs to make a lot of pulls.
Yes, you are perfectly right, my apologizes…now it works again and very well! Thanks!
PS: I also added conditional rules for background colors! Your tools are really powerful.
Awesome! Thanks Francesco!
Sorry Sean, I have again the same issues about “Need to retry”… No data are scraped. I erased and pasted ten times the keywords (also only 1 at time), it does not work for me… It works sporadically only.
Well, finally I found the culprit!
I had some duplicate keywords in my list… that way it does not work and you will get the “Need to Retry” error.
Now it finally works as it should and it is awesome!
Thanks.
All the best
Dude, thank you so much for figuring that out!
Your tools are really awesome!
About this Keyword position checker, is there a way to add some formulas able to highlight results with colors based on rank positions, please?
So, for example, green background color for results from 1 to 10 positions, yellow for results from 11 to 20, orange for results from 21 to 40 and so on, please?
Just to have a more clear overall point of view.
Thanks!
Hey Sean,
I tried to use your tool, but when I insert keywords (like shown in tutorial), nothing happens. Status says crawling complete, but it didn’t even start crawling π
Domain and localisation are set right. What to do? Thanks for help.
Hey, that’s strange! Could you share your sheet with me? [email protected]
Is there any way to use this tool as if the queries are being run from the location in my Google settings? For instance, I generally swap out location settings to test keyword performance across different areas in Northeast Ohio.
Awesome tool! One question though, does the scraping take into consideration Places and PPC? Because I’m seeing some differences in results I’m getting. For instance, I search for “example keyword” for example.com. The tool says that I’m on position 20 in SERP, but when I do a manual search (non-personalised, clearing cache and cookies, etc.) my site pops on position, let’s say, 11. If it does count Places and PPC, what could be a possible workaround?
Hey Jack, it’s actually searching from a Google server in California, so take that into consideration π Haven’t figured out a way yet to get around this in Sheets.
Oh, California. Is it possible to use a different server? Since I am currently in the UK and use it to check UK websites in google.co.uk. Won’t that provide better accuracy?
Since you’re in the UK, you’re probably getting an IP address from a UK data center actually.
Thank you! Really an awesome tool! Worked flawless first time!
Hey man, great tool. I’m having some problems when I enter a localized google (www.google.hr), retried like 20 times and nothing. Any info on that?
Also I have a nice little add-on I can make if you want, a button to click retry that macro-copy-pastes the stuck keywords π Lemme know if you want, I will make it in my separate sheet and send you a link to copy it
Ah sry, I deleted the “www.” part and now it works. π
Hi Sean,
Great tool!
I do have an issue in the: “This tool won’t ban.
your IP. It uses a Google internal IP, shown below!” section.
In the “IP Used:” section it says “#N/A”. And when you mouse over it, it says:
Error
Could not fetch url: http://www.realip.info/api/p/realip.php
Please advise.
Thanks!
William
Thanks William! Should be fixed.
Hi,
For some time now, IP Used shows: #N/A nd I can’t get any resaults what so ever.
Is there a workaround or can I use other IP instead?
Hey David! It’s fixed π Took the IP display out for now, but it’s still using the internal Google IP.
Great tool! Really simplifies keeping up with my keyword rankings
Thanks Mike! Really means a lot!
you are a genius. This works great, if a little finicky. The ip thing at the top right doesn’t seem to work, but it’s still checking the keywords, and when testing it with keywords I know rank well it showed them as I was expecting them. I’ve used many keyword position tools before, and this is the first one that’s actually worked.
Thank you very much for the awesome spreadsheet, if there were more like you the world would be a better place.
Thanks! The IP thing is fixed π
Thanks for this wonderfull tool
I have used this for several months now and it was working fine. Now not so much? Any helps with this? I keep seeing NO API KEY?
Is your SEMrush API key still active? If you share your sheet with me – [email protected] – I’ll be happy to take a look.
I can’t seem to get this to work for some odd reason.
Hmm, what’s it doing exactly?