Templates / Improving title clarity with Google Sheets and email notifications

Improving title clarity with Google Sheets and email notifications

Ready for 3.0

by Evoort Solutions ✓ · 106 views · created 2025-09-22 · Social Media

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 7 nodes and runs when someone submits an n8n form (“YouTube Video giveaway ”). Along the way it connects Google Sheets. It also calls youtube-comments-scraper.p.rapidapi.com over HTTP.

How it runs

Trigger: When someone submits an n8n form (“YouTube Video giveaway ”).

  1. Fetch YouTube Comments (HTTP Request): calls youtube-comments-scraper.p.rapidapi.com (POST)
  2. Check API Response Status (If): checks a condition and branches into true / false
  3. Select Random Commenter (Code): runs custom JavaScript code
  4. Notify: Invalid API Response (Send Email): sends an email over SMTP
  5. Log Winner to Google Sheet (Google Sheets): append
  6. Notify Winner Email (Send Email): sends an email over SMTP

Services it uses

Google Sheets

HTTP calls to: youtube-comments-scraper.p.rapidapi.com

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (6)

From the author

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

Excerpt from Evoort Solutions's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.