V1 Moz API for Sheets

Please note: Moz API for Sheets uses V1 of the Moz API

The best way to pull Moz Link data in bulk is via the Links API. Typically, a developer is needed in order to write the code necessary to make calls to the API and to format the raw data for usability. With the Google Sheets add-on for the Moz Links API, you can pull data from the API without needing to write a single line of code.

The Google Sheets add-on for the Moz Links API is an independent tool developed by the community which allows users with Links API access to pull limited data in bulk without having to write code. The metrics able to be pulled with this tool include:

• Domain Authority
• Page Authority
• Spam Score*
• Subdomain External Links*
• Root Domain External Links*
• External Equity Links*
• All Links*
• Root Domains Linking*

*Metrics which require paid API access

• Learn more about these metrics

**Please note: Because the Moz API for Sheets add-on is a free tool developed outside of Moz, Moz's ability to provide support for this add-on is limited.

To get started with the Google Sheets add-on for the Moz Links API you can do one of the following:

1. Head to a new Google Sheets document > Add-ons > Get Add-ons > Moz API for Sheets
2. Head to the GSuite Marketplace directly

This process will only need to be done once unless the add-on is uninstalled at a later date.

Once you’ve installed the Google Sheets add-on, you’re ready to get started! From the Add-ons menu at the top of the screen, select Moz API for Sheets > Start Moz Add-on

After launching the Moz API for Sheets add-on, enter your API credentials in the Keys tab to start making calls. If you do not currently have Moz API access, you can sign up from our API product page.

If there is a problem with the Moz Access ID and/or Moz Secret Key, the tool will produce an Invalid Credentials error- please double check the credentials entered and that your API access is active. Please note: When signing up for a new API key, it may take up to 24 hours for the add-on to recognize your credentials as valid.

• Learn more about getting an API key

After entering your API credentials and clicking Check Access Level, you will be asked to choose the URL Level Metrics you’d like to pull via the API.

Toggle the buttons to the right of each metric to select it - when the toggle button is blue, the metric will be requested via the API when the call is made.

If you have a free API account, you will only have the option to select Domain Authority or Page Authority.

When you’ve selected all the metrics you’d like included in your report, click Click to Enter URLs. You will then be prompted to enter in all the target URLs you’re wanting to request data for. Please be sure to follow the below guidelines to ensure the tool accepts the URLs entered.

• Include the full protocol for the URL (http or https) - only full URLs will be accepted
• Separate each URL by line, not by comma
• Be aware of your max URL limit based on Paid vs Free access (Any URLs over the limit will be ignored by the tool)

When you’re ready to gather the requested data, click Get Data. A popup will appear letting you know that the data is being gathered. Depending on the number of target URLs entered, it may take some time for the data to populate in order to adhere to call rate limits.

The data will then be populated in the Google Sheet for you to sort, filter, and analyze as needed.

After clicking Get Data within the add-on, the following data will be returned for each URL entered.

Information returned for every call:

• Original URL - The original target URL entered.
• Page Title - The title tag associated with the original URL.
• Canonical URL - The canonical form of the URL. Please note: this is not the actual canonical URL of the page.
• HTTP Status Code - The status code returned to the crawl when accessing the original URL.
• Date Last Crawled - The date dotbot last crawled this page.

Information returned based on metric selection for the specific call:

• External Equity Links (Paid access required) - i.e. External Followed Links. Links to the target URL from other sites that are followed (they do not have a "nofollow" tag added to the link).
• Subdomain External Links (Paid access required) - The number of domains with at least one followed link to any page on the subdomain.
• Root Domain External Links (Paid access required) - The number of domains with at least one followed link to any page on the root domain.
• Root Domains Linking (Paid access required) - Number of unique root domains linking to a target. Two links from the same website will only be counted as one linking root domain.
• Links (Paid access required) - The total number of internal, external, follow and nofollow links.
• Spam Score (Paid access required) - Spam Score represents the percentage of sites with similar features we've found to be penalized or banned by Google. This does not mean that the site is spammy. It’s best to use this is a guide to potentially spammy sites for further investigation.
• Page Authority - Page Authority is a Moz proprietary metric from 0-100 which predicts how well a page will rank in Google based on a machine learning algorithm of link metrics.
• Domain Authority - Domain Authority is a Moz proprietary metric from 0-100 which predicts how well a domain will rank in Google based on a machine learning algorithm of link metrics.