Import WhatCMS Data into Google Sheets

In this guide, we’ll walk through how to pull data from the WhatCMS API directly into Google Sheets, using the API Connector add-on for Sheets. This is a useful API that detects which content management system and other technology is being used to power a website.


Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Get Your WhatCMS API Key

  1. To get an API key, you'll first need to create an account at and verify your email address.
  2. Once you're subscribed, click the API Key link in the left sidebar (or navigate to directly). You should see your API key at the top of the page. Copy this as we'll need it shortly.
  3. Optionally sign up for a paid plan. Your requests will be rate limited on the free plan.

Part 2: Pull WhatCMS API Data into Sheets

  1. For this example, we'll start by adding our website URLs into Column A of Sheet1, so we can reference them in our request, since that's the most common use case.
  2. Now open up Google Sheets and click Extensions > API Connector > Open > Create request.
  3. In the request form enter the following:
    • ApplicationCustom
    • MethodGET
    • Request URL!A1:A3+++
  4. Create a new tab and click Set current to use that tab as your data destination.
  5. Name your request and click Run. A moment later you’ll see CMS data for each URL populate your sheet.

Part 3: API Documentation

Official API documentation:

Leave a Comment

Jump To