n8napi-check-workflow-which-model-is-using

Target Audience

• Data Analysts: Individuals who need to analyze workflow data and models used in n8n.
• Automation Engineers: Professionals looking to streamline their automation processes with n8n and Google Sheets integration.
• Project Managers: Managers who want to keep track of workflows and the models they utilize, ensuring optimal performance.
• Developers: Those interested in leveraging n8n for workflow automation and data management tasks.
• Business Analysts: Individuals who require insights on model usage across various workflows for decision-making.

Problem Solved

This workflow addresses the challenge of tracking and managing various AI models used in different n8n workflows. It automates the process of gathering data about workflows, filtering relevant information based on model IDs, and storing the results in Google Sheets. This ensures that users have a clear overview of which models are being utilized, preventing redundancy and enhancing efficiency.

Workflow Steps

1. Manual Trigger: The workflow begins with a manual trigger, allowing users to start the process on demand.
2. Retrieve All Workflows: It fetches all workflows from n8n to gather necessary data.
3. Filter Workflows: The workflow filters out those that contain specific model IDs, ensuring only relevant workflows are processed.
4. Loop Over Items: The filtered workflows are then processed in batches to manage large datasets effectively.
5. Check for Model ID: Each workflow is checked for the presence of a model ID, ensuring no workflows are missed.
6. Set Model Data: Relevant data is prepared and structured for storage, including the workflow name, ID, and URL.
7. Clear Google Sheets: The workflow clears previous data in the specified Google Sheet to ensure fresh data entry.
8. Save Data to Google Sheets: Finally, the structured data is appended to the designated Google Sheet for easy access and analysis.