AZ
Back to Use Cases

Create workflow inventory dashboard with n8n API and Google Sheets

project-managementgovernanceopsgoogle-sheets•
n8n API
Google Sheets

Trigger run

n8n API

Get all workflows

Iterate workflows

Extract metadata

Google Sheets

Upsert row

Rate limit pause

Overview

This workflow creates operational visibility into an n8n instance by maintaining a spreadsheet inventory of workflows, tags, and nodes.

Product Specs

  • Runs on a schedule or manually
  • Calls the n8n API to fetch all workflows
  • Loops through each workflow and extracts key metadata
  • Writes or updates rows in Google Sheets keyed by workflow ID
  • Includes a wait step to avoid API rate limits

Pipeline Description

A trigger starts the workflow. It fetches all workflows via the n8n API, iterates through them, extracts ID/name/tags/node list, and upserts a row into Google Sheets for each workflow, forming a dashboard for audits and maintenance.