Step 2: Connect Google Sheets

Google Sheets is used for input video URLs and for storing comment insights and status updates.

1. Open Retrieve Video Links and select your spreadsheet in Document and Sheet.
2. Confirm the filter is set to retrieve rows where status equals =Ready.
3. Credential Required: Connect your googleSheetsOAuth2Api credentials in Retrieve Video Links.
4. Open Store Comment Insights and set Operation to appendOrUpdate.
5. Credential Required: Connect your googleSheetsOAuth2Api credentials in Store Comment Insights.
6. Open Set Video Status and set Operation to update.
7. Credential Required: Connect your googleSheetsOAuth2Api credentials in Set Video Status.

Execution Flow: Retrieve Video Links → Validate Video URL → Batch Iterate Items

Step 3: Configure YouTube Comment Retrieval

The workflow validates each URL, fetches comments from YouTube, verifies the response, and splits comments into individual items.

1. Open Validate Video URL and confirm the condition checks for a non-empty URL: ={{ $json.video_url }}.
2. Open Batch Iterate Items and keep default settings for batch processing.
3. Open API Fetch Comments and set URL to https://www.googleapis.com/youtube/v3/commentThreads.
4. Set query parameters in API Fetch Comments:
   • part: snippet
   • videoId: ={{ $json.video_url.match(/(?:v=|\/)([0-9A-Za-z_-]{11})/)[1] || ''}}
   • limit: 100
5. Credential Required: Connect your youTubeOAuth2Api credentials in API Fetch Comments.
6. Open Verify HTTP Success and confirm the check for ={{ $json.statusCode }} equals 200.
7. Open Separate Items and set Field to Split Out to body.items.

Execution Flow: API Fetch Comments → Verify HTTP Success → Separate Items → Confirm Comment Exists

Step 4: Set Up Analyze Comment Sentiment

This step runs sentiment analysis on each comment and passes the results to storage.

1. Open Confirm Comment Exists and verify it checks for ={{ $json.snippet.videoId }} existence before analysis.
2. Open Analyze Comment Sentiment and set Input Text to ={{ $json.snippet.topLevelComment.snippet.textOriginal }}.
3. Ensure the sentiment categories are configured as Positive, Neutral, Negative in Analyze Comment Sentiment.
4. Credential Required: Connect your googlePalmApi credentials in Gemini Chat Engine (the language model powering Analyze Comment Sentiment).
5. If you plan to use OpenAI Chat Engine, connect Credential Required: openAiApi and wire it to a processing node (it is currently not linked to the flow).

Execution Flow: Confirm Comment Exists → Analyze Comment Sentiment → Store Comment Insights

Step 5: Configure Output Updates

Sentiment results are written to a results sheet, and each processed video is marked as finished.

1. In Store Comment Insights, map columns using expressions such as:
   • sentiment: ={{ $json.sentimentAnalysis.category }}
   • comment: ={{ $json.snippet.topLevelComment.snippet.textOriginal }}
   • video_url: =https://www.youtube.com/watch?v={{ $json.snippet.videoId }}
   • published_at: ={{ $json.snippet.topLevelComment.snippet.publishedAt.toString().slice(0, 19).replace('T', ' ') }}
2. In Set Video Status, set status to Finished.
3. Set row_number to ={{ $('Retrieve Video Links').item.json.row_number }} and last_fetched_time to ={{ $now.toISO().toString().slice(0, 19).replace('T', ' ') }}.
4. Confirm that Store Comment Insights outputs to Set Video Status, then to Batch Iterate Items for the next video.

Execution Flow: Store Comment Insights → Set Video Status → Batch Iterate Items

Final Step: Test and Activate Your Workflow

Run a manual test to validate data flow and ensure sheets are updated correctly.

1. Click Execute Workflow from Manual Run Trigger to start the pipeline.
2. Verify that Store Comment Insights appends or updates rows with sentiment data.
3. Check that Set Video Status updates status to Finished and writes a timestamp.
4. Once confirmed, toggle the workflow to Active to use it in production.