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.