Track GitHub Node Definitions and Export to Google Sheets

# Track n8n Node Definitions from GitHub and Export to Google Sheets ## Overview This workflow automatically retrieves and processes metadata from the official n8n GitHub repository, filters all available `.node.json` files, parses their structure, and appends structured information into a Google Sheet. Perfect for developers, community managers, and technical writers who need to maintain up-to-date information about n8n's evolving node ecosystem. ## Setup Instructions ### Prerequisites Before setting up this workflow, ensure you have: - A GitHub account with API access - A Google account with Google Sheets access - An active n8n instance (cloud or self-hosted) ### Step 1: GitHub API Configuration 1. Navigate to GitHub Settings → Developer Settings → Personal Access Tokens 2. Generate a new token with `public_repo` permissions 3. Copy the generated token and store it securely 4. In n8n, create a new GitHub API credential 5. Paste your token in the credential configuration and save ### Step 2: Google Sheets Setup 1. Create a new Google Sheets document 2. Set up the following column headers in the first row: - `node` (Column A) - Node identifier/name - `nodeVersion` (Column B) - Version of the node - `codexVersion` (Column C) - Codex version number - `categories` (Column D) - Node categories - `credentialDocumentation` (Column E) - Credential documentation URL - `primaryDocumentation` (Column F) - Primary documentation URL 3. Note down the Google Sheets document ID from the URL 4. Configure Google Sheets OAuth2 credentials in n8n ### Step 3: Workflow Configuration 1. Import the workflow into your n8n instance 2. Update the following placeholder values: - Replace `YOUR_GOOGLE_SHEETS_DOCUMENT_ID` with your actual document ID - Replace `YOUR_WEBHOOK_ID` if using webhook functionality 3. Configure the GitHub API credentials in the HTTP Request nodes 4. Set up Google Sheets credentials in the Google Sheets nodes 5. Share your Google Sheets document with the email address associated with your Google OAuth2 credentials 6. Grant Editor permissions to allow the workflow to write data ## Google Sheets Template Details The workflow creates a structured dataset with these columns: - **node**: Node identifier (e.g., `n8n-nodes-base.slack`) - **nodeVersion**: Version of the node (e.g., `1.0.0`) - **codexVersion**: Codex version number (e.g., `1.0.0`) - **categories**: Node categories (e.g., `Communication, Productivity`) - **credentialDocumentation**: URL to credential documentation - **primaryDocumentation**: URL to primary node documentation ## Customization Options ### Modifying Data Extraction You can customize the Format Data node to extract additional fields: - Add new assignments in the Set node - Modify the column mapping in the Google Sheets node - Update your spreadsheet headers accordingly ### Changing Update Frequency To run this workflow on a schedule: 1. Replace the Manual Trigger with a Cron node 2. Set your desired schedule (e.g., daily, weekly) 3. Configure appropriate timing to avoid API rate limits ### Adding Filters Customize the Filter Node Files code node to: - Filter specific node types - Include/exclude certain categories - Process only recently updated nodes ## Features - Fetches all node definitions from the `n8n-io/n8n` repository - Filters for `.node.json` files only - Downloads and parses metadata automatically - Extracts key fields like node names, versions, categories, and documentation URLs - Appends structured data to Google Sheets with batch processing - Includes error handling and retry mechanisms - Clears existing data before appending new information for fresh results ## Use Cases This workflow is ideal for: - Tracking changes in official n8n node definitions over time - Auditing node categories and documentation links for completeness - Building custom dashboards from node metadata - Community management and documentation maintenance - Integration planning and compatibility analysis