Backlink checker Google sheet
The Google Backlink sheet is designed to check the backlinks pointing to any domain or URL. This sheet utilizes the power of Google sheets + Google App scripts and the SEO Review Tools backlinks API. Enter the domain you want to examine, optionally select the to only return unique domains (optional), enter your API key and hit the get results button. The Google app script will automatically connect with the API and pull all the data into the spreadsheet. This allows you to run backlink reports directly into Google sheets without having to go back and forward between tools.
To keep the spreadsheet quick and responsive you’ll get 100 backlinks every time you hit the Get results button. To go to the next 100 results set the offset input field to 101 and pull the results into the spreadsheet.
Important: please note that the spreadsheet will automatically fill the first 100 rows. If you adjust the Offset and hit the get results button it will automatically override the data that’s already in these cells.
How to get all backlinks pointing to a domain?
To pull all the backlinks pointing to a domain and its subdomains enter: example.com (without “www” and “https”).
How to get all the backlinks pointing to a specific page?
To pull all the backlinks pointing to a specific page enter the full URL: https://example.com/url/.
How to get general backlink statistics for a domain?
We’ve also developed a spreadsheet that enables you to collect all important backlink statistics to perform competitor analysis: View documentation →
Benifits
- Check unlimited backlinks to any domain or specific URL.
- Get all your work done in Google Spreadsheet without having to switch to other applications.
- No programming knowledge needed.
- Great value for money, we offer one of the most affordable backlink APIs on the market.
- A very flexible solution, after coping the spreadsheet you become the owner of the associated app script. This means you can make any adjustment to it that fits your needs.
- The API can be used both in combination with all of our other spreadsheets or directly by calling the API endpoints, it’s all up to you!
Input explanation
| Input | Description |
| URL | Backlinks pointing to a specific PAGE, example: https://example.com/url/ |
| Offset | Optional: Use the offset parameter to get the backlinks after the specified number. |
| Unique domains | Optional: Use the unique_domains parameter to only get one backlink per domain. |
Backlink analysis metrics
The backlink summary report includes the following metrics:
- Backlink Url → URL where the backlink is from
- Backlink Domain → Domain where the backlink is from
- Backlink Domain → Spam score of the backlink on a 0 100 scale (a 100 being a very toxic backlink)
- Backlink Page Authority → The authority of the backlink page on a 0 100 scale
- Backlink Domain Authority → The authority of the backlink domain on a 0 100 scale
- Backlink Link Type → Link type (anchor, image, link, meta, canonical, alternate, redirect)
- Backlink Anchor Text → The text of the backlink
- Backlink Alt → The ALT tag in the case of an image link
- Backlink Dofollow → If the backlink is dofollow (true or false)
- Backlink First Seen → Date and time when the backlink was first discovered
- Backlink Last Seen → Date and time when the backlink was first discovered
- Backlink Link Is Lost → True or False
- Backlink Link Is New → True or False
- Backlink Broken Status → If the backlink is broken (true or false) and responding with a error code
- Backlink External Links On Page → Total number of external links on the page with backlink
- Backlink Link Attribute → Link atributes (nofollow, noopener, ugc, …. )
- Backlink IP → The IP address of the backlink
- Landing Page Url → The URL where the backlink is pointing to (the landing page)
- Landing Page Spam Score → The Spam score on a 0 100 scale of the landing page
- Landing Page Status Code → Status code of the landing page
How to use this sheet
- Make a copy of this spreadsheet
- Register for the API (the API comes with a 15 day free trial)
- Enter your API key
- Enter a list of URLs
- Hit the “Get results” button
The first time you use the sheet
Please note that I will NOT have access to your account and you will be the owner of the script running in your account. Becuse the Google authorisation screens can look pretty intimidating ;-))
- Google will ask for authorization, click “Continue”
- Select the account you want to use
- Google will show the “Google hasn’t verified this app” message, click “advanced”
- Click “Go to ImportJSON (unsafe)”.
- On the “ImportJSON wants to access your Google Account”, click “Allow”
If you have any additional question or suggestions, don’t hesitate to contact me.
Get the new Chrome Extension!