This n8n workflow automates the process of extracting comments from multiple YouTube videos and storing them in a Google Sheet. It is designed for content creators, marketers, or data analysts who want to analyze audience engagement, gather feedback, or monitor comments at scale. The process begins with reading a list of video URLs from a Google Sheet where each URL is marked as ‘Ready’. The workflow then fetches comments from each video via the YouTube API, splitting the results for individual processing. Valid comments are inserted or updated in a designated Google Sheet tab, while the status of each video is updated to ‘Finished’ or ‘Error’ based on the API response. The setup involves Google Sheets and YouTube API integrations, making it suitable for ongoing comment monitoring or campaign analysis.
YouTube Comment Scraper and Google Sheets Integrator
Node Count | 11 – 20 Nodes |
---|---|
Nodes Used | googleSheets, httpRequest, if, manualTrigger, splitInBatches, splitOut, stickyNote |
Reviews
There are no reviews yet.