Google Sheets Add-On: SEO Audits

Google Sheets Add-On: SEO Audits

How to install Octoboard SEO Audits add-on

Octoboard Google Sheets add-on works as a sidebar inside your Google Sheets documents and it can be installed from the Google Workspace Marketplace.

Go to Google Workspace Marketplace, locate SEO Audit add-on and install it for your organization or your individual account.

Once installed, you can use the Launch Sidebar option in your document.

Launch octoboard sidebar seo audit

In the sidebar, you will need to connect to your Octoboard account. If you do not have an account, you will be able to create one using the same interface.

Log into octoboard account

You will need to select the Octoboard product that you want to use to collect the data – Octoboard for Business or Octoboard for Agencies. Please make sure you select the correct account. All connections that you create in your Octoboard account will only be visible within that account and cannot be transferred.

You will be asked to either create a new account or to log in to an existing one.

The account that you selected will need to have the Octoboard Google Sheets license in order to run automated queries and collect cloud data.

For more details on add-on pricing, please follow this link.

Once you have connected to your Octoboard account, your sidebar will load and will display the SEO Audits interface.

Google sheets sidebar loaded seo audit

You can now start entering website domains and running SEO Audits.

How to use the SEO Audit interface

The interface is quite simple and intuitive. Enter a website address to the edit box in the sidebar.

Below the range element, the add-on will show the maximum number of API requests that could be required to provide information for all entered IP addresses. If information can not be retrieved for some of the IP addresses, these API updates would not be counted toward your quota.

Google Sheets add-on is priced on the number of queries run per day. For more details on Google Sheets pricing, please follow this link.

Once you click the RUN AUDIT button, our platform will run queries for selected website and, if successful, will return the following information:

  • Domain, URL, H1, H2, H3 headers and canonical URL checks
  • Website title, description and social links
  • Content size and website speed (response times)
  • Scripts loading, time to render, Javascript errors
  • Redirects: SSL and canonical
  • Files verified - robots.txt, sitemap.xml
  • Google Analytics installation
Seo audit details results

For an overview of the Google Sheets Add-ons in Octoboard, please read this tutorial.