Competitive Intelligence Dashboard

# Competitive Intelligence Dashboard

1Overview

This workflow automates the collection, analysis, and reporting of competitor activity and market trends by combining web research, sentiment analysis, and automated report generation. It reduces the time spent manually monitoring competitors from 6-8 hours per week to near-zero active time, allowing your team to make faster, data-driven strategic decisions. Ideal for product managers, competitive analysts, marketing strategists, and business development teams.

---

2What's in This Pack

1. Perplexity

What it does: Perplexity is an AI-powered search engine that combines real-time web data with large language model reasoning to answer questions and detect emerging trends. Unlike traditional search engines, it synthesizes information from multiple sources and presents findings in natural language, making it ideal for research tasks that require current information.

Role in this workflow: Perplexity conducts weekly web research on competitor announcements, product launches, pricing changes, and market trends, then surfaces the most relevant intelligence for your analysis.

Documentation: Perplexity API Documentation

• Perplexity's API has rate limits on the free tier; upgrade to Pro for uninterrupted weekly automation.
• The tool works best when you provide specific competitor names and market segments to search for, rather than vague queries.

---

2. Grok

What it does: Grok is a large language model developed by xAI that specializes in real-time reasoning and analysis. It can process text, analyze sentiment, and generate insights from unstructured data like social media posts, customer reviews, and news articles.

Role in this workflow: Grok analyzes sentiment and extracts key insights from competitor social media, customer feedback, and press releases to identify shifts in market perception and competitive positioning.

Documentation: Grok Documentation

• Grok performs exceptionally well on sentiment analysis and tone detection, which is critical for understanding how markets perceive competitor moves.
• API access requires an X Premium subscription; ensure your account meets this requirement before configuring integrations.

---

3. Notion AI

What it does: Notion is a workspace platform that combines note-taking, databases, and project management. Notion AI is its built-in artificial intelligence feature that can synthesize long-form content, generate summaries, and transform raw data into polished reports and documents.

Role in this workflow: Notion AI transforms raw research findings and sentiment analysis into professional, weekly intelligence reports that are automatically formatted and ready for stakeholder distribution.

Documentation: Notion AI Documentation

• Notion AI works best with structured input (lists, tables, or tagged content); ensure research findings are organized before feeding them into the synthesis step.
• Report formatting is highly customizable within Notion, so you can tailor the output to your company's branding and style guide.

---

4. ClickUp

What it does: ClickUp is a project management and team collaboration platform that centralizes tasks, documents, and workflows in one place. It replaces multiple tools by offering task tracking, document collaboration, time tracking, and team communication features.

Role in this workflow: ClickUp serves as the command center where weekly intelligence reports are stored, assigned for review, tracked for completion, and distributed to stakeholders. It also logs all competitive findings in a centralized searchable database.

Documentation: ClickUp API Documentation

• The free tier lacks API access; you'll need the paid Unlimited plan if you want to automate data flow from Perplexity, Grok, or Notion into ClickUp.
• ClickUp's folder and list structure should mirror your competitive landscape (e.g., separate folders for each competitor, or by product category) for easy navigation and retrieval.

---

3Prerequisites

