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

For n8n, this automated workflow efficiently retrieves and organizes workflow data, filtering for specific model IDs. It clears existing data in Google Sheets and appends updated information, ensuring accurate tracking of AI model usage across workflows. This process enhances data management and visibility, streamlining operations for better decision-making.

7/8/2025
12 nodes
Medium
manualmediumsplitinbatchesgooglesheetsn8nfiltersplitoutsticky noteadvanced
Categories:
Manual TriggeredData Processing & AnalysisMedium Workflow
Integrations:
SplitInBatchesGoogleSheetsN8nFilterSplitOutSticky Note

Target Audience

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

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

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.

Customization Guide

Customization Guide


- Adjust Google Sheets Document ID: Update the documentId parameter in the Google Sheets nodes to point to your specific spreadsheet.
- Modify Sheet Name: Change the sheetName parameter if you want to save data to a different sheet within the same document.
- Edit Data Fields: Customize the fields being saved in Google Sheets by modifying the columns mapping in the Google Sheets-Save node and workflow data node.
- Add More Filters: Enhance the filtering conditions in the Filter-get workflow contain modelid and Filter-node contain modelId nodes to suit your specific requirements.
- Change Trigger Type: If you want to automate the workflow, consider replacing the manual trigger with a scheduled trigger or webhook, depending on your needs.