Improving title clarity with Google Sheets and email notifications

Name: Improving title clarity with Google Sheets and email notifications
Availability: InStock
Rating: 4.5 (7 reviews)
Author: Evoort Solutions

$20/month : Unlimited workflows

2500 executions/month

Try free

THE #1 IN WEB SCRAPING

Scrape any website without limits

Try free

HOSTINGER 🎉 Early Black Friday Deal
DISCOUNT 20%

Self-hosted n8n

Unlimited workflows - from $4.99/mo

Try free

#1 hub for scraping, AI & automation

6000+ actors - $5 credits/mo

Try free

🎁 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

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 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!

Evoort Solutions

0 workflows

Nodes

set gmail telegram agent google-gemini

Complexity

intermediate

Published 22 Sept 2025

Likes 0

View on n8n.io Download Workflow

✨

Share Your Workflow

Have a great workflow to share? Join the n8n Creator Hub and help the community!

Submit Your Template How to Submit

Related Workflows

Create and schedule LinkedIn posts from Google Sheets with Gemini and DALL·E

## Overview This n8n automation is a complete LinkedIn Content Engine that turns simple topic ideas into fully written, visual, and scheduled posts. It features a "Human-in-the-Loop" design, meaning AI handles the heavy lifting of writing and image creation, but nothing goes live until you manually approve it in Google Sheets. ## How It Works The system runs two separate workflows in parallel: ### 1. The "Creator" Workflow **Input:** Detects when you add a new topic to your "Content Calendar" Google Sheet. **Brand Alignment:** Pulls your specific "Brand Voice" guidelines from a separate tab to ensure the AI sounds like you. **Creation:** Uses Gemini Flash 1.5 to write the post and DALL-E 3 to generate a matching professional image. **Drafting:** Uploads the image to ImgBB and saves the full draft back to your sheet with a status of "Draft." ### 2. The "Publisher" Workflow **Daily Scan:** Wakes up every morning to check your Content Calendar. **Verification:** Looks for posts that match two criteria: * Date Scheduled matches today's date. * Status is marked as "Approved" (by you). **Publishing:** If both match, it automatically uploads the text and image to LinkedIn and updates the sheet status to "Posted." **Tools Used:** n8n, Google Sheets, OpenRouter (Gemini / OpenAI), ImgBB. ## Connect & Learn More **YouTube Channel:** **[Simon Scrapes](https://www.youtube.com/@simonscrapes)** – More tutorials on AI & Automation. **Community:** **[Skool Community](https://www.skool.com/scrapes/about)** – Master AI & Automation with us. **Full Video Tutorial:** [Watch the step-by-step build here](https://youtu.be/eiIRSUhPgOI?si=lgZTrPZPMqWF4uqz&t=4276)

View

Curate and post AI news to X, Bluesky, Threads and more with GPT-5 mini and Cue

