Improving Title Clarity with Google Sheets and Email Notifications Workflow Solution

Workflow overview

Why this workflow matters

Relevant for managed services and support workflows.

🎁 Automate YouTube Giveaway Winner Selection with YouTube Comments Scraper API Description: Easily automate your YouTube video giveaways using AlekSystem 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 | Node | Name | Purpose | | ---- | -------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------- | | 1️⃣ | Form Trigger | Captures a YouTube video URL from a user via form submission. | | 2️⃣ | Fetch YouTube Comments | Makes a POST request to YouTube Comments Scraper API to retrieve comments. | | 3️⃣ | Check API Response Status | Ensures that the response status is 200 before proceeding. | | 4️⃣ | Select Random Commenter | Parses the comments and selects a random commenter as the giveaway winner. | | 5️⃣ | Log Winner to Google Sheet | Appends winner name, video URL, and date to a Google Sheet for record-keeping. | | 6️⃣ | Notify Winner Email | Sends a congratulatory email to the admin with the selected winner's name. | | 7️⃣ | Notify: Invalid API Response | If 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: Go to YouTube Comments Scraper API. Sign in or create a free RapidAPI account. Click the "Subscribe to Test" button. Copy your x-rapidapi-key from the "Code Snippets" or "Header Parameters" section. Paste it into your HTTP Request node in AlekSystem. 🎯 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 AlekSystem. 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 AlekSystem account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with AlekSystem Save time, stay consistent, and grow your LinkedIn presence effortlessly!

Best fit

Need another direction?