Data extraction from Google Sheets to Google Drive

• Automate the extraction of API documentation from web searches
• Store and organize API operations in Google Drive for easy access
• Streamline the process of updating API documentation in Google Sheets

Initiates with a manual trigger to start the workflow Fetches a list of services pending research from Google Sheets Performs web searches to find relevant API documentation Scrapes webpage contents and stores them in a vector store Extracts API operations using AI models and stores results in Google Sheets Uploads the final API schema to Google Drive

1. 1
   Import the workflow template into your n8n instance
2. 2
   Connect your Google Sheets and Google Drive accounts
3. 3
   Configure the Google Sheets node to point to your API documentation sheet
4. 4
   Set up the Google Drive node with the desired folder for output
5. 5
   Run the workflow to begin the extraction process