# Curate & post AI news to X, Bluesky, Threads & more via GPT-5 mini & Cue This n8n template automatically curates AI news from RSS feeds and generates platform-tailored social media posts using GPT-5 mini. Posts are saved as drafts in Cue for review before publishing to X, Bluesky, Threads, Mastodon, and Facebook. Use cases include: * Daily automated AI/tech news curation * Multi-platform social media content creation * Building thought leadership with consistent posting * Staying on top of industry news without manual effort ## Who is this for? This workflow is ideal for: * Tech content creators who want to share AI news across multiple platforms * Social media managers handling multiple accounts * Anyone building an audience around AI/tech topics * Teams who want consistent daily content without manual curation ## What problem does this workflow solve? Manually curating news, writing platform-specific posts, and publishing across 5 different social networks is time-consuming. This workflow automates the entire process: * **Curation** - Pulls from 4 trusted AI/tech RSS feeds daily * **Deduplication** - Tracks posted articles in Google Sheets so you never share the same story twice * **Content creation** - GPT-5 mini writes posts tailored to each platform's style and character limits * **Review workflow** - Creates drafts in Cue so you can review before publishing ## How it works 1. **Schedule Trigger** - Runs daily at 9am (configurable) 2. **RSS Feeds** - Fetches articles from TechCrunch AI, Ars Technica AI, The Verge AI, and MIT Tech Review 3. **Filter & Merge** - Combines all feeds and filters to articles from the last 7 days 4. **Deduplication** - Compares against Google Sheets to find unposted articles 5. **Random Selection** - Picks one random article from available stories 6. **AI Generation** - GPT-5 mini generates 5 platform-specific posts with appropriate tone and length 7. **Save to Cue** - Creates a draft post with all 5 platform variations 8. **Log to Sheet** - Records the article URL to prevent future duplicates ## Setup ### Requirements * [Cue account](https://oncue.so) with connected social accounts * OpenAI API key * Google account for Sheets ### Step 1: Install the Cue community node 1. Go to **Settings** → **Community Nodes** 2. Click **Install** 3. Enter `@cuehq/n8n-nodes-cue` ### Step 2: Create tracking spreadsheet 1. Create a new Google Sheet named "AI News Tracker" 2. Add these column headers in row 1: * `article_url` * `title` * `source` * `processed_at` ### Step 3: Configure credentials 1. **Google Sheets** - Add OAuth2 credentials and connect to the "Get Recent Posts" node 2. **OpenAI** - Add your API key and connect to the "GPT-5 mini" node 3. **Cue** - Add your API key from [Cue Settings](https://app.oncue.so/settings/api) ### Step 4: Configure the Cue node 1. Open the **Create Draft in Cue** node 2. Select your **Profile** 3. For each platform slot, select your social account: * Slot 1 → X/Twitter * Slot 2 → Bluesky * Slot 3 → Threads * Slot 4 → Mastodon * Slot 5 → Facebook Don't have all 5 platforms? Simply delete the unused slots. ### Step 5: Publish Save and click **Publish** to activate the workflow. ## Customizing this workflow ### Change the schedule Edit the **Daily 9am Trigger** node to run at a different time or frequency. ### Use different RSS feeds Replace the feed URLs with sources relevant to your niche. The workflow handles any standard RSS feed. Keep 3-6 feeds for best results. ### Auto-publish instead of drafts To publish immediately instead of creating drafts, enable **Publish Immediately** in the Cue node settings. ### Adjust the AI tone Modify the system prompt in the **Write Social Posts** node to match your brand voice or adjust platform-specific guidelines. ## Good to know * **Cost** - Each run uses one OpenAI API call. With GPT-5 mini, this costs approximately $0.01-0.02 per execution. * **Draft review** - Posts are created as drafts in Cue, giving you a chance to review and edit before publishing. * **Deduplication** - The Google Sheet tracks all posted URLs, so the same article is never shared twice. ## About Cue [Cue](https://oncue.so) is a social media scheduling platform that lets you manage and publish content across X, Bluesky, Threads, Mastodon, Facebook, LinkedIn, TikTok, and Instagram from a single dashboard. Key features: * **Multi-platform publishing** - Schedule once, publish everywhere * **Platform-specific content** - Tailor each post for different audiences * **Draft workflow** - Review and edit before publishing * **API & integrations** - Connect with n8n, Zapier, Make, and custom apps [Get started free](https://oncue.so) · [Documentation](https://docs.oncue.so) · [n8n Community Node](https://www.npmjs.com/package/@cuehq/n8n-nodes-cue)

View

Create and post social media image captions with GPT-4.1-mini and Google Sheets

# Social Media Posting Automation with Image and Caption ## How it works This AI-powered workflow streamlines your social media posting process, transforming hours of manual caption writing, image uploading, and scheduling into a fully automated system. You define the topic and image once, and the workflow handles caption generation, review, approval, and posting to your selected platforms. ### Automated Flow 1. **Generate Caption** Trigger the workflow manually and set your post topic and image URL in the Set node. The AI (GPT-4.1-mini) generates a high-quality, engaging social media caption tailored to your audience, platform, and content goals. 2. **Store in Google Sheet** The generated caption, along with your image URL and post metadata, is automatically appended to your Google Sheet. This creates a central location to review and manage all your social media content. 3. **Review and Approve** You review the generated caption in the sheet, make any edits if needed, and update the status to **Approved**. You can also select the platform(s) where you want to post. 4. **Automatic Posting** Once the status is updated to Approved, the next workflow is triggered automatically. It posts your caption and image to the selected social media platform(s) without any further manual effort. **The result?** A seamless, end-to-end social media posting process where captions are AI-generated, stored, reviewed, and posted automatically. Focus on strategy and engagement instead of repetitive manual posting. --- ## Setup Steps **Setup time:** ~10–15 minutes **What you’ll need:** OpenAI API key, Google account, access to your social media platform(s) 1. **Connect Your Google Account** - Click on the Google Sheets node in your workflow. - Select the Credential dropdown and choose **+ Create New Credential**. - Authenticate your Google account and grant the necessary permissions. 2. **Initialize Your Spreadsheet** - Run the workflow once by clicking the play button on the start node. - This will automatically create a Google Sheet with all the required columns for caption tracking and approval. 3. **Add Your OpenAI API Key** - Navigate to the AI Agent node. - Click the Credential dropdown and select **+ Create New Credential**. - Paste your OpenAI API key and save. - Get your API key from [platform.openai.com/api-keys](https://platform.openai.com/api-keys). 4. **Set Post Topic and Image** - Update the title in the Set node with the topic you want to post. - Add the image URL associated with your post. 5. **Review Captions and Approve** - Open your Google Sheet, review the generated captions, and update the status to **Approved**. - Select the platform(s) where the post should go live. 6. **Go Live** - Once the status is updated, the workflow will automatically post your content to the selected social media platform(s). - Sit back and watch your AI-generated captions and images go live automatically. **Ready to automate your social media?** Activate your workflow and start posting smarter today! 🚀💡✅

View

👨‍💻

Need Custom Automation?

N8N Automation Expert

Specialized in N8N automation, I design custom workflows that connect your tools and automate your processes.