n8n Workflow: Diagnose Website Friction with Clarity & GPT + Slack

Spot Website Friction Every Day—and Get Actionable Fix Ideas with GPT + Slack

This n8n workflow automatically pulls Microsoft Clarity friction metrics daily, retrieves the affected page content via Bright Data Web Unlocker, then uses GPT-5.6 (OpenAI) to diagnose likely causes and fixes—finally logging results to Google Sheets and sending a clean digest to Slack.

What this workflow does

• Runs on a daily schedule to keep friction insights continuously fresh.
• Fetches page-and-device friction metrics from the Microsoft Clarity Data Export API.
• Reads previous run history from Google Sheets to compare trends over time.
• Normalizes and pivots metrics into per-page totals, removes duplicate/junk URL variants, ranks pages by friction percentage, and keeps only pages that are new or worse than last time.
• Retrieves shortlisted page content as markdown through Bright Data Web Unlocker, extracting page headings and link text for context.
• Analyzes with GPT-5.6 (OpenAI) to return: likely cause, the first element to inspect, a concrete fix, and a confidence level.
• Appends results to Google Sheets (one row per page, including fetch failures) and posts one formatted summary to Slack.

Use cases

• SaaS teams want to detect emerging conversion friction (by page/device) before it impacts performance.
• Automation engineers need a practical n8n template for tying together Clarity, web content retrieval, GPT analysis, and team notifications.
• Web/UX operators use daily Slack digests to prioritize which pages to inspect and remediate first.

Technical details

• Integrations: Microsoft Clarity Data Export API, Bright Data Web Unlocker, OpenAI (GPT-5.6), Google Sheets, Slack.
• Workflow nodes mentioned: if, set, code, no op, merge, slack.
• Authentication setup: Clarity via header auth sending Authorization: Bearer <token>; Bright Data Web Unlocker via HTTP Header Auth; OAuth for Google Sheets and Slack.