Analyze YouTube Comment Sentiment and Save to Google Sheets

### **How to Use This Workflow:**
📝 **YouTube Comment Sentiment Analyzer**

1. 🔘 **Trigger:** Click "Execute Workflow" to run it manually.

2. 📄 Your Google Sheet should have **2 sheets**:
   - **Sheet1 (Results with Sentiment):**
     - Column A: `commentId` (YouTube comment id)
     - Column B: `video_url` (url of video)
     - Column C: `comment` (YouTube comment)
     - Column D: `authorName` (Name of author as per Youtube)
     - Column E: `likes` (Number of likes on that particular comment)
     - Column f: `reply` (Number of replies on that particular comment)
     - Column g: `sentiment` (Analyzed sentiment of the comment)
     - Column h: `published_at` (timestamp of comment published)
   
   - **Sheet2 (Video URLs):**
     - Column A: `video_urls` (list of YouTube video URLs)
     - Column B: `last_fetched_time` (timestamp of the last fetch)
     - Column C: `next_fetch_time` (time for the next fetch)

3. 🔐 **Make sure these credentials are set up**:
   - Google Sheets (Service Account)
   - YouTube Data API v3
   - OpenAI API Key (for sentiment analysis)

4. ✅ **What this workflow does**:
   - Reads **video URLs** from **Sheet2**.
   - Checks **last fetched time** (if applicable).
   - Fetches new comments from YouTube.
   - Analyzes sentiment using OpenAI.
   - Appends **comment**, **sentiment**, **video ID**, and **timestamp** to **Sheet1**.
   - Updates **last_fetched** timestamp in **Sheet2**.

5. 💡 **Tip:**
   - You can replace the **Manual Trigger** with a **Cron node** for automatic execution at specified intervals.