📱 Improving title clarity with Google Sheets and email notifications

93 views · 📱 Social Media & Email Marketing

💡 Pro Tip — YouTube’s API quotas can be a bottleneck when you’re pulling data at scale. ScraperNode is a community node with dedicated scrapers for channels, videos, and comments — no quota limits, just structured data.

View All Scrapers

Description

🎁 Automate YouTube Giveaway Winner Selection with YouTube Comments Scraper API

Description: Easily automate your YouTube video giveaways using n8n and the YouTube Comments Scraper API. This workflow fetches comments, selects a random winner, logs results to Google Sheets, and notifies the admin—all hands-free!


🧩 Node-by-Node Breakdown

NodeNamePurpose
1️⃣Form TriggerCaptures a YouTube video URL from a user via form submission.
2️⃣Fetch YouTube CommentsMakes a POST request to YouTube Comments Scraper API to retrieve comments.
3️⃣Check API Response StatusEnsures that the response status is 200 before proceeding.
4️⃣Select Random CommenterParses the comments and selects a random commenter as the giveaway winner.
5️⃣Log Winner to Google SheetAppends winner name, video URL, and date to a Google Sheet for record-keeping.
6️⃣Notify Winner EmailSends a congratulatory email to the admin with the selected winner’s name.
7️⃣Notify: Invalid API ResponseIf the API fails, sends an alert to the admin about the issue.

🔑 How to Get Your RapidAPI Key

To use the YouTube Comments Scraper API, follow these steps:

  1. Go to YouTube Comments Scraper API.
  2. Sign in or create a free RapidAPI account.
  3. Click the “Subscribe to Test” button.
  4. Copy your x-rapidapi-key from the “Code Snippets” or “Header Parameters” section.
  5. Paste it into your HTTP Request node in n8n.

🎯 Use Case & Benefits

✅ Use Case:

🚀 Benefits:


👥 Who Is This For?


💡 Why Use YouTube Comments Scraper API?

The YouTube Comments Scraper API offers a simple and effective way to extract public YouTube comments programmatically. It’s fast, reliable, and integrates smoothly with platforms like n8n.

You’ll use this API:


Create your free n8n account and set up the workflow in just a few minutes using the link below:

👉 Start Automating with n8n

Save time, stay consistent, and grow your LinkedIn presence effortlessly!

🔗 Nodes Used

Send Email, Google Sheets, HTTP Request, n8n Form Trigger

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup