n8nflow.net logo

Improving Title Clarity with Google Sheets and Email Notifications

by Evoort SolutionsUpdated: Last update 6 days agoSource: n8n.io
Loading workflow viewer...

Getting Started

🎁 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:

  • Automatically pick a random commenter from a YouTube video as a giveaway winner.

🚀 Benefits:

  • Fully automated – no manual comment scanning or random selection.
  • Accurate & fair – random selection from valid commenters only.
  • Time-saving – especially for creators running multiple giveaways.
  • Integrated logging – keep a historical record of all winners in Google Sheets.
  • Email alerts – get notified whether the flow succeeds or fails.

👥 Who Is This For?

  • YouTube Content Creators running giveaways.
  • Marketing Teams promoting products via YouTube contests.
  • Agencies managing influencer campaigns.
  • Developers & Automation Enthusiasts looking to simplify giveaway processes.

💡 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:

  • To retrieve all comments from a YouTube video.
  • To power fair and transparent giveaways.
  • To trigger downstream automations like winner logging and notification.

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!