Track AI search rankings from Perplexity to Google Sheets and Slack
Track AI search rankings from Perplexity to Google Sheets and Slack This workflow automates Generative Engine Optimization (GEO) tracking by monitoring how your company appears in AI search results. It generates strategic queries, simulates searches on AI engines like Perplexity via BrowserAct, logs the responses for historical tracking, and delivers a graded performance report to Slack. Target Audience SEO specialists, brand managers, marketing directors, and growth teams focusing on AI visibility and reputation management. How it works Initialize Tracking: The workflow runs on a schedule, creates a new dated tab in your Google Sheet, and fetches your company details (Name and Category). Generate Strategy: An AI Agent (using OpenRouter/Gemini) generates three specific search queries: Discovery: Broad category search (e.g., "Best CRM for startups"). Comparison: Direct competitor face-off (e.g., "Pipedrive vs Salesforce"). Validation: Specific fact-checking (e.g., "Is Pipedrive good for visual pipelines?"). Simulate Searches: BrowserAct executes these queries on an AI answer engine (like Perplexity) to capture the real-time AI response. Log Data: The workflow loops through the results and saves the raw AI answers to the daily Google Sheet. Analyze & Report: A second AI Agent reviews the saved data, grades the visibility (Green/Yellow/Red), and sends a summarized "GEO Scorecard" to Slack. How to set up Configure Credentials: Connect your Google Sheets, Slack, BrowserAct, and OpenRouter accounts in n8n. Prepare BrowserAct: Ensure the GEO Results & Rank Tracking template is saved in your BrowserAct account. Setup Google Sheet: Create a Google Sheet with a tab named Main Sheet. Add headers: Company name and Worknig category. Fill in row 2 with your details. Select Spreadsheet: Open the Create sheet, add headers, Get Company data, Retrieve Stored Data, and Store Extracted Data nodes to select your specific spreadsheet. Configure Notification: Open the Send Message to Team on Slack node and select your target Slack channel. Google Sheet Headers Tab 1: Main Sheet (Input) Company name Working Category Tab 2+: [Date] (Generated automatically by the workflow) Search Result Requirements BrowserAct* account with the *GEO Results & Rank Tracking** template. Google Sheets** account. Slack** account. OpenRouter** account (or compatible LLM credentials). How to customize the workflow Change the AI Engine: Modify the BrowserAct template to search on ChatGPT or Google Gemini instead of Perplexity. Adjust Grading Logic: Update the system prompt in the Company data analyzer node to change how the AI scores the results (e.g., focus more on sentiment than ranking). Expand Reporting: Add an Email node to send a weekly summary of the Google Sheet data to stakeholders. Need Help? How to Find Your BrowserAct API Key & Workflow ID How to Connect n8n to BrowserAct How to Use & Customize BrowserAct Templates Workflow Guidance and Showcase Video Master GEO: Track Your AI Search Rankings with n8n & Perplexity 🌍. An n8n automation workflow template by Madame AI Team | Kai.
Madame AI Team | Kai
web
free
Others in the same category, ranked by how often they are opened.
