Tired of Manual Reports? Watch Me Build the Solution (Automate Analytics with n8n)

Learn how to build a custom workflow automation tool. Automate YouTube transcript downloads and metadata processing using visual programming . This guide demonstrates how to configure a node-based environment to handle complex tasks without writing extensive boilerplate code. Whether you are a developer looking to streamline data collection or a creator building internal tools, this tutorial breaks down the essential steps to connect HTTP requests , schedule triggers, and custom JavaScript execution. By following this visual programming setup, you will create a reliable system to fetch channel IDs and pull transcripts automatically. We focus on the practical configuration of nodes to ensure your automation workflow runs efficiently. You will see how to chain these functions together to manage video metadata effectively, saving you hours of manual data entry. Subscribe for weekly workflow automation breakdowns, and comment below on which data processing task you want to automate next. I automated my weekly YouTube channel reporting with Claude Code and n8n — and I recorded the entire build, mistakes included. ▎ ▎ Manually pulling YouTube analytics is one of those tasks that quietly eats hours every week — log into YouTube Studio, export the numbers, format them, repeat next week. It's exactly the kind of repetitive work marketing teams and agencies waste real time on, and it's exactly what workflow automation tools like n8n exist to eliminate. ▎ ▎ This is "AI Built It, I Run It" — I don't just prompt an AI and hope. I build it live, on camera, and when it breaks (which it did, more than once), I fix it and explain why, so you actually understand what's running, not just what to copy-paste. ▎ ▎ The build: a 7-node n8n workflow that pulls the past week's YouTube video stats via the YouTube Data API, formats them into a clean markdown report, and saves it automatically — no manual work, no spreadsheet, fires on its own weekly schedule from here on out. ▎ ▎ Real bugs hit and fixed on camera: an unquoted environment variable that accidentally opened VS Code mid-recording, an API response structure that silently broke a downstream node, a missing return statement, and a target folder that didn't exist yet. Nobody's automation works on the first try — this is what the actual troubleshooting looks like, not a polished after-the-fact tutorial. ▎ ▎ If you're a marketer, agency operator, or IT professional building real automation skills with AI — not just watching AI hype — this is what that work actually looks like. Chapters 0:00 Setting Up the Initial Workflow 2:01 Connecting the HTTP Request Node 5:57 Troubleshooting the Data Array Issue 6:52 Implementing the JavaScript Code Node 11:53 Formatting Data into a Clean Report 16:47 Writing Binary Files to Disk 24:33 Final Workflow Testing and Activation #n8n #ClaudeCode #AIAutomation #MarketingTechnologist #BuildInPublic #WorkflowAutomation #NoCode #AIBuiltItIRunIt