Extract & Store YouTube Video Comments in Google Sheets

This n8n workflow extracts comments from YouTube videos using the YouTube API and stores them directly in a Google Sheet. It reads a list of video URLs from the 'Video URLs' tab in a designated Google Sheet, processing only those marked as 'Ready'. For each video, it fetches comments via HTTP requests, validates success, processes the data, and appends comments to the 'Results' tab. Completed URLs are updated to 'Finished' status, enabling seamless batch processing without manual intervention.

Ideal for YouTube creators analyzing audience feedback, marketers tracking campaign engagement, data analysts compiling metrics, or growth teams monitoring social performance. It scales effortlessly for multiple videos, saving hours of manual scraping and data entry while providing actionable insights like sentiment trends or top comments.

Benefits include automation of repetitive tasks, real-time data integration between YouTube and Google Sheets, error handling for failed requests, and easy customization via n8n. Setup requires importing the workflow, duplicating the provided Google Sheet template, and configuring Google Cloud credentials for Sheets and API access, making it accessible for non-technical users.