Improving title clarity with Google Sheets and email notifications
Ready for 3.0What 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 ”).
- Fetch YouTube Comments (HTTP Request): calls youtube-comments-scraper.p.rapidapi.com (POST)
- Check API Response Status (If): checks a condition and branches into true / false
- Select Random Commenter (Code): runs custom JavaScript code
- Notify: Invalid API Response (Send Email): sends an email over SMTP
- Log Winner to Google Sheet (Google Sheets): append
- Notify Winner Email (Send Email): sends an email over SMTP
Services it uses
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)
- n8n Form Trigger
n8n-nodes-base.formTrigger - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Send Email
n8n-nodes-base.emailSend - Google Sheets
n8n-nodes-base.googleSheets
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…