YouTube Video Comment Extractor for Google Sheets
detail.loadingPreview
This n8n workflow automates the extraction of all comments from a list of YouTube video URLs stored in Google Sheets. It processes each video, fetches comments with pagination, and updates the sheet upon completion, providing an efficient way to gather social data.
About This Workflow
Empower your data analysis by effortlessly collecting YouTube video comments with this robust n8n workflow. Designed for efficiency, it takes a list of video URLs from your Google Sheet, intelligently extracts video IDs, and then uses the YouTube Data API to fetch every single comment thread, handling pagination automatically. After successful retrieval, the workflow updates your Google Sheet, marking videos as 'finished' and recording the last fetched timestamp. This ensures a streamlined, automated process for gathering valuable social engagement data without manual intervention. Ideal for marketers, researchers, and content creators looking to analyze audience feedback at scale, and provides the extracted comments for further processing.
Key Features
- Automated YouTube Comment Extraction: Fetches all available comments for specified YouTube videos using the official YouTube Data API.
- Google Sheets Integration: Seamlessly reads video URLs from a designated Google Sheet and updates processing status in the same sheet.
- Smart Pagination Handling: Automatically navigates through multiple pages of comments, ensuring comprehensive data retrieval without manual intervention.
- Robust Error Handling: Includes conditional checks for valid video URLs and successful API responses, enhancing the workflow's reliability.
- Process Tracking: Updates the source Google Sheet with a 'finish' status and timestamp for each processed video, providing clear oversight.
How To Use
- Set up Google Sheets Credentials: Ensure you have an n8n credential configured for Google Sheets OAuth2, granting access to your specified spreadsheet.
- Configure YouTube API Credentials: Create and link your YouTube OAuth2 API credential in n8n, ensuring it has the necessary scopes to read comment threads.
- Prepare Your Google Sheet: Create a Google Sheet with a column named
video_urlcontaining the full YouTube video links. Optionally, addstatusandlast_fetched_timecolumns, which the workflow will automatically update. - Update Google Sheets Nodes: In the implied 'Google Sheets - Get Video URLs' node (which feeds into 'Loop Over Items') and the 'Google Sheets - Update Status' node, select your spreadsheet and the correct sheet name (e.g., 'Video URLs').
- Activate and Execute: Once configured, activate the workflow. It will iterate through your video URLs, fetch comments, and update the processing status in your sheet. The extracted comments will be available as output from the 'Split Out' node for subsequent actions (e.g., saving to another sheet, database, or sending for analysis).
Apps Used
Workflow JSON
{
"id": "0ca40f90-a6cd-452e-bfdf-1219284ce2a5",
"name": "YouTube Video Comment Extractor for Google Sheets",
"nodes": 7,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 0ca40f90-a6cd...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.