Connect Ahrefs to Google Sheets

Bring your Ahrefs data into Google Sheets with Windsor.ai, so your sheets read live SEO data.

Pick the Ahrefs 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 Ahrefs to Google Sheets connector

Get your Ahrefs data into Google Sheets

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

Find keywords close to page one

Best Position, Search Volume and Keyword Difficulty come per Keyword, so you can list the keywords ranking 11 to 20 that have enough searches to work on.

See which pages bring traffic

Page Traffic, Page Keywords and Top Keyword per Top Page URL show which pages get the most organic visits and the keyword behind each.

Follow new and lost links

New Links, Lost Links and Referring Domain Rating per Referring Domain show which sites added or removed links to you in the period you choose.

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

Supported fields: 49 metrics53 dimensions

Windsor.ai moves your Ahrefs 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:

List keywords with a Best Position from 11 to 20, with Search Volume and Keyword Difficulty, sorted by Search Volume.
Show the 10 Top Page URLs with the most Page Traffic, with Page Keywords and Top Keyword.
List the Referring Domains with New Links this month, with their Referring Domain Rating and Dofollow Links.
Compare AI Responses ChatGPT and AI Responses Google AI Overviews for my 20 Top Page URLs with the most Page Traffic.
Show Domain Rating, Organic Traffic and Organic Keywords for my site.

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

How to connect Ahrefs to Google Sheets with Windsor.ai

Explore a step-by-step guide to integrate your Ahrefs 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 Ahrefs as your data source, enter your Ahrefs API key, and enter the target: the domain or URL you want to report on.

Select your destination

Set Google Sheets as the destination for your data.

Select the reporting fields

Choose the Ahrefs 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 Ahrefs?

Ahrefs is an SEO and marketing platform with its own databases of backlinks, keywords and search results. Marketers use it to see which keywords a site ranks for, how much organic traffic its pages get, and which domains link to it.

What Ahrefs data can I load into Google Sheets?

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

Site overview: Domain Rating, Ahrefs Rank, Organic Traffic, Organic Keywords, Organic Keywords Top 3, Organic Cost, Paid Traffic, Paid Keywords.
Backlinks: Backlinks, Referring Domains, Historical Backlinks, Historical Referring Domains, and per Referring Domain: Referring Domain Rating, Dofollow Links, New Links, Lost Links, First Seen, Last Seen, Is Spam.
Organic keywords: Keyword, Best Position, Best Position URL, Search Volume, Keyword Difficulty, CPC, Keyword Traffic, SERP Features Count, and search intent flags such as Is Informational and Is Commercial.
Top pages: Top Page URL, Page Traffic, Page Keywords, Top Keyword, URL Rating, and AI Responses for ChatGPT, Gemini, Perplexity, Copilot, Grok, Google AI Overviews and Google AI Mode.
Time and location: Date, Country, Keyword country.

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

Windsor.ai sends your chosen Ahrefs 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 Ahrefs data with other sources in my sheets?

Yes. Windsor.ai supports 350+ data sources, so Ahrefs data can sit next to other connected sources in the same sheets. For example, put Ahrefs Best Position and Keyword Traffic next to Google Search Console clicks and impressions for the same keywords, so estimated and measured search traffic sit in one table.

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

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

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

The free forever plan covers 1 data source, so connecting Ahrefs on its own costs nothing and needs no credit card. Combining Ahrefs 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 Ahrefs and Google Sheets?

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

Tired of manual Ahrefs 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