Track AI brand visibility across GPT, Gemini and Perplexity in Google Sheets

This template measures brand visibility across multiple AI assistants. It sends the same prompts to GPT, Gemini, and Perplexity, evaluates whether a target brand is mentioned, extracts visibility details, and saves structured results to Google Sheets for comparison. 🚀 How It Works

1. Load Active Prompts from Google Sheets The workflow reads prompts from the Prompts sheet. Each row contains: • Prompt • Target Tool • Status Only rows where Status = Active are processed. Example: Prompt Target Tool Status Best project management tools for startups Notion Active
2. Load Brand Visibility Criteria The workflow loads evaluation rules from the Criteria sheet. Each criterion contains: • criteria • instruction • example All criteria are combined into a single evaluation instruction shared across all evaluator agents. Example criterion: criteria instruction example Brand Mention Check whether target brand appears in AI answer "Notion was recommended..."
3. Send Prompts to Multiple LLMs Each active prompt is sent to: • GPT • Gemini • Perplexity All models receive the exact same input prompt. Example: Best project management tools for startups This allows direct comparison between providers.
4. Merge Responses with Prompt Metadata Each AI response is merged with: • original prompt • target brand • model source This keeps all evaluation data connected to the originating prompt.
5. Evaluate Brand Visibility Evaluator agents analyze each AI response using the shared criteria. They extract: • whether the target brand was mentioned • all mentioned brands • mention order/position • number of brands mentioned • short visibility description Example: LLM Mention Position GPT Yes 2 Gemini No Empty Perplexity Yes 1
6. Save Structured Results to Google Sheets The workflow writes one row per evaluated response into the Results sheet. Saved fields include: • Date • Prompt • Mention • Brands name • Number • Position • Description • Model • LLM 🛠️ Setup Instructions Import Template Import the workflow into n8n. Prepare Google Sheets Create a spreadsheet with three sheets: • Prompts • Criteria • Results You can find a public example Google Sheet link inside the “GOOGLE SHEETS STRUCTURE” sticky note in the workflow. Prompts sheet example columns: • Prompt • Target Tool • Status Criteria sheet example columns: • criteria • instruction • example Results sheet example columns: • Date • Prompt • mention • brands name • number • position • description • Model • LLM Configure Credentials Connect credentials for: • Google Sheets • OpenAI • Google Gemini • Perplexity API / HTTP Header Auth Configure Google Sheets Nodes Open: • Get prompts • Get criteria • Write GPT Results • Write Gemini Results • Write Perplexity Results Select your spreadsheet and the correct sheets. Configure Perplexity Open the Perplexity Request node. Set your HTTP Header Auth credential with your Perplexity API key.

Run a Test Add a few active prompts to the Prompts sheet. Click Execute Workflow. Check the Results sheet after execution. 📌 Limitations • Results depend on each LLM’s generated answer. • Different LLMs may mention different brands for the same prompt. • Evaluator output quality depends on the clarity of your criteria. • Perplexity requires a valid API key and HTTP Header Auth setup. • The workflow does not verify whether the mentioned brands are factually accurate; it only evaluates what appears in the AI answer. ✅ Example Use Cases • Track whether your brand appears in AI recommendations. • Compare visibility across GPT, Gemini, and Perplexity. • Monitor brand positioning over time. • Analyze competitor mentions in AI-generated answers. • Build an AI search visibility dashboard in Google Sheets. ⏱️ Estimated Setup Time ~15–20 minutes Import workflow → connect credentials → configure Google Sheets → add prompts → run test.