Improving title clarity with Google Sheets and email notifications

🎁 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](https://rapidapi.com/PrineshPatel/api/youtube-comments-scraper). 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](https://rapidapi.com/PrineshPatel/api/youtube-comments-scraper) 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](https://rapidapi.com/PrineshPatel/api/youtube-comments-scraper), follow these steps: