API Schema Extractor

n8n template #2658

Summary

This workflow automates the process of discovering and extracting APIs from various services, followed by generating custom schemas. It works in three distinct stages: research, extraction, and schema generation, with each stage tracking progress in a Google Sheet. 🙏 Jim Le deserves major kudos for helping to build this sophisticated three-stage workflow that cleverly automates API documentation processing using a smart combination of web scraping, vector search, and LLM technologies. How it works Stage 1 - Research: Fetches pending services from a Google Sheet Uses Google search to find API documentation Employs Apify for web scraping to filter relevant pages Stores webpage contents and me

How to set it up

Open template #2658 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
Create 5 credentials under Credentials → Add credential: Google Sheets, Google Drive, Qdrant Vector Store, Embeddings Google Gemini, Google Gemini Chat Model. Then open each of those nodes and pick the credential.
Check the model in the Google Gemini Chat Model node. The template may point at a model your account can't use; swap it for one you have access to.
Click Execute workflow and step through each node's output to confirm the data looks right.
Toggle the workflow to Active so its trigger runs on its own.

Hand off to your agent

Prompt

Help me set up the n8n workflow "API Schema Extractor" (https://n8n.io/workflows/2658). It uses: Google Sheets, HTTP Request, Google Drive, Code, Recursive Character Text Splitter, Default Data Loader, Qdrant Vector Store, Embeddings Google Gemini, Google Gemini Chat Model, Text Classifier, Information Extractor. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.

Paste into Claude Code and it will do the rest.

Apps and nodes

Google Sheets HTTP Request Google Drive Code Recursive Character Text Splitter Default Data Loader Qdrant Vector Store Embeddings Google Gemini Google Gemini Chat Model Text Classifier Information Extractor

Questions

Yes. Polina Medvedieva published it free on n8n.io as a verified creator, and it has 24K views. It runs on n8n Cloud or a self-hosted n8n instance.

Google Sheets, Google Drive, Qdrant Vector Store, Embeddings Google Gemini, Google Gemini Chat Model. The other 6 nodes are built into n8n.

Similar workflows

NameViews