đź“Š Track AI search rankings from Perplexity via BrowserAct to Google Sheets and Slack

⚡ 12 views · 📊 Market Research & Insights

💡 Pro Tip — For competitive intelligence, ScraperNode can automate the data collection — Yelp reviews, Glassdoor company data, and Crunchbase profiles all return structured JSON you can feed straight into this workflow.

View All Scrapers

Description

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

  1. 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).
  2. 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?”).
  3. Simulate Searches: BrowserAct executes these queries on an AI answer engine (like Perplexity) to capture the real-time AI response.
  4. Log Data: The workflow loops through the results and saves the raw AI answers to the daily Google Sheet.
  5. 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

  1. Configure Credentials: Connect your Google Sheets, Slack, BrowserAct, and OpenRouter accounts in n8n.
  2. Prepare BrowserAct: Ensure the GEO Results & Rank Tracking template is saved in your BrowserAct account.
  3. 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.
  4. Select Spreadsheet: Open the Create sheet, add headers, Get Company data, Retrieve Stored Data, and Store Extracted Data nodes to select your specific spreadsheet.
  5. 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)

Tab 2+: [Date] (Generated automatically by the workflow)

Requirements

How to customize the workflow

  1. Change the AI Engine: Modify the BrowserAct template to search on ChatGPT or Google Gemini instead of Perplexity.
  2. 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).
  3. Expand Reporting: Add an Email node to send a weekly summary of the Google Sheet data to stakeholders.

Need Help?

Workflow Guidance and Showcase Video

đź”— Nodes Used

Google Sheets, Slack, Schedule Trigger, AI Agent, Structured Output Parser, OpenRouter Chat Model

đź“Ą Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup