Optimize LLM Share of Voice with Automated Weekly Reports

Enhance Your Brand's Visibility with Automated Weekly LLM Share of Voice Reports

Optimize your brand’s digital presence effortlessly with our advanced n8n workflow designed for precise Share of Voice analysis. This automation runs weekly, systematically querying multiple Large Language Models (LLMs) via OpenRouter, analyzing brand mentions and domain citations, and delivering insightful HTML reports directly to your inbox.

What This Workflow Does

• Runs on a weekly schedule to kickstart your brand visibility analysis.
• Extracts active prompts from a Google Sheets “prompts” tab, expanding into multiple model iterations, and initiates OpenRouter chat completions accordingly.
• Processes responses through OpenRouter, standardizing into answer texts and citation URLs, and documents results in the “runs” tab.
• Utilizes brand definitions from the “brands” tab to identify brand mentions and citations, recording these findings per model run in the “mentions” tab.
• Calculates comprehensive weekly metrics, including mention rates, citation rates, Share of Voice, and average first-mention position. Results are collated into the “weekly_agg” tab.
• Compiles an HTML report, contrasting current metrics with the prior week, and highlights significant changes such as Share of Voice drops or zero citation rates before emailing the report to stakeholders.

Use Cases

• SaaS operators can monitor brand health across various LLM platforms efficiently, making informed strategic decisions.
• Automation engineers aiming to streamline brand monitoring will find this workflow invaluable for ensuring consistent data flow and analysis.
• Marketing teams can leverage these insights to enhance brand strategies and boost market influence with minimal manual intervention.

Technical Details

• Google Sheets: Centralizes prompt handling and data aggregation across multiple tabs.
• OpenRouter: Facilitates interactions with multiple LLMs for robust data collection.
• Email Send: Distributes comprehensive HTML reports to key stakeholders.
• Nodes Used: code, no op, wait, email send, sticky note, http request

Empower your brand with data-driven insights and take proactive steps in enhancing your Share of Voice across the digital landscape with our expertly crafted workflow.