Collect YouTube Channel Stats & Contact Info with Google Sheets and SerpAPI

Workflow Overview This advanced n8n automation is a powerful channel research and intelligence gathering tool designed to transform raw YouTube channel data into actionable insights. By intelligently connecting multiple APIs and data sources, this workflow: Discovers Channel Metrics: Automatically retrieves channel statistics Captures detailed performance indicators Provides comprehensive channel intelligence Performs Deep Analysis: Extracts recent video performance data Calculates engagement metrics Aggregates view count insights Uncovers Contact Information: Attempts to retrieve public email addresses Provides direct outreach opportunities Enhances lead generation capabilities Seamless Dat

Help me set up the n8n workflow "Collect YouTube Channel Stats & Contact Info with Google Sheets and SerpAPI" (https://n8n.io/workflows/4585). It uses: Google Sheets, HTTP Request, Code. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.