Print

Import Semrush Data to Google Sheets

In this guide, we’ll walk through how to pull data from the Semrush API directly into Google Sheets, using the API Connector add-on for Sheets. Semrush offers two main API packages:

  • Standard API package: SEO data, e.g. domain analytics, keyword analytics, backlink analytics, position tracking, etc. This is the full list of reports available through the Standard API package: https://www.semrush.com/kb/972-api-reports
  • Traffic Analytics API: Site traffic data, e.g. visits, average visit duration, mobile vs. desktop traffic %,bounce rate, etc.

This Standard API package is available only through Semrush's Business plan, while the Traffic Analytics API is available on any paid plan. The example below is for the Standard API package, but the request syntax is the same for both.

Contents

Before You Begin

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

Part 1: Get Your Semrush API Key

This section shows how to access the Standard API package. For the Traffic Analytics API, follow these instructions instead.

  1. If you haven't already, upgrade to Semrush's Business subscription. The Standard API package is only available on this plan.
  2. Navigate to the Account tab -> Subscription info -> API Units -> Buy more and buy API units suitable to your needs
    semrush-buymore
  3. Once you've purchased API units, click Generate API key
    semrush-generate
  4. Your key will now be available on the page. Copy this down as we'll use it shortly.
    semrush-copykey

Part 2: Pull Semrush API Data into Sheets

You can fetch data for any of the endpoints and parameters shown in the documentation. For this example, we'll fetch backlinks data. Substitute in your own API key where it says your_key, and your own target domain where it says your_target.

  1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
  2. In the request form enter the following:
    • ApplicationCustom
    • MethodGET
    • Request URLhttps://api.semrush.com/analytics/v1/?key=your_key&target=your_target&type=backlinks_refdomains&target_type=domain&display_limit=30&display_sort=last_seen_desc
  3. Create a new tab and click Set current to use that tab as your data destination.
  4. Name your request and click Run. A moment later you’ll see data populate your sheet.
    semrush-backlinks

Part 3: API Documentation

Official API documentation: https://developer.semrush.com/api/v3/analytics/basic-docs/

Leave a Comment

Jump To