Connect Semrush to Google Sheets

Bring your Semrush data into Google Sheets with Windsor.ai, so your sheets read live keyword, ranking and backlink data.

Pick the Semrush fields you need, and Windsor.ai keeps them flowing without a CSV export in between.

Forget CSVs. Stop copy/paste. Connect in minutes. No code required.

Try It Free

Free forever plan

No credit card needed

Windsor.ai is your proven Semrush to Google Sheets connector

Get your Semrush data into Google Sheets

Semrush is connected once in Windsor.ai, and these are the use cases the fields support:

Track organic visibility

Organic Keywords, Organic Traffic and Organic Positions 1-3 by Month show how the domain’s search visibility changes.

Find keyword opportunities

Search Volume, Keyword Difficulty Index and CPC per Keyword show which searches are worth the effort.

Check AI Overview presence

Keywords Triggering AI Overview and Positions in AI Overview show how many of your keywords trigger an AI Overview and how often the domain appears in it.

Using Windsor.ai to connect data from Semrush to Google Sheets

Supported fields: 172 metrics28 dimensions

Windsor.ai moves your Semrush fields into Google Sheets on a connection you set up once, so the sheets stay on live records rather than a CSV someone exported last week.

Pick the fields you need and Windsor.ai handles the rest.

With Windsor.ai, your spreadsheet can:

Show Organic Keywords, Organic Traffic and Organic Cost for my domain for last month, with Organic Positions 1-3, Organic Positions 4-10 and Organic Positions 11-20.
How many keywords were new, improved, declined and lost last month? Use Organic Positions New, Organic Positions Improved, Organic Positions Declined and Organic Positions Lost.
List my keywords with the highest Search Volume and a Keyword Difficulty Index under 40, with CPC and Intents.
Show Keywords Triggering AI Overview and Positions in AI Overview next to Keywords Triggering Featured Snippet and Positions in Featured Snippet for last month.
Compare Intent Commercial Traffic, Intent Informational Traffic and Intent Transactional Traffic for my domain for last month.

Join over 25,000+ businesses that trust Windsor.ai to streamline Semrush to Google Sheets integration

How to connect Semrush to Google Sheets with Windsor.ai

Explore a step-by-step guide to integrate your Semrush data into Google Sheets with the Windsor.ai connector.

Register and log in to Windsor.ai

Create a new Windsor.ai account or log in if you already have one.

Select your data source

Choose Semrush as your data source and enter your Semrush API key, which you find on the Semrush API keys page. Pick what to analyze (a domain, subdomain, subfolder, URL or keyword) and enter its value, for example example.com. Then click Add Account. API access needs the Semrush Advanced plan (formerly Business) or higher, and Semrush API units.

Select your destination

Set Google Sheets as the destination for your data.

Select the reporting fields

Choose the Semrush fields you want to show in your spreadsheet.

Follow the setup instructions to complete the integration

Depending on the integration method you choose, set up the connection by following the prescribed steps, whether through an extension or directly via an in-app destination task.

FAQs

What is Semrush?

Semrush is a platform for measuring visibility in search, advertising and social media. For any domain it estimates organic and paid search keywords, rankings, traffic and backlinks, and it reports keyword data such as search volume and difficulty.

What Semrush data can I load into Google Sheets?

Windsor.ai gives access to 200 Semrush fields. These are the groups; the Semrush field reference lists all of them:

Domain overview: Rank, Authority Score, Organic Keywords, Organic Traffic, Organic Cost, PLA Keywords.
Ranking positions: Organic Positions 1-3, Organic Positions 4-10, Organic Positions 11-20, Organic Positions New, Organic Positions Improved, Organic Positions Declined, Organic Positions Lost.
Keywords: Keyword, Search Volume, Keyword Difficulty Index, CPC, Competition, Intents, Trends, Number of Results.
Search intent: Intent Commercial Traffic, Intent Informational Traffic, Intent Navigational Traffic, Intent Transactional Traffic, Intent Commercial Positions, Intent Transactional Positions.
SERP features: SERP Features, Keywords Triggering AI Overview, Positions in AI Overview, Keywords Triggering Featured Snippet, Keywords Triggering People Also Ask, SERP Features Traffic.
Backlinks: Total Backlinks, Referring Domains, Referring IPs, Follow Backlinks, Nofollow Backlinks, Backlinks New, Backlinks Lost.
Date and account: Date, Month, Year, Domain, Database, Account Name.

How does Windsor.ai load Semrush data into Google Sheets?

Windsor.ai sends your chosen Semrush fields straight into a sheet, either through the Google Sheets add-on or through an in-app destination task. You can set it to refresh on a schedule.

Can I combine Semrush data with other sources in my sheets?

Yes. Windsor.ai supports 350+ data sources, so Semrush data can sit next to other connected sources in the same sheets. For example, put Semrush Organic Traffic and Organic Keywords by Month next to Google Search Console Clicks and Impressions for the same months, to compare the Semrush estimate with the clicks Google reports for your site.

Do I need to code to connect Semrush to Google Sheets?

No. You connect Semrush in the Windsor.ai dashboard, pick the fields you want, and Windsor.ai handles the transfer.

How much does it cost to integrate Semrush with Google Sheets using Windsor.ai?

The free forever plan covers 1 data source, so connecting Semrush on its own costs nothing and needs no credit card. Combining Semrush with other sources needs a paid plan: $19/month for 3 sources or $99/month for 7. See the pricing page.

Do you have helpful links to get started with Semrush and Google Sheets?

Yes. These are the resources to start with for the Semrush to Google Sheets integration:

Tired of manual Semrush data exports? Try Windsor.ai today to work on live data

Access all your data from various sources in one place. Get started for free.

Start for Free Book a Demo