# Extract REST APIs from docs using AI and save to Google Sheets and Drive
This workflow automates the discovery and structuring of REST APIs from public documentation. Ideal for teams needing fast access to API specifications without manual site analysis — using AI, vector search, and automatic export to Google Sheets and Drive.
## Who it´s for
- Developers automating the collection of third-party API specs.
- Integrators who need quick access to endpoints for integration.
- Technical writers gathering information for internal documentation.
- SaaS companies building integrations based on external APIs.
- Analysts evaluating competitors’ API ecosystems.
## What the automation does
- Triggers when a new service is added to Google Sheets or manually launched.
- Uses Apify and Serping to scan web pages and locate API documentation.
- Analyzes content with Google Gemini and Qdrant vector store.
- Extracts REST methods, parameters, and request structures via LangChain.
- Generates a unified JSON schema and saves it to Google Drive.
- Updates processing status in Google Sheets (e.g., ´found´, ´no api docs´).
- Reuses previously stored fragments via vector search to improve accuracy.
## What´s included
- Ready-to-use n8n workflow.
- Trigger logic based on Google Sheets updates or manual execution.
- Integrations with Google Sheets, Google Drive, Apify Web Scraper, Serping Google Search, and REST APIs.
- Basic textual guide for setup and adaptation.
## Requirements for setup
- n8n instance with LangChain support and custom node capabilities.
- API keys: Google Gemini, Qdrant, Apify, Serping.
- Google Workspace account with enabled Google Sheets and Google Drive APIs.
- Basic understanding of vector databases and LLM workflows.
## Benefits and outcomes
- Saves time on manual documentation parsing.
- Unified storage format for API specs (JSON + spreadsheets).
- Scalable to hundreds of services.
- Real-time status updates in Google Sheets.
- Reduced errors in API interpretation.
- Supports analysis of partially documented APIs.
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet