Step 2: Connect Google Sheets

Pull the list of video URLs that are ready for processing.

1. Select Retrieve Video URL List and set the spreadsheet to YouTube - Crawl Video Comments.
2. Set Sheet Name to Video URLs.
3. In Filters, add a filter where status equals ready.
4. Credential Required: Connect your googleSheetsOAuth2Api credentials for Retrieve Video URL List.
5. Ensure the output flows from Retrieve Video URL List to Validate Video URL Present.

Step 3: Set Up Batch Processing and the YouTube API Call

Validate each video URL, batch through records, and call the YouTube Comments API with pagination.

1. In Validate Video URL Present, set the condition to check that {{ $json.video_url }} is not empty.
2. Keep Batch Iterate Records connected after Validate Video URL Present to iterate through each URL.
3. Open YouTube Comments API Call and set URL to https://www.googleapis.com/youtube/v3/commentThreads.
4. Enable Send Query and add query parameters: part = snippet, videoId = {{ $json.video_url.match(/(?:v=|\/)([0-9A-Za-z_-]{11})/)[1] || ''}}, limit = 100.
5. In Pagination, set pageToken to {{ $response.body.nextPageToken }} and Complete When to {{ !$response.body.nextPageToken}}.
6. Credential Required: Connect your youTubeOAuth2Api credentials for YouTube Comments API Call.

Step 4: Configure Comment Validation and Upsert

Verify API success, expand comment items, and upsert comment data into the results sheet.

1. In Verify Response Success, set the condition to check {{ $json.statusCode }} equals 200.
2. Set Expand Comment Items to split out Field To Split Out = body.items.
3. In Confirm Comment Exists, set the condition to check {{ $json.snippet.videoId }} exists.
4. Configure Upsert Comment Rows with Operation = appendOrUpdate and Matching Columns = comment_id.
5. Map columns in Upsert Comment Rows: likes = {{ $json.snippet.topLevelComment.snippet.likeCount }}, reply = {{ $json.snippet.totalReplyCount }}, comment = {{ $json.snippet.topLevelComment.snippet.textOriginal }}, video_url = =https://www.youtube.com/watch?v={{ $json.snippet.videoId }}, comment_id = {{ $json.snippet.topLevelComment.id }}, author_name = {{ $json.snippet.topLevelComment.snippet.authorDisplayName }}, published_at = {{ $json.snippet.topLevelComment.snippet.publishedAt.toString().slice(0, 19).replace('T', ' ') }}.
6. Credential Required: Connect your googleSheetsOAuth2Api credentials for Upsert Comment Rows.

Step 5: Configure Status Updates and Error Path

Update the source sheet with success or error status after each video is processed.

1. In Update Sheet Status, set Operation to update and map status to finish.
2. Set row_number to {{ $('Retrieve Video URL List').item.json.row_number }} and last_fetched_time to {{ $now.toISO().toString().slice(0, 19).replace('T', ' ') }}.
3. Credential Required: Connect your googleSheetsOAuth2Api credentials for Update Sheet Status.
4. In Mark Status Error, set Operation to update and map status to error.
5. Set row_number to {{ $('Retrieve Video URL List').item.json.row_number }} and last_fetched_time to {{ $now.toISO().toString().slice(0, 19).replace('T', ' ') }}.
6. Credential Required: Connect your googleSheetsOAuth2Api credentials for Mark Status Error.

Step 6: Test and Activate Your Workflow

Run a manual test, verify data in Google Sheets, then activate the workflow.

1. Click Execute Workflow from Manual Execution Start to run a test.
2. Confirm that Upsert Comment Rows adds or updates rows in the Results sheet.
3. Check the Video URLs sheet to see status updated to finish and last_fetched_time populated, or error if failures occurred.
4. Once confirmed, toggle the workflow to Active for production use.