Api schema extractor

by Polina Medvedieva ✓ · 29,665 views · created 2024-12-19 · Engineering, AI RAG

What this workflow does

This AI workflow has 82 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Gemini Chat Model, Embeddings Google Gemini, Qdrant Vector Store and Google Sheets and 1 more. It also calls api.apify.com over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).

1. Get All Research (Google Sheets): uses Google Sheets
2. Execution Data: uses Execution Data
3. All Research Done? (If): checks a condition and branches into true / false
4. EventRouter (Switch): routes items into 3 branches
5. Get All Extract (Google Sheets): uses Google Sheets
6. For Each Research... (Loop Over Items (Split in Batches)): loops over the items in batches
7. Web Search For API Schema (HTTP Request): calls api.apify.com (POST)
8. Query Templates (Edit Fields (Set)): sets 1 field: queries
9. Get API Operations (Google Sheets): uses Google Sheets
10. All Extract Done? (If): checks a condition and branches into true / false

…plus 62 more steps. See the full node list below.

Services it uses

Google Gemini Chat ModelEmbeddings Google GeminiQdrant Vector StoreGoogle SheetsGoogle Drive

HTTP calls to: api.apify.com

Before you upgrade to n8n 3.0

Nodes used (24)

• Manual Triggern8n-nodes-base.manualTrigger
• HTTP Requestn8n-nodes-base.httpRequest
• Split Outn8n-nodes-base.splitOut
• Recursive Character Text Splitter@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter
• Edit Fields (Set)n8n-nodes-base.set
• Default Data Loader@n8n/n8n-nodes-langchain.documentDefaultDataLoader
• Execute Workflow Triggern8n-nodes-base.executeWorkflowTrigger
• Execution Datan8n-nodes-base.executionData
• Switchn8n-nodes-base.switch
• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• Filtern8n-nodes-base.filter
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Embeddings Google Gemini@n8n/n8n-nodes-langchain.embeddingsGoogleGemini
• Text Classifier@n8n/n8n-nodes-langchain.textClassifier
• Qdrant Vector Store@n8n/n8n-nodes-langchain.vectorStoreQdrant
• Information Extractor@n8n/n8n-nodes-langchain.informationExtractor
• Waitn8n-nodes-base.wait
• Remove Duplicatesn8n-nodes-base.removeDuplicates
• Execute Sub-workflown8n-nodes-base.executeWorkflow
• Ifn8n-nodes-base.if
• Aggregaten8n-nodes-base.aggregate
• Coden8n-nodes-base.code
• Google Sheetsn8n-nodes-base.googleSheets
• Google Driven8n-nodes-base.googleDrive

From the author

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…

View the original on n8n.io → Check your own copy