Data & Analytics Workflows
Data processing and analytics
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
n8n$14.99Filter and Export Rebrandly Links to Google Sheets
Automatically filter Rebrandly links based on specified criteria and export them as new rows in Google Sheets for streamlined data management.
MakeFreeSync New Adalo Records to Airtable Automatically
Automatically transfer new records from Adalo to a specified table in Airtable, ensuring your data is always up-to-date.
MakeFreeAutomate Multi-CRM Data Sync to Google Sheets with AI Deduplication
This workflow synchronizes contact data from HubSpot, Pipedrive, and Salesforce into Google Sheets, using AI to deduplicate and assess data quality. It runs on a schedule or can be manually triggered, ensuring a clean and up-to-date master database.
n8n$14.99Google Cloud Natural Language MCP Server for AI Agents
MCP server exposing Google Cloud Natural Language sentiment analysis to AI agents with zero configuration. Import, activate, and connect via webhook URL for instant text analytics integration.
n8n$12.99Integrate Typeform Data into Pinecone for Enhanced Search and Organization
Automatically upsert vectors into a Pinecone namespace using new data from Typeform, enhancing your database's search capabilities and organization.
MakeFreeSend country-based user & session report from Google Analytics to Google Sheets
Gain deeper insights into your websites traffic with our automated report that sends country-specific user and session data to Google Sheets every Friday. Easily adjust the scheduling to align with your analytical needs. The scenario is scheduled to execute every Friday at 17:00 which you can change in the schedule setting by clicking the clock icon on the first module.
Make$2.99Automate Tadabase Record Export to Google Sheets
This workflow automates the export of Tadabase records to a Google Sheets spreadsheet, allowing for regular data synchronization at specified intervals.
Make$2.99Sync ActiveCampaign analytics to Google Sheets
Automatically sync your ActiveCampaign analytics to Google Sheets to enhance your marketing campaigns. This template transfers key performance metrics every Friday, allowing you to access fresh insights at the start of each week. Optimize your strategies with up-to-date data, reduce manual tasks, and improve decision-making efficiency. Ideal for teams looking for a streamlined approach to campaign tracking and analysis. The scenario runs every Friday (feel free to change the schedule if needed). You can change this in the scheduling settings by clicking the clock icon.
Make$2.99Automate Data Transfer to PostgreSQL and Email Alerts via Sendinblue
Effortlessly transfer data to PostgreSQL and send email notifications using Sendinblue. Enhance data management and streamline communication with this integration.
Make$3.99Automate Document Analysis and Organization Extraction with Foxit and Diffbot
This workflow automates the extraction of text from documents using Foxit and identifies organizations mentioned using Diffbot, providing a summary and sending results via email.
n8n$14.99Send data to Google BigQuery from a custom webhook
Streamline your data management process by automatically sending data from a custom webhook to Google BigQuery. This template allows you to capture incoming data through a Gateway Custom WebHook and seamlessly write it to your Google BigQuery database, ensuring that your data is organized and easily accessible for analysis. Perfect for businesses looking to enhance their data analytics capabilities without manual intervention.
Make$2.99Automated Daily Backup of Google Sheets to Google Drive
This workflow automates the daily backup of a Google Sheet by exporting its data and saving it as a CSV or XLSX file in a specified Google Drive folder. It ensures data redundancy and maintains historical versions for critical business data.
n8n$4.99Daily Mailchimp Subscriber Reports to Slack
Automates daily Slack notifications with Mailchimp subscriber counts, keeping marketing teams informed without manual checks.
n8n$6.99Add Google Sheets rows for new Amazon SES contacts
Make will watch your Amazon SES contacts and add them to your Google Sheets as rows. Heres the [spreadsheet](https://docs.google.com/spreadsheets/d/1FeaALMYAUmUlQssrMVCIyvojkX5V9tpNXgo9rS_9egA/edit?usp=sharing) used in this scenario.
Make$2.99Automate WooCommerce Data Transfer to External Applications
Efficiently automate the transfer of WooCommerce event data to external applications using HTTP requests, enhancing data integration and workflow efficiency.
Make$2.99Automate Financial Tracking from Gmail to Google Sheets
This workflow automates the extraction of transaction details from Gmail emails and organizes them into a Google Sheet for streamlined financial tracking.
n8n$14.99Sync Microsoft SQL Server Data to Google Sheets
Automatically transfer selected rows from a Microsoft SQL Server database table to a Google Sheets spreadsheet, ensuring your data is always up-to-date and accessible.
Make$2.99Weekly Data Transfer from MySQL to Google Sheets
This workflow automates the weekly transfer of data from a MySQL table to Google Sheets, ensuring your spreadsheet is always up-to-date.
n8n$3.99Count users per G Suite organizational unit
This template shows how you can set Make to list all your G Suite organizational units and count their number of users. Then, the result is saved in Google Sheets. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1H7S6BPYc5DH3Kx841t2SFJsaLqlgj9MclYoS0szwDc/edit#gid=0).
Make$3.99Convert Shopify Events to JSON and Transmit via HTTP
Automatically transform Shopify event data into JSON format and send it via HTTP, improving data integration and workflow efficiency.
Make$3.99Create a Firestore document from a custom webhook trigger
Trigger a custom webhook to automatically create a new document in Google Cloud Firestore, streamlining data integration and storage for your applications.
Make$2.99Verify a phone number from a Google Sheets row using Veriphone
Every time a phone number is added to a Google Sheets spreadsheet as a new row, Make will automatically verify it in Veriphone and update the row with data of your choice. The template uses [this spreadsheet](https://docs.google.com/spreadsheets/d/18QXxDXbnheSLVJANN_QjamN8E4gfuHO5VDWxg6OHMY/edit?usp=sharing).
Make$3.99Automate Daily TikTok Report Sync to Google Sheets
Streamline your marketing analytics by automatically importing TikTok advertising data into Google Sheets every morning. This integration ensures your reports are updated with the latest insights, enhancing decision-making and data management.
Make$2.99
Related categories
Custom AI Systems & Services
Our team of experienced AI builders will help build custom AI systems, workflows, and solutions.
Request Custom Work