How the Workflow Functions:

Stage 1: Research

• Automatically fetches pending services from Google Sheets
• Performs Google searches to locate relevant API documentation
• Uses Apify for targeted web scraping to collect documentation content
• Stores content in vectorized database for efficient retrieval
• Updates progress tracking in Google Sheets

Stage 2: Extraction

• Processes services with successful research completion
• Queries vector database to identify products and API details
• Uses Gemini AI to extract specific API operations
• Records structured data for each operation

Stage 3: Generation

• Combines extracted operations into standardized schemas
• Groups related APIs logically
• Uploads completed schemas to Google Drive
• Updates tracking sheet with file locations and completion status