Use SEOmoz API in Google Docs Spreadsheet

[EdgySEO]

Hi,

Has anyone made functions to get link metrics from SEOmoz API in Google docs spreadsheet?

• Page Authority
• Domain Authority
• Linking Root Domains
• Total Links

_Thanks to Tom Critchlow I got the social metrics, now I just need the ones from SEOmoz api. _

Any help would be sweet.

[TomCritchlow]

Hey, as promised - here's Ian's post about using the SEOmoz API with Google Docs:

http://www.conversationmarketing.com/2011/04/linkscape-google-spreadsheets.htm

[EdgySEO]

Thanks, awesome work

[JaspalX]

I had a play with this (having been inspired by Tom's great SEO tools with spreadsheets article) I played around with Google docs and some of the sample code to query the SEOMoz API.

(BTW  I don't think all the data you're looking for is available with the free API.)

I knocked together a google docs spreadsheet that does the query, hope you find it useful as a guide till someone (Messrs. Critchlow and Lurie?) posts something more user friendly.

http://tinyurl.com/63ogm7s

To use it, make your own copy of the sheet, then:

1. enter your member ID and secret key in the blue cells (D1 and F1) - you can get your info from www.seomoz.org/api
2. type a number into B1 for the expiry interval,
3. the search query should be self-explanatory (cells A4,B4 and C4)

As you'll see from the code, I'm no Google docs expert, but hopefully you'll see how the call gets put together.

[EdgySEO]

Cool. Looking forward to it.

[TomCritchlow]

Hey - I've been working with Ian Lurie from Portent and he has a blog post on it's way that details how to do exactly this! Look out for it in the next week or so