Content Strategy Analyzer

Analyzes websites to generate multi-language content strategy, keyword research, and competitor analysis. Use when user provides a URL and needs industry ana...

Security Scan

The skill's included scripts are benign and match the content-planning purpose, but the SKILL.md references an external 'Opencode AI' analysis step without any integration code, endpoints, or required credentials — an incoherence that needs clarification before trusting the skill.

Purpose & Capability

The skill claims to perform AI analysis using 'Opencode AI' (identify industry/competitors, generate keywords by country/language), but none of the provided code calls any external AI API or mentions endpoints/credentials. The two included Python scripts only crawl the provided URL and generate an Excel from local JSON. Either the SKILL.md overclaims capabilities or it omits the integration code/credential requirements.

Instruction Scope

Runtime instructions are mostly constrained: ask user for URL/country/language/frequency, run crawl_website.py to save website_data.json, then run generate_excel.py to make an Excel. The 'AI analysis' step is vague and unspecified (no prompts, no API calls), giving the agent wide discretion about how to perform the analysis. The crawler does not check robots.txt or rate limiting, and some extraction fields are unimplemented (headings/content_blocks are empty), which are implementation details rather than direct red flags.

Install Mechanism

No install spec is provided (instruction-only), and the declared Python dependencies (requests, beautifulsoup4, openpyxl) are reasonable and proportional to crawling and Excel generation. No remote downloads or execution of external archives are present.

Credentials

The skill declares no required environment variables or credentials, yet the documentation explicitly names an external AI service ('Opencode AI') for analysis. If that service requires an API key or endpoint, the skill should declare and justify those env vars. Currently there's a mismatch between claimed use of an external AI provider and the lack of any credential/config requirements.

Persistence & Privilege

The skill does not request persistent installation, does not set always:true, and does not modify other skills or system-wide settings. It runs local scripts and writes local files (website_data.json, content_plan.xlsx) only, which is expected for its purpose.

What to consider before installing

Before installing or running this skill, consider the following: - Clarify how the 'AI analysis' step is implemented: does it call an external 'Opencode AI' API? If so, ask the author for the endpoint and which credentials (API key) are required and why. The skill currently does not declare any env vars for that, which is an incoherence. - Review the two included scripts yourself. They are small and straightforward: crawl_website.py issues an HTTP GET to the target URL and saves a JSON, generate_excel.py reads local JSON and writes an Excel file. There is no hidden network exfiltration in the scripts as provided. - Note the crawler does not respect robots.txt or perform rate limiting. If you plan to crawl third-party sites, ensure you have permission and run it responsibly (or modify the script to check robots.txt and throttle requests). - Because the SKILL.md is vague about how keyword and competitor analysis are generated, confirm whether the agent will use your account/model (and any associated billing) or call an external API. If the agent will call an external service, restrict or inspect outbound network access and do not provide secrets until you verify the service. - If you will run this skill in a shared environment, consider executing it inside a sandbox/container and inspecting network traffic to confirm no unexpected endpoints are contacted. - If you need the full promised feature (multi-country AI-driven competitor analysis), request that the skill author either include the integration code (with secure credential handling) or update the documentation to explain how the AI analysis step is performed.

Quick Start

1. User inputs target website URL + target country/language + publish frequency
2. Use scripts/crawl_website.py to crawl website content
3. AI analysis (considering target language and country)
4. Confirm/adjust competitor list
5. Use scripts/generate_excel.py to generate content plan Excel
6. Output complete report (in target language)

Dependencies

Required packages:

pip install requests beautifulsoup4 openpyxl

Workflow

Step 1: Collect User Requirements

Must ask user for:

1. Target Website URL - Website to analyze
2. Target Country - Country for content targeting (e.g., USA, UK, Germany, China)
3. Target Language - Content language (e.g., English, Chinese, German, French)
4. Publish Frequency - Weekly / Bi-weekly / Monthly

Step 2: Crawl Target Website

python3 scripts/crawl_website.py <URL>

Step 3: AI Analysis (Multi-language)

Use Opencode AI for analysis:

• Identify industry and competitors based on target country
• Output keywords in target language
• Include target country market in competitor analysis

Step 4: Generate Content Plan

Based on publish frequency:

• Weekly: 12 weeks (3 months) × 1 topic
• Bi-weekly: 6 topics (one every two weeks)
• Monthly: 3 topics (one per month)

All content titles, topics, and ideas in target language.

Step 5: Output Report

1. Markdown format in conversation (target language)
2. Excel file

Scripts

scripts/crawl_website.py

Crawls main website content, outputs structured JSON.

scripts/generate_excel.py

Generates Excel file from analysis results.

Input: analysis_result.json Output: content_plan.xlsx

Output Format

Example User Input

Parameter	Value
URL	https://example.com
Country	Germany
Language	German
Frequency	Weekly

Content Plan Output (German Example)

Month	Week	Theme	Title	Type
Month 1	Week 1	Market Launch	...	Article