Extract & Store YouTube Comments in Google Sheets

This n8n workflow extracts comments from YouTube videos listed in a Google Sheet and stores them in a dedicated Results tab. It processes only URLs marked 'Ready' in the Video URLs tab, fetches data using YouTube API HTTP requests, validates responses, and appends comments with details. After completion, it updates the URL status to 'Finished', enabling scalable batch processing without manual intervention.

Key benefits include time-saving automation for YouTube creators, marketers, data analysts, and growth teams. It provides actionable insights from audience feedback, campaign performance metrics, and engagement data at scale, eliminating tedious manual scraping. Integrates seamlessly with Google Sheets for easy input/output management.

Use cases: Monitor viewer sentiment for content optimization, compile datasets for AI analysis, track social media ROI, or build comment archives for research. Setup requires importing the workflow, duplicating the provided Sheet template, and configuring Google Cloud credentials for Sheets and API access.

The workflow supports looping through multiple videos, error handling for failed requests, and structured data output, making it robust for production use.