Collect YouTube Channel Intelligence into Google Sheets

## 🎯 YouTube Channel Intelligence Collector — Grouped Workflow Overview --- ### 🔹 SECTION 1: Channel Identification & Stats Fetching 🔔 It all begins when a new channel URL is added to Google Sheets. The New Channel Added trigger detects this input and passes it to the next node. 🔎 The Get Channel ID from URL node uses YouTube’s Data API to convert the given channel username or custom URL into a valid channelId. 📊 Once the channel ID is resolved, the Get Channel Stats node fetches vital metrics like subscriber count, total video count, and overall view count — giving you an immediate sense of the channel’s reach and authority. This section acts as the "identity and reputation layer" — establishing who the channel is and how large its audience might be. --- ### 🔹 SECTION 2: Recent Video Intelligence 🆕 The Get Recent Video IDs node fetches the 5 most recent uploads by the channel using the search endpoint, ordered by date. This helps focus on the freshest content for engagement analysis. 🧹 Next, the Prepare Video Views to Sum node extracts and organizes the returned video IDs into a structured format ready for bulk analysis. ➕ The Sum Video Views node — a custom Code block — takes each video ID, fetches its statistics, and aggregates the viewCount. You can either sum or average these views to calculate recent performance. This section is your "engagement tracker," offering insight into how actively viewers are interacting with the channel’s newest content — critical for B2B qualification or influencer assessment. --- ### 🔹 SECTION 3: Contact Intelligence ✉️ The Get Channel Email (SerpAPI) node attempts to retrieve the public email address listed on the channel’s “About” page. Since this action requires bypassing CAPTCHA (which APIs like YouTube don't support), we use SerpAPI to simulate and extract the result. ⚠️ If no email is available due to protection or limitations, fallback logic can be added later to log this for manual review. This section aims to uncover the real outreach opportunity, pulling direct contact information when available — making it a powerful lead-gen component. --- ### 🔹 SECTION 4: Data Assembly & Sheet Update 🧩 The Prepare Sheet Data node cleanly formats all collected insights — channel statistics, recent video performance, and email — into one tidy object. 📤 Finally, the Update Channel Insights node updates the original Google Sheet ro