Using the IndexCheckr API with Google Sheets

Get your API token

Go to the API token page in IndexCheckr and copy your token. Keep this token secure, as it grants full access to your account.

Open Google Apps Script

In your Google Sheet, click Extensions → Apps Script.
Delete any existing code in the editor.

Add the script

Paste this example, replacing YOUR_TOKEN_HERE with your actual token:

function getProjects() {
  var url = "https://indexcheckr.com/api/v1/projects";
  var options = {
    "method": "get",
    "headers": { "X-AUTH-TOKEN": "YOUR_TOKEN_HERE" }
  };
  
  var response = UrlFetchApp.fetch(url, options);
  var result = JSON.parse(response.getContentText());

  // Prepare a table with project info
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  sheet.clear();
  sheet.appendRow(["Project", "Number of Pages", "Indexed Pages", "Non Indexed Pages", "Domains Not Indexed"]);
  
  result.data.forEach(function(project) {
    sheet.appendRow([
      project.name,
      project.numberOfLinks,
      project.numberOfIndexedPages,
      project.numberOfNotIndexedPages,
      project.numberOfDomainNotIndexedPages
    ]);
  });
}

Run the script

Save your script.
Click Run.
Authorize the script when prompted.
Your sheet will now populate with your projects and their indexing stats.

Expand the integration

You can customize the script to:

Pull your remaining credits with the /account endpoint
List pages from a project with /projects/{id}/pages
Schedule automatic refreshes using Triggers in Apps Script

💡 For full details on available endpoints, parameters, and response formats, see the IndexCheckr API documentation.