Automate YouTube Comment Scraping and Management
detail.loadingPreview
Streamline your YouTube engagement by automatically scraping comments from videos and organizing them directly into your Google Sheets. This workflow enhances your ability to track audience sentiment and manage feedback efficiently.
About This Workflow
This n8n workflow automates the process of collecting valuable data from YouTube videos. It begins by fetching a list of video URLs from a Google Sheet, identifies which ones haven't been scraped yet, and then leverages the Apify API to extract comments from specified videos. The scraped comment data, including author, content, and likes, is then meticulously saved back into a separate Google Sheet for easy analysis and further action. This solution is ideal for businesses, content creators, and researchers looking to gain deeper insights from their YouTube audience.
Key Features
- Automated Comment Extraction: Seamlessly pull comments from any YouTube video URL.
- Google Sheets Integration: Automatically reads video URLs from and writes scraped comments to your Google Sheets.
- Smart Scraping Logic: Ensures you only process videos that haven't been scraped before.
- Comprehensive Data Capture: Gathers key comment details like author, content, and engagement metrics.
- Customizable Workflow: Easily adaptable to fit your specific data management needs.
How To Use
- Setup Google Sheets: Ensure you have two Google Sheets set up: one for your YouTube video URLs (with a column named 'url' and another named 'scrapped') and another for storing the scraped comments.
- Configure n8n:
- 'Get video urls' Node: Connect your Google Sheets account and specify the spreadsheet and sheet containing your video URLs. Set a filter to only retrieve rows where the 'scrapped' column is not marked as TRUE.
- 'HTTP apify get comments from video' Node: Input your Apify API token. Dynamically pass the 'url' field from the previous Google Sheets node into the 'videoUrl' parameter of the Apify API.
- 'mark video url as scrapped' Node: Connect your Google Sheets account and specify the video URL sheet. Configure it to update the 'scrapped' column to 'TRUE' for the processed video URL.
- 'Save scrapped comments' Node: Connect your Google Sheets account and specify the sheet where you want to save the comments. Map the relevant fields from the Apify API response (e.g., 'author', 'content') to your Google Sheet columns.
- Trigger Workflow: Manually click the 'Execute workflow' button to initiate the scraping process.
Apps Used
Workflow JSON
{
"id": "f3177049-dd6e-4eb9-8fa9-418920d6dc26",
"name": "Automate YouTube Comment Scraping and Management",
"nodes": 23,
"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: f3177049-dd6e...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
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.