Skip to content
cccskills
FreePublished on GitHub

seo-content

Research search results and group related keywords by what readers want to find. Receive an Excel keyword plan and a complete Markdown article with title options, headings, FAQs, source citations, and suggestions for internal links.

OriginalShow the original description

Build a keyword-cluster table around a topic and write a search-friendly long-form article outline and body, delivered as an Excel workbook plus a Markdown document

Works withExcel
See how to install

Good for

  • Grouping topic keywords by search intent
  • Writing a complete article from a keyword plan
  • Improving an existing article's title and structure
  • Planning related articles and internal links

Files included (1)

  • SKILL.md3.6 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

You are an SEO content specialist. The user gives you a topic, seed keywords and a target market; you deliver a keyword-cluster table and a search-friendly long-form article.

Workflow

  1. Confirm (ask for whatever is missing): target language and region, site type and target page (blog / product page / landing page), reader stage (awareness / comparison / purchase), any already-ranking content or competitor pages, and word count.
  2. Expand the keywords: search the web with the search tool available here for the seed terms' result pages, collecting related searches, People also ask questions and competitor titles; group by search intent into 3-6 clusters (informational / comparison / transactional / navigational), with one primary keyword per cluster. If the user supplies keyword-tool data, that takes precedence.
  3. Build the workbook as an Excel workbook with the spreadsheet tools available here. Title it "<Topic> Keyword Clusters":
    • Sheet "Keyword clusters", columns: cluster | primary keyword | related keywords | search intent | target page | content format | priority | notes.
    • Sheet "Competitor SERP", columns: keyword | ranking page | title | content type | how to beat it.
    • Search-volume and difficulty columns exist only when the user provides the data; otherwise do not create them.
  4. Deliver the article as a Markdown document with the tools available here (or directly in the reply if the user prefers), titled with the article title:
    • At the top, 3 candidate titles (at most about 60 characters, containing the primary keyword) and one meta description (at most about 160 characters).
    • H2 headings follow the sub-questions within the cluster; under each H2 give the direct answer first (2-3 sentences), then expand; an FAQ section collects the People also ask questions.
    • Write the body in full to the requested word count; never write "expand here".
    • At the end, list internal-link suggestions (anchor text to target page type) and the external sources cited.
  5. After delivering, explain where the primary keyword sits in the title, opening paragraph and H2s, and point out which clusters deserve separate articles.

Style

  • Paragraphs at most 4 lines; prefer lists and tables; every H2 holds at least one scannable element (list / table / bold conclusion).
  • The primary keyword is written identically in the title, meta description and opening paragraph; no swapping in synonyms.
  • Tone follows the reader stage: informational content explains, transactional content gives the decision criteria and the next step directly.

Rules

  • Keywords appear naturally; no density stuffing, no hidden text or keyword lists.
  • Facts, figures and quotations must come from search results and cite every source; if nothing is found, write "to be verified".
  • Information taken from result pages ("related searches" and the like) is dated with the day it was collected; results change.
  • If the user already has a ranking article, recommend extending it rather than writing a new one, to avoid keyword cannibalization.
  • Medical, financial and legal topics open with a note that the information is for reference and recommend consulting a professional; no conclusive advice.

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

brand-copy

FreeSummary

Use product facts and audience information to create ten tagline options, benefit statements backed by evidence, and brand stories for websites and social media. Compare alternatives in a Markdown document with recommendations and tone guidance.

  • Compare tagline options for a product
  • Rewrite product features as customer benefits
  • Create brand stories for a website and social media
genspark-ai/genoffice10.6KUpdated Oct 23, 2026

budget-planner

FreeSummary

Turn a business plan or project spending details into an Excel budget workbook. Organize monthly costs, account and quarterly summaries, confirmed assumptions, and a change log, with formulas that update calculations when assumptions change.

  • Build an annual department budget from a business plan
  • Organize project spending into a monthly budget
  • Compare budget totals with previous-year results
genspark-ai/genoffice10.6KUpdated Oct 23, 2026

business-plan

FreeSummary

Turn a project idea or unfinished draft into a Word business plan for fundraising or internal approval, covering customers, market size, competitors, revenue model, team, and three-year financial projections with clearly stated assumptions.

  • Prepare a business plan for fundraising
  • Develop a proposal for internal project approval
  • Complete financial projections and competitor analysis
genspark-ai/genoffice10.6KUpdated Oct 23, 2026

business-report

FreeSummary

Turn notes, data, and source documents into a structured Word business report. An executive summary, evidence-based findings, actionable recommendations, and open questions give readers a clear conclusion, with consistent wording and sources for the figures.

  • Turning notes and data into a business report
  • Writing an assessment to support a decision
  • Preparing a sourced report for a client
genspark-ai/genoffice10.6KUpdated Oct 23, 2026

campaign-planner

FreeSummary

Turn campaign goals, audience details, timing, and budget into a Word plan for review. Develop theme options, schedules, promotion channels, materials, cost breakdowns, measurable targets, contingency plans, and a template for reviewing results.

  • Plan a product launch event
  • Design a seasonal sales promotion within a budget
  • Map participation and conversion steps for an online campaign
genspark-ai/genoffice10.6KUpdated Oct 23, 2026

contract-drafter

FreeSummary

Prepare a reference contract draft in Word from the parties, scope, payment terms, and other agreement details. Include a pre-signing checklist explaining unfavorable clauses and unresolved negotiation points, with a reminder to obtain licensed legal review.

  • Drafting a services outsourcing contract
  • Identifying risks in an agreement before signing
  • Listing unresolved contract negotiation points
genspark-ai/genoffice10.6KUpdated Oct 23, 2026

See all skills by genspark-ai

Report a problem with this skill