Connect Microsoft Clarity to Google Sheets

Bring your Microsoft Clarity data into Google Sheets with Windsor.ai, so your sheets read live session and engagement data.

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

Get your Microsoft Clarity data into Google Sheets

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

Find frustrating pages

Rage Click Sessions With Metric Percentage and Dead Click Sessions With Metric Percentage per URL show where visitors click on things that do not respond.

Compare devices

Average Scroll Depth, Active Time and Total Session Count per Device show how mobile and desktop visitors use the site.

Catch script errors

Script Error Sessions Count and Error Click Sessions Count per URL and Browser show where errors reach visitors.

Using Windsor.ai to connect data from Microsoft Clarity to Google Sheets

Supported fields: 38 metrics32 dimensions

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

For the last 3 days, rank pages by Rage Click Sessions With Metric Percentage and Dead Click Sessions With Metric Percentage, with the URL and Rage Click Sessions Count.
Compare Average Scroll Depth, Active Time and Total Session Count by Device for the last 3 days.
Which URLs had the most Script Error Sessions Count in the last 3 days? Show Script Error Sessions With Metric Percentage and the Browser.
Show Total Session Count, Total Bot Session Count and Distinct User Count by Channel for the last 3 days.
For yesterday, list the pages with the highest Quickback Click Sessions Count and Excessive Scroll Sessions Count.

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

How to connect Microsoft Clarity to Google Sheets with Windsor.ai

Explore a step-by-step guide to integrate your Microsoft Clarity 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 Microsoft Clarity as your data source, enter a name for the account and your Clarity Data Export API key. To create the key, open your Clarity project and go to Settings > Data Export > Generate new API key. Then click Add Account.

Select your destination

Set Google Sheets as the destination for your data.

Select the reporting fields

Choose the Microsoft Clarity 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 Microsoft Clarity?

Microsoft Clarity is a free user behavior analytics tool from Microsoft. It records how visitors use a website, with session recordings, heatmaps and metrics such as rage clicks, dead clicks and scroll depth.

What Microsoft Clarity data can I load into Google Sheets?

Windsor.ai gives access to 70 Microsoft Clarity fields. These are the groups; the Microsoft Clarity field reference lists all of them:

Traffic: Total Session Count, Total Bot Session Count, Distinct User Count, Pages Per Session Percentage.
Engagement: Active Time, Total Time, Average Scroll Depth.
Frustration signals: Rage Click Sessions Count, Rage Click Sessions With Metric Percentage, Dead Click Sessions Count, Dead Click Sessions With Metric Percentage, Quickback Click Sessions Count, Excessive Scroll Sessions Count.
Errors: Error Click Sessions Count, Error Click Sessions With Metric Percentage, Script Error Sessions Count, Script Error Sessions With Metric Percentage.
Breakdowns: URL, Page Title, Referrer URL, Channel, Source, Medium, Campaign, Device, Browser, Operating System, Country.
Date and account: Date, Clarity Number Of Days, Clarity Metric Type, Account Name.

How does Windsor.ai load Microsoft Clarity data into Google Sheets?

Windsor.ai sends your chosen Microsoft Clarity 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 keep more than 3 days of Microsoft Clarity data?

Yes, by collecting it over time. Clarity’s API only returns the last 1 to 3 days, so a destination task that saves the data every day can build the history in a sheet or a warehouse. The guide How to keep more than 3 days of Microsoft Clarity data has the steps.

Can I combine Microsoft Clarity data with other sources in my sheets?

Yes. Windsor.ai supports 350+ data sources, so Microsoft Clarity data can sit next to other connected sources in the same sheets. For example, put Clarity Total Session Count and Rage Click Sessions Count by Channel next to GA4 Sessions and Engagement rate by Session default channel group for the same days.

Do I need to code to connect Microsoft Clarity to Google Sheets?

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

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

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

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

Tired of manual Microsoft Clarity 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