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 publicrepo 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 YOURGOOGLESHEETSDOCUMENTID with your actual document ID - Replace YOURWEBHOOKID 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