Overview
Manually extracting YouTube comments from multiple videos is tedious and error-prone. This workflow automates the entire process: it reads video URLs marked as ready from a Google Spreadsheet, fetches comments via the YouTube Data API, appends them to a results sheet, updates processing statuses, and generates a summary—eliminating manual drudgery and delivering clean, structured data for analysis or audit.
The Impact
- Automate comment crawling. Eliminate manual copy-pasting with API-driven extraction.
- Ensure data integrity. Update processing status per video to track progress and errors.
- Centralize archives. Store all comments in a dedicated Google Sheet for easy review and export.
- Summarize results. Quickly see total videos processed and comments archived.
Who This Is For
- Content Managers tracking public opinion and engagement on YouTube videos.
- Compliance Officers archiving comments for audit and legal oversight.
- Data Analysts gathering raw comment data for sentiment and interaction analysis.
- Community Researchers collecting bulk comments for research projects.
How It Works
- Read and Filter Videos
- Load video URLs from the specified Google Sheet, filtering those marked as "ready" to process.
- Fetch Comments via API
- For each video, call the YouTube Data API using your API key to retrieve the latest comment threads.
- Parse and Format Comments
- Convert API responses into structured rows matching the results sheet format.
- Append and Update Status
- Append comments to the results sheet and update each video's status to "finish" or "error" in the original sheet.
- Generate Summary
- Aggregate total videos processed and comments collected, returning a concise execution summary.
What You'll Need
Before using this template, make sure you have:
- A Google Spreadsheet with two sheets: one listing videos with status and URLs, another for storing comments.
- Google OAuth2 credentials authorized to read and write to your spreadsheet.
- A valid YouTube Data API v3 key with access enabled in Google Cloud Console.
- Basic knowledge of your spreadsheet's ID and sheet names for configuration.
How to Use
- Step 1. Prepare Your Spreadsheet
- Step 2. Configure Credentials
- Step 3. Set Parameters
- Step 4. Run the Workflow
- Step 5. Verify Results
Create two sheets: one named (e.g.) "Video URLs" with columns Status and Video URL, another named (e.g.) "Results" with columns for comment data.
Set up Google OAuth2 credentials for spreadsheet access and obtain a YouTube Data API key.
Enter SpreadsheetId, VideoUrlsSheetName, ResultsSheetName, and YouTubeApiKey into the workflow inputs.
Execute the automation; it will process each "ready" video URL, fetch comments, append them, and update statuses.
Check the Results sheet for newly appended comments and confirm that the original sheet's status columns reflect processing outcomes.
