菜单
SEO blog research workstation. Automates pre-writing source collection - AI visibility audits, competitor article analysis, user question mining, expert quote gathering, social media trend scanning, and data/statistics harvesting. Outputs structured Blog Writing Resources to Google Sheets.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
| name | seo-geo-sources |
| description | SEO blog research workstation. Automates pre-writing source collection - AI visibility audits, competitor article analysis, user question mining, expert quote gathering, social media trend scanning, and data/statistics harvesting. Outputs structured Blog Writing Resources to Google Sheets. |
The research phase of blog production. Before writing any SEO/GEO article, this skill systematically collects all the raw materials: competitive intelligence, user questions, expert quotes, hard data, social proof, and trend signals. Outputs everything to a structured Google Sheets template ready for the writing phase.
| Platform | Usage |
|---|---|
| Google Search | SERP analysis, competitor articles, PAA questions |
| ChatGPT (Browser) | AI visibility check - what does ChatGPT cite? |
| Perplexity (Browser) | AI visibility check - what does Perplexity cite? |
| AnswerSocrates | User question mining |
| Twitter/X (Browser) | Viral content, expert opinions, trend signals |
| Reddit (Browser) | User pain points, authentic discussions |
| YouTube (Browser) | Video content trends, title format research |
| LinkedIn (Browser) | Expert quotes, industry insights |
| Google Sheets | Output: Blog Writing Resources template |
| Google Docs (optional) | Full research brief export |
Spreadsheet ID: 1imXTbVhmDlg23ao9695Py1RZYnWxH3qyAiquSxvflxo
Check if the topic/brand is cited by AI engines:
// 1a. ChatGPT
var page = await browser.newtab("https://chatgpt.com")
await page.wait({ waitTime: 3 })
// Ask: "What are the best [keyword] tools/solutions in 2026?"
// Record: which products/brands are cited, verbatim
// 1b. Perplexity
await page.goto({ url: "https://perplexity.ai" })
// Ask same query, record citations with source URLs
// 1c. Google AI Overview
// Search keyword on Google, check AI Overview panel
// Record what's featured
Output fields:
Collect real questions people ask about this topic:
// 2a. AnswerSocrates
await page.goto({ url: "https://answersocrates.com/" })
// Enter keyword, collect question clusters
// Target: 15-20 questions organized by type (what, how, why, which, can)
// 2b. Google PAA (People Also Ask)
// From SERP, expand PAA boxes
// Collect 8-10 additional questions
// 2c. Reddit search
await page.goto({ url: "https://www.reddit.com/search/?q=" + encodeURIComponent(keyword) + "&sort=relevance&t=year" })
// Find top 5 discussion threads
// Extract actual user questions and pain points from comments
Output fields:
Deep-dive top SERP results:
// Search Google for the keyword
// Open top 5 organic results
for (var i = 0; i < 5; i++) {
// For each competitor article, extract:
var analysis = {
url: "...",
title: "...",
wordCount: 0, // estimate from page length
h2Headings: [], // all section headings
toolsCovered: [], // which products they review
hasComparisonTable: false,
hasFAQ: false,
hasMethodology: false,
uniqueAngles: [], // what makes this article different
weaknesses: [] // what's missing that we can cover
}
}
Output fields:
Find hard numbers to cite in the article:
// Search for industry reports and statistics
var dataQueries = [
keyword + " statistics 2025 2026",
keyword + " market size report",
keyword + " survey results",
keyword + " benchmark data"
]
// For each query, find 3-5 citable data points
// Record: the statistic, the source, the year, the URL
Output fields:
Find quotable opinions from industry experts:
// 5a. Twitter/X search for expert opinions
await page.goto({ url: "https://x.com/search?q=" + encodeURIComponent(keyword) + "&f=top" })
// Find tweets from verified/high-follower accounts
// Record: name, credentials, quote, engagement metrics
// 5b. LinkedIn search for thought leaders
await page.goto({ url: "https://www.linkedin.com/search/results/content/?keywords=" + encodeURIComponent(keyword) })
// Find posts from industry leaders
// Record: name, title, company, key insight
Output fields:
Identify viral content and trending angles:
// 6a. Twitter/X - viral posts (past 3 months)
// Search keyword + variations, sort by engagement
// Record: hook formula, engagement metrics, content angle
// 6b. YouTube - top videos
await page.goto({ url: "https://www.youtube.com/results?search_query=" + encodeURIComponent(keyword) + "&sp=CAMSAhAB" })
// Sort by view count, analyze top 5 video titles
// Record: title format, view count, publish date
// 6c. Reddit - trending discussions
// Find most upvoted threads in past 3 months
// Record: topic angle, sentiment, common complaints
Output fields:
Row for each keyword researched:
Column A: Target Audience / Segment
Column B: Primary Keywords
Column C: AI Visibility Report
Column D: User Questions (AnswerSocrates + PAA + Reddit)
Column E: SERP Intent Classification
Column F: Top Competitor Articles (URLs + analysis)
Column G: Statistics & Data Points
Column H: Expert Quotes
Column I: Social Media Trends
Column J: Recommended Blog Title
Column K: Recommended H2 Structure
Column L: Content Gaps (our unique angle)
For complex articles, export a full research brief document:
var brief = await google.docs.createDocument({
title: "Research Brief: " + keyword + " - " + new Date().toISOString().slice(0,10)
})
// Insert all 6 modules' findings in a structured document
Before marking research complete:
Threads brand account strategy system: multi-account competitive analysis, algorithm diagnostics, cold-start planning, content calendar, and professional HTML reports with 6 design templates. Built for brand/product accounts going from 0 to scale.
Boost LinkedIn visibility by engaging with posts from target people (hiring managers, recruiters, industry leaders). Leaves thoughtful, non-generic comments to build recognition before outreach.
Reverse-engineer top LinkedIn profiles in any field, then rewrite the user's profile to match. For job seekers (recruiter search optimization) and early founders (credibility building). Use when the user wants to improve their LinkedIn profile, optimize for recruiters, benchmark against top voices, or build a founder profile.
Build targeted B2B prospect lists from LinkedIn - search by ICP criteria (role, company size, industry, location), enrich profiles, cross-reference with account lists in Google Sheets. Export structured prospect lists.
Scan receipts, invoices, and bills from photos or PDFs. AI extracts merchant, date, amount, tax, payment method, and category. Auto-logs to Google Sheets expense tracker with monthly summaries and budget analysis.
AI travel planner that searches flights, hotels, and attractions across multiple platforms (Google Flights, Kayak, Booking.com, Airbnb, TripAdvisor), generates day-by-day itineraries, syncs to Google Calendar, and tracks budgets in Google Sheets.