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.

Contents

• Before You Begin
• Part 1: Get WhatCMS API Key
• Part 2: Pull WhatCMS API Data into Sheets
• Part 3: API Documentation

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 https://whatcms.org/ and verify your email address.
   
2. Once you're subscribed, click the API Key link in the left sidebar (or navigate to https://whatcms.org/Account/Key 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:
   • Application: Custom
   • Method: GET
   • Request URL: https://whatcms.org/API/Tech?key=your_key&url=+++Sheet1!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: https://whatcms.org/Documentation