AutomationMart
Home/Browse/Api schema extractor
n8n

Api schema extractor

n8nn8n82 modulesv1.0
Google SheetsGoogle DriveGemini

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 wor

At a glance

Api schema extractor is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, Google Drive, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, Google Drive, Gemini
Modules
82
Price
Free
Version
v1.0
Api schema extractor workflow diagram

About this workflow

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 metadata in Qdrant (vector database) - Updates progress status in Google Sheet (pending, ok, or error) Stage 2 - Extraction: - Processes services that completed research successfully - Queries vector store to identify products and offerings - Further queries for relevant API documentation - Uses Gemini (LLM) to extract API operations - Records extracted operations in Google Sheet - Updates progress status (pending, ok, or error) Stage 3 - Generation: - Takes services with successful extraction - Retrieves all API operations from the database - Combines and groups operations into a custom schema - Uploads final schema to Google Drive - Updates final status in sheet with file location Ideal for: - Development teams needing to catalog multiple APIs - API documentation initiatives - Creating standardized API schema collections - Automating API discovery and documentation Accounts required: - Google account (for Sheets and Drive access) - Apify account (for web scraping) - Qdrant database - Gemini API access Set up instructions: - Prepare your Google Sheets document with the services information. Here's an example of a Google Sheet – you can copy it and change or remove the values under the columns. Also, make sure to update Google Sheets nodes with the correct Google Sheet ID. - Configure Google Sheets OAuth2 credentials, required third-party services (Apify, Qdrant) and Gemini. - Ensure proper permissions for Google Drive access.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Create new rows in a Google Sheets spreadsheet from new survey responses in dotdigital

This template periodically checks for new survey responses in dotdigital and adds the responses to a target Google Sheets spreadsheet. The template is using [this sample](https://docs.google.com/spreadsheets/d/1tfDYuYyd9DkTOkBQgJNKc53VPVvF9KKEhNcx91Cty7k/edit?usp=sharing) Google Sheets spreadsheet as a destination for the dotdigital responses. You should make a copy of it before configuring the template. The template assumes that your dotdigital survey collects these responses in this order:

Free

BrowserAct YouTube Publishing Strategy Generator

This end-to-end automation extracts YouTube channel video data, analyzes historical performance, and identifies the optimal publishing time to maximize viral potential. Using BrowserAct, the workflow dynamically scrapes all videos from a selected channel and stores Title, URL, Views, Likes, and Published Date into Google Sheets. The data is then aggregated and sent to Gemini AI with a structured analytical prompt that examines performance by day of week, hour of day, and minute. The AI model d

Free

Add new email addresses from a Google Sheets spreadsheet to your whitelist in Mandrill

Every time a new email address is added to a Google Sheets spreadsheet, Make will automatically add it to your Mandrill whitelist. The template uses this [example spreadsheet](https://goo.gl/loCg1W).

Free

Create new contacts in Fireberry from new rows in a Google Sheets spreadsheet

This template regularly checks for new rows in Google Sheets spreadsheet and uses the retrieved information to create new contacts in Fireberry.

Free

AI client onboarding agent: auto welcome email generator

AI Client Onboarding Agent: Auto Welcome Email Generator Subtitle: From Form Response to Personalized Welcome Email --- 🌍 Overview This workflow automates the client onboarding process. When a new client fills in the Google Form, their data flows into Google Sheets → gets structured → an AI model (Gemini) generates a personalized onboarding email → and finally, Gmail sends it directly to the client. Think of it as your automated client success assistant. --- 🟢 Section 1: Trigger – Capture New Cl

Free

Validate e-mail addresses and phone numbers by IPQualityScore and create new customers in Shopify for new Google Sheets

Every time a new row is added to a Google Sheet, Make will automatically validate the email address and phone nubmer by IPQualityScore and create new customer in Shopify. The example uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1fv2rIpK2JastD7Npy6mrFepUwXHf9HlhcMvnybbP8kY/edit?usp=sharing).

Free

Generate custom AI images with OpenAI GPT-Image-1 model

How it works 1. Trigger the workflow manually via the n8n UI. 2. Define key parameters like the image prompt, number of images, size, quality, and model. 3. Send a POST request to OpenAI’s image generation API using those inputs. 4. Split the API response to handle multiple images. 5. Convert the base64 image data into downloadable binary files. Set up steps Initial setup takes around 5–10 minutes. You’ll need an OpenAI API key, a configured HTTP Request node with credential

Free

Automated YouTube channel lead generation & email outreach with Apify and ZeroBounce

Workflow Overview This sophisticated n8n automation is a powerful lead generation and outreach tool designed to transform YouTube channel research into actionable marketing opportunities. By intelligently connecting multiple services and APIs, this workflow: 1. Discovers Targeted Channels: - Scrapes YouTube channels based on specific keywords - Extracts comprehensive channel metadata - Identifies potential business opportunities 2. Intelligent Lead Qualification: - Filters channels with con

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free