Posted by DaveSottimano
We’’ ve formally launched the Moz API for Google Sheets and wish to take you on a fast function trip.
This Google Sheets add-on enables users to collect Moz URL metrics quickly without utilizing code straight in a Google Sheet and supplies a couple of additional functions to assist you control information.
In the past, if you desired link metrics for numerous URLs, you either needed to enter them by hand one at a time, or you required technical proficiency to utilize the LinkScape API. I constructed this complimentary Google Sheets add-on, and now you can pull link metrics for those URLs in seconds, no coding needed.
Here are a couple of usage cases for the Moz API for Sheets add-on:
.Get Moz Spam Score in metric to help hazardous link analysis (paid strategy needed). Get domain authority and page authority wholesale to assist you examine the quality of websites for link outreach, domain appraisal, and more (readily available with complimentary and paid strategies). Usage integrated custom-made solutions to parse URLs, conserve URLs to the Wayback Archive, and so on, all without needing to compose complex embedded solutions or utilize routine expressions.
Here’’ s what you can anticipate as output from the add-on:
. 
The only thing you’’ ll requirement to start is a Google account and Mozscape API qualifications (a complimentary strategy is offered).
.Essential constraints:.The complimentary strategy will permit the collection of domain authority and page authority for 200 URLs at a time, at a rate of 10 URLs per 10 seconds.The paid strategy will permit all metrics for 10,000 URLs at a time without any rate restricting.
Once you have actually the add-on set up, you’’ ll requirement to enter your Mozscape API qualifications to trigger the tool. From there, merely pick your metrics and include your URLs to get the report working.
The solutions tab.
There are a couple of useful custom-made solutions that feature the add-on. Just click the ““ solutions ” tab at the bottom of the add-on to see them. As you type any of these solutions, an aid submit will turn up to assist you.
For example, utilize the =PARSE_URL formula to rapidly parse URLs into the root, course, anchor, and more without needing to compose novel-length solutions or keep in mind hard routine expressions.
Stuck? Click the ““ assistance ” tab to show extra info.
That’s it! We hope you take pleasure in the add-on and we invite your feedback.
P.S. An enormous thank you to Britney Muller and Cyrus Shepard for offering me the chance to develop the add-on and being extremely patient/helpful throughout the procedure.
Sign up for The Moz Top 10 , a semimonthly mailer upgrading you on the leading 10 most popular pieces of SEO news, suggestions, and rad links revealed by the Moz group. Think about it as your special absorb of things you do not have time to pursue however wish to check out!
Read more: tracking.feedpress.it