foreign-literature-search

Search OpenAlex for social-science papers and generate Excel outputs with boolean query strings.

Updated Apr 17, 2026
One-click install
npx skills add https://github.com/RenJW418/RenJW-Research_skill --skill foreign-literature-search
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: foreign-literature-search
Source: https://github.com/RenJW418/RenJW-Research_skill/tree/main/foreign-literature-search
Command: npx skills add https://github.com/RenJW418/RenJW-Research_skill --skill foreign-literature-search

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, and includes scripts (resource) components.

What problem does it solve?

It helps you quickly find relevant foreign/English academic literature for social-science research without needing an institutional account or an API key, then organizes the results for downstream review.

Core Features & Use Cases

  • Multi-stage literature search (AND logic with keyword groups): Builds a primary “most specific group” query, then applies post-filtering so papers match all concept groups (with an automatic relaxed fallback when results are too few).
  • Independent supplemental searches: Runs separate searches for research-object background and core theory terms to expand coverage.
  • Structured Excel outputs + WoS/Scopus boolean drafts: Produces category-colored Excel files with article metadata and generates Web of Science (SSCI) / Scopus-ready boolean query templates for users with access.

Quick Start

Run foreign-literature-search with keyword groups reflecting your topic’s main concepts, so it returns a deduplicated, categorized Excel of English/foreign papers using OpenAlex.

Frequently Asked Questions about foreign-literature-search

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I search for English social-science literature without an API key?▼

You can search English social-science literature without an API key by using OpenAlex API queries. This approach runs multi-group AND keyword searches and post-filters results on titles and abstracts, returning deduplicated academic papers without requiring institutional access.

Can I generate WoS boolean search strings from OpenAlex query results?▼

Yes, you can generate WoS boolean search strings from OpenAlex query results. The process produces Web of Science (SSCI) and Scopus-ready boolean query templates alongside categorized Excel files, enabling follow-up searches in institutional databases.

How to export OpenAlex literature search results with journal ranking metadata to Excel?▼

To export OpenAlex literature search results with journal ranking metadata to Excel, run multi-stage AND keyword searches with optional year range and quartile filtering. The output produces category-colored Excel files containing article metadata and journal quartile information.

Does OpenAlex support multi-stage keyword searches for primary and supplemental literature sets?▼

OpenAlex supports multi-stage keyword searches for primary and supplemental literature sets. It builds a primary specific group query, applies post-filtering, and runs independent searches for research-object background and core theory terms to expand coverage.

What happens if my OpenAlex keyword search returns too few results?▼

If your OpenAlex keyword search returns too few results, the system applies an automatic relaxed fallback. This mechanism loosens the strict AND logic post-filtering on titles and abstracts to ensure you retrieve a sufficient number of relevant papers.

How do I find foreign academic papers for end-to-end literature searching workflows?▼

To find foreign academic papers for end-to-end literature searching workflows, apply OpenAlex-based discovery with multi-group AND keyword groups. This provides primary results plus supplemental background and theory sets, outputting categorized Excel files with journal metadata.