[…] and some pointers on how to modify it to suit your needs I’ve put up a separate post on Using the Linkscape API with Google Docs, which includes a simpler example spreadsheet to try the code out […]
Maelle
This is fantastic explanation, thank you very much!
I am having some issue however: the mozRank values are all returning 0.00 and the DA values 1.00 … There doesn’t seem to be any problem with callig the API, but the values are obviosly wrong… Do you have any idea why this is happening?
Sorry if I am asking about something blindingly obvious :-s
Thanks again for this tutorial, it made a whole bunch of things a lot clearer!
Maelle
I have figured it out, sorry…
I had “http://www.(…)” URLs instead of “www.(…)” ones.
I’m glad you got it worked out. Let me know if you have any other problems!
-Tom
jason
Hi Tom,
I’ve been using the Google docs competitor analysis that you shared on SEOmoz not long ago and it was working great, but then i went to use it today and no data is showing. Could this be a problem with the API? or is this working fine for you?
I’ve been having problems, and others have too I think. What is happening is that now lots of people are using these tools and all of them are hitting Google from the same IP addresses (those belonging to the Google Docs) – so some of the time the Google Search servers are blocking the Google Docs servers because they can see they are being used for automated requests.
Unfortunately, there isn’t much we can do about this at the moment, but I am looking into solutions and will post anything I find. I have a couple of ideas to look into.
Mr PB
Did you manage to find a solutions? It randomly works or doesn’t work for me!
jason
Great – thanks for your reply Tom (and good luck).
Link Root domains is not working for me either. Is there an update needed for the script? Also could the metrics be expanded to include Page Authority?
Thanks
Jason
Bruce
Since december this is no longer working that good for me. I used to be able to check 300-500 URL’s with no problems, today I can probably check 15 links and then need to wait 30 seconds. Getting error 503 throttled.
Working with big lists (1000+) this is almost impossible.
I wish to find an alternative to this.
Is it somehow possible to run it somewhere else than on Google docs?
Or maybe queue the script to check 1 line every 2 seconds (like ToS says we SHOULD use it)
Love the article! But wondering if anybody has found any solutions for working with large lists. (i.e. Bruce’s suggestion to “maybe queue the script to check 1 line every 2 seconds”)
I think this has to do with the new throttling requirements. I built a tool that uses the free API and basically just added a delay between API calls for 2 seconds between each one. Now it works fine (albeit much slower).
I’ve just updated the post with a link to an update that Chris Le over at SEER Interactive has put together that deals with the new rate limit requirements. 🙂
Hey guys Noob here just wondering about adding the key. I’m getting missing ; before statement ?
Joe Robison
Hey Tom,
Any advice on where to start if I want to learn how this API is working, line by line, so I can implement similar things with other APIs (such as Raven Tools)? Thanks!
[…] using Google Docs for SEO by Richard Baxter. Tom Critchlow followed suit a couple months later but Tom Anthony’s post illustrated how powerful it can be for SEO when you used it in conjunction with the SEOmoz […]
24 responses to “Using SEOmoz’s Linkscape API with Google Docs”
[…] and some pointers on how to modify it to suit your needs I’ve put up a separate post on Using the Linkscape API with Google Docs, which includes a simpler example spreadsheet to try the code out […]
This is fantastic explanation, thank you very much!
I am having some issue however: the mozRank values are all returning 0.00 and the DA values 1.00 … There doesn’t seem to be any problem with callig the API, but the values are obviosly wrong… Do you have any idea why this is happening?
Sorry if I am asking about something blindingly obvious :-s
Thanks again for this tutorial, it made a whole bunch of things a lot clearer!
I have figured it out, sorry…
I had “http://www.(…)” URLs instead of “www.(…)” ones.
Duh.
Hi Maelle,
I’m glad you got it worked out. Let me know if you have any other problems!
-Tom
Hi Tom,
I’ve been using the Google docs competitor analysis that you shared on SEOmoz not long ago and it was working great, but then i went to use it today and no data is showing. Could this be a problem with the API? or is this working fine for you?
Thanks
Hi Jason,
I’ve been having problems, and others have too I think. What is happening is that now lots of people are using these tools and all of them are hitting Google from the same IP addresses (those belonging to the Google Docs) – so some of the time the Google Search servers are blocking the Google Docs servers because they can see they are being used for automated requests.
Unfortunately, there isn’t much we can do about this at the moment, but I am looking into solutions and will post anything I find. I have a couple of ideas to look into.
Did you manage to find a solutions? It randomly works or doesn’t work for me!
Great – thanks for your reply Tom (and good luck).
Im wondering why linking root domains column does not show any details? 🙂
Jayson,
I am having the same issue. Did you figure it out?
Thanks
Mike
Link Root domains is not working for me either. Is there an update needed for the script? Also could the metrics be expanded to include Page Authority?
Thanks
Jason
Since december this is no longer working that good for me. I used to be able to check 300-500 URL’s with no problems, today I can probably check 15 links and then need to wait 30 seconds. Getting error 503 throttled.
Working with big lists (1000+) this is almost impossible.
I wish to find an alternative to this.
Is it somehow possible to run it somewhere else than on Google docs?
Or maybe queue the script to check 1 line every 2 seconds (like ToS says we SHOULD use it)
I really need an answer on this one!
Love the article! But wondering if anybody has found any solutions for working with large lists. (i.e. Bruce’s suggestion to “maybe queue the script to check 1 line every 2 seconds”)
I think this has to do with the new throttling requirements. I built a tool that uses the free API and basically just added a delay between API calls for 2 seconds between each one. Now it works fine (albeit much slower).
Please release a new script!
Hi everyone,
I’ve just updated the post with a link to an update that Chris Le over at SEER Interactive has put together that deals with the new rate limit requirements. 🙂
Hey guys Noob here just wondering about adding the key. I’m getting missing ; before statement ?
Hey Tom,
Any advice on where to start if I want to learn how this API is working, line by line, so I can implement similar things with other APIs (such as Raven Tools)? Thanks!
[…] then input the following script with only a few changes from the one that Tom Anthony graciously provided on his […]
[…] recently updated Tom Anthony‘s original tool to get SEOmoz data into Google Docs. My update includes a simpler setup and […]
[…] using Google Docs for SEO by Richard Baxter. Tom Critchlow followed suit a couple months later but Tom Anthony’s post illustrated how powerful it can be for SEO when you used it in conjunction with the SEOmoz […]
The API looks great. Wondering how to manage with a large list thought
Hello your article is good really very nice and useful for me.