• Perplexity account: Sign up at https://perplexity.ai. Upgrade to the $9/month Pro plan for API access.
• Grok access: Create or upgrade an X (Twitter) account and subscribe to X Premium ($8/month) to enable API access.
• Notion workspace: Set up a paid Notion account ($8–$15/month for Teams or Business plans) and enable Notion AI ($4/month per user).
• ClickUp workspace: Create a free ClickUp account at https://clickup.com, then upgrade to the Unlimited plan ($19/month per member) for API integration.
• API keys: You will need to generate and securely store API keys for Perplexity, Grok, and ClickUp. These are unique authentication tokens that allow software to access these services programmatically. Store them in a password manager or secure environment variable file (never commit them to version control).
• Automation platform (optional but recommended): Set up a free or paid account on Zapier (https://zapier.com) or Make (https://make.com) to orchestrate data flow between tools. Zapier is recommended for beginners; it requires no coding.
• Weekly schedule: Decide on a fixed day and time for the workflow to run (e.g., every Monday at 9 AM). This will be configured in your automation platform.

---

4Setup & Integration Guide

5. Setting Up Perplexity

1. Navigate to https://perplexity.ai and click Sign Up.
2. Create an account using your email address or a single sign-on (SSO) provider like Google.
3. Once logged in, navigate to Settings (gear icon in the top right).
4. Select API & Integrations from the left sidebar.
5. Click Create API Key and copy the generated key to a secure location (password manager or environment file). This is your Perplexity API key.
6. Upgrade to the Pro plan ($9/month) by clicking Billing > Upgrade to Pro. API access is not available on the free tier.

``` { "model": "pplx-7b-online", "messages": [{"role": "user", "content": "What are the latest product announcements from [Competitor Name] in the last week?"}] } ```

---

6. Setting Up Grok

1. Log in to your X (Twitter) account at https://x.com. If you don't have one, create an account.
2. Click your profile icon (top right) and select Settings and Privacy.
3. Navigate to Premium and select Subscribe to X Premium ($8/month). Complete payment.
4. Return to Settings and Privacy and find Developer Portal (or navigate directly to https://developer.x.com).
5. Click Create App and fill in the app name (e.g., "Competitive Intelligence Grok"), description, and use case.
6. Once created, navigate to your app's Keys and Tokens section.
7. Generate or copy your API Key and API Secret Key and store them securely. These are your authentication credentials.
8. Also generate a Bearer Token from the Keys and Tokens section and store it separately.

``` { "model": "grok-2", "messages": [{"role": "user", "content": "Analyze the sentiment in these customer reviews about [Competitor Name]: [reviews text here]"}] } ```

---

7. Setting Up Notion AI

1. Navigate to https://notion.so and log in to your account. If you don't have one, click Sign Up.
2. Create or open a paid Notion workspace. Free workspaces do not support Notion AI.
3. Once inside your workspace, click your profile icon (bottom left) and select Settings & members.
4. Navigate to Plans and confirm your workspace is on a Teams ($8/month) or Business ($15/month) plan. Upgrade if needed.
5. In the same workspace, click Settings & members > Upgrades and enable Notion AI ($4/month per user). Confirm the payment method.
6. Create a new database or page in your workspace to store competitive intelligence reports (e.g., a table titled "Weekly Intelligence Reports").
7. To generate your Notion API key (for automation), go to https://www.notion.so/my-integrations and click Create new integration.
8. Name your integration (e.g., "Competitive Intelligence Automation"), select your workspace, and set capabilities to Read and Update content. Click Submit.
9. Copy your Internal Integration Token and store it securely. This is your Notion API key.

• Competitor: Text field (from Perplexity research)
• Key Findings: Rich text or long text field (from Perplexity output)
• Sentiment Analysis: Select field with options like Positive, Neutral, Negative (from Grok analysis)
• Report Generated: Checkbox (auto-filled when created)

Once data is in Notion, use Notion AI to synthesize findings into a polished report by opening the page and clicking the Ask AI button (or AI in the toolbar).

---

8. Setting Up ClickUp

1. Navigate to https://clickup.com and click Sign Up.
2. Create an account using your email or SSO provider.
3. Create a new Workspace (or use the default one) and name it something descriptive like "Competitive Intelligence".
4. Inside your workspace, create a Folder structure to organize competitors. For example, create folders named after each competitor (e.g., "Competitor A", "Competitor B") or by market category (e.g., "Product Competitors", "Market Trends").
5. Within each folder, create Lists to track specific types of intelligence (e.g., "Product Announcements", "Pricing Changes", "Customer Feedback Shifts").
6. For API access, click your profile icon (bottom left) and select Settings.
7. Navigate to API Integrations and scroll to API Token. Click Generate and copy your token. Store it securely.
8. Create a Task or List template for weekly reports. For example, create a template task with the following fields:

• Task Title: "Weekly Intelligence Report — [Week of DATE]"
• Description: (Leave blank; automation will populate)
• Assigned to: (Assign to yourself or a team lead)
• Due Date: Set to the day reports should be reviewed
• Priority: High
• Custom Fields: Add fields like "Competitor Names", "Key Trends", "Sentiment Shift", "Action Items"

• Task Name: Use Notion AI's synthesized report title
• List: Select the "Weekly Intelligence Reports" list
• Description: Paste the full report text from Notion
• Custom Fields: Populate from Grok sentiment analysis and Perplexity research topics
• Due Date: Set to 5 days after report generation (allowing review time)
• Assigned to: Route to a manager or analyst for review

You can also use ClickUp's Webhook feature (a real-time notification trigger) to automatically send Slack notifications when tasks are created or updated. To set up: In ClickUp, navigate to Settings > Integrations and add a Webhook. Set the trigger to "Task Created" and the URL to your Slack webhook endpoint (obtained from Slack's Incoming Webhooks feature).

---

5Step-by-Step Workflow

Step 1:

1. Tool: Perplexity
2. Action: Use your automation platform (Zapier or Make) to send a scheduled weekly request to Perplexity's API. The request should ask for the latest announcements, product launches, and pricing changes from your list of competitors over the past 7 days. For example: "List all product announcements and pricing changes from [Competitor A] and [Competitor B] in the past week."
3. Data handoff: Perplexity returns research findings as plain text. Export or copy this output and prepare it for the next step.
4. Pro tip: Be specific in your Perplexity queries. Instead of "What's new with competitors?", ask "What new features or pricing changes did [Competitor X] announce in the last 7 days?" Specificity yields higher-quality intelligence.

Step 2:

1. Tool: Grok
2. Action: Using your automation platform, send the competitor data (social media posts, customer reviews, press release excerpts) collected by Perplexity to Grok's API. Ask Grok to perform sentiment analysis and identify shifts in market perception. For example: "Analyze the sentiment in these customer reviews and social media posts about [Competitor A]. Classify each as Positive, Neutral, or Negative, and summarize the overall perception shift."
3. Data handoff: Grok returns a sentiment analysis report as plain text. Include sentiment scores, classified excerpts, and perception trends.
4. Pro tip: Send Grok the raw customer feedback and social media data alongside Perplexity's research for a more complete picture. Grok performs better with actual quotes and customer language rather than summaries.

Step 3:

1. Tool: Notion
2. Action: Using your automation platform, create a new entry in your Notion database for this week's intelligence. Populate fields with structured data:

• Competitor Name: (from Perplexity research)
• Key Findings: (from Perplexity research findings)
• Sentiment Analysis: (from Grok sentiment scores)
• Market Implications: (leave blank for AI to fill)
• Report Date: (auto-filled as today's date)

1. Data handoff: Once the entry is created in Notion, manually open the page and click the Ask AI button (or use the AI command in the toolbar). Prompt Notion AI with: "Synthesize this week's competitive intelligence into a professional executive summary. Include market implications and recommended actions."
2. Pro tip: Use Notion AI's Edit & Continue feature to refine the report tone and structure. If the report is too technical, ask AI to "Simplify this for a non-technical executive audience."

Step 4:

1. Tool: ClickUp
2. Action: Use your automation platform to create a task in ClickUp's Weekly Intelligence Reports list. Pull the synthesized report from Notion and paste it into the ClickUp task description. Populate custom fields with:

• Competitor Names: (comma-separated list)
• Key Trends Detected: (from Perplexity findings)
• Sentiment Shift: (from Grok sentiment summary)
• Action Items: (AI-generated recommendations from Notion)

1. Data handoff: The task is now in ClickUp and assigned to your team. No further handoff is needed; ClickUp serves as the single source of truth.
2. Pro tip: Set the task due date to Friday or your preferred review day. This gives stakeholders the full week to act on the intelligence before the next report cycle.

Step 5:

1. Tool: ClickUp (Webhook to Slack)
2. Action: When the ClickUp task is created, a webhook automatically triggers a notification to your team's Slack channel. The notification includes the report title, assigned reviewer, and a link to the full task in ClickUp.
3. Data handoff: The Slack message serves as a lightweight alert; clicking through goes to the full ClickUp task for review.
4. Pro tip: Use Slack's Workflow Builder to automatically post the report to a pinned message in a #competitive-intelligence channel. This creates a historical record that team members can search and reference.

---

6Integration Map

Data Flow:

1. Perplexity (research & trends) → outputs plain text research findings
2. Research findings → Grok (sentiment & analysis) → outputs sentiment scores and insights
3. Perplexity findings + Grok insights → Notion (synthesis) → outputs polished executive summary
4. Notion report → ClickUp (tracking & distribution) → outputs assignable task with report attached
5. ClickUp task creation → Slack (webhook notification) → alerts team to review

File Formats at Each Handoff:

• Perplexity → Grok: Plain text (UTF-8) or JSON with research data
• Grok → Notion: Plain text sentiment analysis with scores (e.g., "Sentiment: 72% Positive")
• Notion → ClickUp: Rich text (HTML) or plain text executive summary
• ClickUp → Slack: JSON webhook payload (Slack renders it as a formatted message)

Automation Opportunities (Use Zapier or Make):

• Fully automated: Perplexity → Grok → Notion → ClickUp (no manual steps if APIs are properly configured)
• Semi-automated: After ClickUp task creation, a human reviews the report in ClickUp before distributing via Slack. This prevents incorrect or incomplete reports from reaching stakeholders.
• Manual handoff points:
• Notion AI synthesis requires a human click to trigger ("Ask AI" button) — automate this by using Make/Zapier to call Notion AI via API, but note that this requires custom configuration and may not be available in standard Zapier templates.
• Report review in ClickUp should remain manual to ensure quality and accuracy.

Why certain steps require manual input:

• Notion AI's "Ask AI" synthesis step currently requires UI interaction; there is no direct API call to trigger synthesis programmatically. However, you can pre-structure the request by asking an AI to draft the prompt, then manually copy-paste it.
• ClickUp task assignment and due date setting should remain manual to allow flexibility based on team availability and priorities for that week.

---

7Troubleshooting