SEMRUSH ONE

Stay Ahead in AI Search & Traditional SEO

Discover More
Outperform your search competitors.
Outperform your search competitors.AI-driven search has arrived—and Semrush One bundles our AI Visibility Toolkit + SEO Toolkit to let you:
See how AI platforms talk about you
Discover valuable topics to cover
Get AI-powered strategy suggestions
Build keyword plans with personalized insights
Identify fixes to improve technical health
Benchmark yourself against competitors
Outperform your search competitors.
10M marketing professionals have already used Semrush
Outperform your search competitors.
Outperform your search competitors.
Outperform your search competitors.
Author Photo

Brian Jensen

Brian Jensen is the CEO of Congruent Digital, a full-service marketing agency specializing in cross-channel digital marketing solutions. When he’s not working, you can find him reading a book, riding his bike, or playing online chess. Try Congruent Digital's free Tweet Indexation Rate Tool here.

Author

How To Use the Semrush API in Google Sheets

Semrush is my favorite competitive research tool that I use for everything from organic and paid keyword research to understanding market share in a specific region. A few months ago, I was working on a large project where it made sense to look beyond the Semrush interface and pull data directly from their servers via the Semrush API. The problem was that I’d never used an API before and wasn’t able to locate any resources for a noob like myself to get started. As luck would have it, I work with some pretty smart people who were able to point me in the right direction. Now that I understand the basics, I want to pay it forward and create a resource for others who use Semrush, but not familiar with using the API.

4 min read