Need a clear view of where AI models are used in your automations? This build scans every n8n workflow, finds nodes that reference a modelId, and records the details in a Google Sheet. It helps teams plan model upgrades, reduce risk, and keep documentation current.

When you click Test workflow, it calls the n8n API to pull all workflows. The Google Sheet is cleared first to give a fresh snapshot. Workflows are filtered to keep only those that mention a modelId. Items are processed in batches. The nodes array is split so each node can be checked. If a node contains a modelId, key fields like node name, model value, workflow name, and workflow id are set. Each match is then appended as a row to Google Sheets. A note warns that very large instances may run slower, so the batch loop helps manage load.

You will need an n8n API connection and Google Sheets OAuth. Set your n8n base URL and point the sheet to the right document and tab. Expect a clean inventory table after each run that you can share with your team. It is useful for audits, cleanup before model changes, and tracking usage by project or owner.

• Manual trigger creates an on demand snapshot of model usage
• n8n API call fetches all workflows from your instance
• Google Sheets Clear wipes the target tab for a fresh report
• Workflow level filter keeps only items that mention modelId
• Split Out nodes turns the nodes array into single items for scanning
• Node level filter checks each node for a modelId field
• Set node maps fields like node name, model, workflow id, and name
• Google Sheets Append writes each match as a new row

• Reduce manual audit from 2 hours to 5 minutes
• Improve data quality by 90 percent by removing copy paste
• Connect n8n and Google Sheets to create a single source of truth
• Handle 100 plus workflows with batch processing for stable runs
• Eliminate duplicate records by clearing the sheet before each run

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets and n8n. See the Tools Required section above for links to create accounts with these services.
3. Open the n8n node that fetches workflows. In the Credential to connect with dropdown, click Create new credential and follow the on screen steps. Set the base URL to your n8n domain and provide the required token or login. Give the credential a clear name.
4. Double click the Google Sheets Clear node. In the credential dropdown, choose or create a Google Sheets OAuth2 credential. Follow the on screen steps to sign in and allow access.
5. In the same Clear node, select the correct Spreadsheet and the target Sheet or tab where you want the report stored.
6. Open the Google Sheets Append node. Use the same Google Sheets credential and select the same Spreadsheet and Sheet. Confirm the column mapping matches the fields from the Set node.
7. Open the Set node named Edit Fields set_model_data. Review the expressions for node_name and model. If your nodes store model values in a different path, adjust the expressions.
8. Check the Split In Batches node. Set a batch size that fits your instance size. Larger instances may need smaller batches for steady performance.
9. Click Test workflow. Watch the execution. The sheet should clear first, then rows should appear for each node that contains a modelId.
10. Verify results. The number of rows should match the count of nodes that use a modelId across your workflows. Spot check a few workflows to confirm accuracy.
11. If you see auth errors, refresh the Google Sheets OAuth credential and verify your n8n API token or login has permission to list workflows.
12. Optional scheduling. If you want a daily report, add a Cron node to trigger the same flow on a schedule and connect it to the start of the chain.