We’ve officially released the Moz API for Google Sheets and want to take you on a quick feature tour.
This Google Sheets add-on allows users to gather Moz URL metrics easily without using code directly in a Google Sheet and provides a few extra functions to help you manipulate data.
In the past, if you wanted link metrics for hundreds of URLs, you either had to enter them manually one at a time, or you needed technical expertise to use the LinkScape API. So, I built this free Google Sheets add-on, and now you can pull link metrics for those URLs in seconds, no coding required.
Here are a few use cases for the Moz API for Sheets add-on:
Here’s what you can expect as output from the add-on:
The only thing you’ll need to get started is a Google account and Mozscape API credentials (a free plan is available).
Once you have the add-on installed, you’ll need to enter your Mozscape API credentials to activate the tool. From there, simply select your metrics and add in your URLs to get the report working.
There are a few helpful custom formulas that come with the add-on. Simply click on the “formulas” tab at the bottom of the add-on to see them. As you type any of these formulas, a help file will pop up to guide you.
For example, use the =PARSE_URL formula to quickly parse URLs into the root, path, anchor, and more without having to write novel-length formulas or remember difficult regular expressions.
Stuck? Click on the “help” tab to display additional information.
That’s it! We hope you enjoy the add-on and we welcome your feedback.
P.S. A massive thank you to Britney Muller and Cyrus Shepard for giving me the opportunity to build the add-on and being incredibly patient/helpful during the process.