What your YouTube viewers are saying

Sorts the comments on your latest videos into asks, praise and complaints, and emails the counts with real quotes.

KDKevin Duan · 1 workflow · Updated Nov 13, 2026

UsesClaudeGmailGoogle SheetsYouTube

What your YouTube viewers are saying

Run every Monday at 09:00.Run every Monday at 09:00.

Set channelId to blank.Set channelId to blank.

Set digestRecipient to blank.Set digestRecipient to blank.

Set videosToCheck to 3.Set videosToCheck to 3.

Set commentsPerVideo to 15.Set commentsPerVideo to 15.

Set quotesPerTheme to 4.Set quotesPerTheme to 4.

Set logSheetUrl to blank.Set logSheetUrl to blank.

Set logSheetTab to Comment themes.Set logSheetTab to Comment themes.

YouTubeGet the details of channelId. Save it as channel.Get the details of channelId. Save it as channel.

Set channelName to your channel.Set channelName to your channel.

If a step below fails, save the error as channelNameErrorIf a step below fails, save the error as channelNameError

Try

Trim channel.title and save it as channelName.Trim channel.title and save it as channelName.

On error

Show in the output: The channel has no title; calling it 'your channel'..Show in the output: The channel has no title; calling it 'your channel'..

Set uploadsPlaylistId to blank.Set uploadsPlaylistId to blank.

If a step below fails, save the error as uploadsErrorIf a step below fails, save the error as uploadsError

Try

Trim channel.related_playlists.uploads and save it as uploadsPlaylistId.Trim channel.related_playlists.uploads and save it as uploadsPlaylistId.

On error

Show in the output: That channel did not come back with an uploads playlist..Show in the output: That channel did not come back with an uploads playlist..

If uploadsPlaylistId is emptyIf uploadsPlaylistId is empty

Yes

Stop and report a problem: YouTube did not return an uploads playlist for that channel, so there are no videos to read. Check the value in the 'channelId' step is a channel ID starting with UC, not a channel name or a video link.Stop and report a problem: YouTube did not return an uploads playlist for that channel, so there are no videos to read. Check the value in the 'channelId' step is a channel ID starting with UC, not a channel name or a video link.

No steps

YouTubeList the videos in uploadsPlaylistId. Save it as uploads.List the videos in uploadsPlaylistId. Save it as uploads.

Set videos to uploads.items.Set videos to uploads.items.

Set reviewedCount to 0.Set reviewedCount to 0.

Set requestCount to 0.Set requestCount to 0.

Set praiseCount to 0.Set praiseCount to 0.

Set complaintCount to 0.Set complaintCount to 0.

Set otherCount to 0.Set otherCount to 0.

Set requestQuotes to an empty list.Set requestQuotes to an empty list.

Set praiseQuotes to an empty list.Set praiseQuotes to an empty list.

Set complaintQuotes to an empty list.Set complaintQuotes to an empty list.

Set videoLines to an empty list.Set videoLines to an empty list.

For each video in videos:For each video in videos:

Set videoTitle to Untitled video.Set videoTitle to Untitled video.

If a step below fails, save the error as videoTitleErrorIf a step below fails, save the error as videoTitleError

Try

Trim video.title and save it as videoTitle.Trim video.title and save it as videoTitle.

On error

Show in the output: A video in the uploads list had no title..Show in the output: A video in the uploads list had no title..

Set videoId to blank.Set videoId to blank.

If a step below fails, save the error as videoIdErrorIf a step below fails, save the error as videoIdError

Try

Trim video.video_id and save it as videoId.Trim video.video_id and save it as videoId.

On error

Show in the output: Skipped an uploads entry that had no video id..Show in the output: Skipped an uploads entry that had no video id..

If videoId isn't emptyIf videoId isn't empty

Yes

Set videoCommentCount to 0.Set videoCommentCount to 0.

Set comments to an empty list.Set comments to an empty list.

If a step below fails, save the error as commentReadErrorIf a step below fails, save the error as commentReadError

Try

Change comments to the items from the YouTube “List video comments” step.Change comments to the items from the YouTube “List video comments” step.

On error

Show in the output: Could not read the comments on: videoTitle.Show in the output: Could not read the comments on: videoTitle.

For each comment in comments:For each comment in comments:

Set commentText to blank. Set commentText to blank.

If a step below fails, save the error as commentTextError If a step below fails, save the error as commentTextError

Try

Trim comment.text and save it as commentText.Trim comment.text and save it as commentText.

On error

Show in the output: Skipped a comment with no text on: videoTitle.Show in the output: Skipped a comment with no text on: videoTitle.

If commentText isn't empty If commentText isn't empty

Yes

Set commentAuthor to A viewer.Set commentAuthor to A viewer.

If a step below fails, save the error as commentAuthorErrorIf a step below fails, save the error as commentAuthorError

Try

Trim comment.author and save it as commentAuthor.Trim comment.author and save it as commentAuthor.

On error

Show in the output: A comment had no author name; recording it as 'A viewer'..Show in the output: A comment had no author name; recording it as 'A viewer'..

If commentAuthor is emptyIf commentAuthor is empty

Yes

Change commentAuthor to A viewer.Change commentAuthor to A viewer.

No steps

Set sortPrompt to You are sorting one comment left on a YouTube video into exactly one bucket.Set sortPrompt to You are sorting one comment left on a YouTube video into exactly one bucket. Reply with EXACTLY one of these words and nothing else - no punctuation, no explanation, and never quote the comment back: request - the viewer is asking for something: a topic, a follow-up, a tutorial, a feature, more detail praise - the viewer is saying something positive about the video or the channel complaint - the viewer is unhappy, confused, or reporting a problem other - anything else, including spam, off-topic chatter and one-word reactions Video: videoTitle Comment: commentText.

Set bucket to blank.Set bucket to blank.

If a step below fails, save the error as sortErrorIf a step below fails, save the error as sortError

Try

Replace . with in the response text from the Claude “Ask Claude” step in lowercase and save it as bucket.Replace . with in the response text from the Claude “Ask Claude” step in lowercase and save it as bucket.

On error

Show in the output: Could not sort a comment on: videoTitle.Show in the output: Could not sort a comment on: videoTitle.

If bucket isn't emptyIf bucket isn't empty

Yes

Add 1 to reviewedCount.Add 1 to reviewedCount.

Add 1 to videoCommentCount.Add 1 to videoCommentCount.

Set quoteLine to - @commentText truncated to 220 characters using ... as the ellipsis - commentAuthor (on videoTitle).Set quoteLine to - @commentText truncated to 220 characters using ... as the ellipsis - commentAuthor (on videoTitle).

If bucket is requestIf bucket is request

Yes

Add 1 to requestCount.Add 1 to requestCount.

If the length of requestQuotes is less than quotesPerThemeIf the length of requestQuotes is less than quotesPerTheme

Yes

Add quoteLine to the end of requestQuotes and save it as requestQuotes.Add quoteLine to the end of requestQuotes and save it as requestQuotes.

No steps

Else if @bucket is "praise"

Add 1 to praiseCount.Add 1 to praiseCount.

If the length of praiseQuotes is less than quotesPerThemeIf the length of praiseQuotes is less than quotesPerTheme

Yes

Add quoteLine to the end of praiseQuotes and save it as praiseQuotes.Add quoteLine to the end of praiseQuotes and save it as praiseQuotes.

No steps

Else if @bucket is "complaint"

Add 1 to complaintCount.Add 1 to complaintCount.

If the length of complaintQuotes is less than quotesPerThemeIf the length of complaintQuotes is less than quotesPerTheme

Yes

Add quoteLine to the end of complaintQuotes and save it as complaintQuotes.Add quoteLine to the end of complaintQuotes and save it as complaintQuotes.

No steps

Otherwise

Add 1 to otherCount.Add 1 to otherCount.

No steps

Add - videoTitle - videoCommentCount as text sorted to the end of videoLines and save it as videoLines.Add - videoTitle - videoCommentCount as text sorted to the end of videoLines and save it as videoLines.

No steps

If reviewedCount is 0If reviewedCount is 0

Yes

Finish the run: No comments came back on your latest videos, so there was nothing to sort and no digest was sent.Finish the run: No comments came back on your latest videos, so there was nothing to sort and no digest was sent.

No steps

Set requestBlock to No requests this time..Set requestBlock to No requests this time..

If requestQuotes isn't emptyIf requestQuotes isn't empty

Yes

Join requestQuotes with a new line and save it as requestBlock.Join requestQuotes with a new line and save it as requestBlock.

No steps

Set requestSection to WHAT THEY ASKED FOR (requestCount as text)Set requestSection to WHAT THEY ASKED FOR (requestCount as text) requestBlock.

Set praiseBlock to No praise this time..Set praiseBlock to No praise this time..

If praiseQuotes isn't emptyIf praiseQuotes isn't empty

Yes

Join praiseQuotes with a new line and save it as praiseBlock.Join praiseQuotes with a new line and save it as praiseBlock.

No steps

Set praiseSection to WHAT THEY PRAISED (praiseCount as text)Set praiseSection to WHAT THEY PRAISED (praiseCount as text) praiseBlock.

Set complaintBlock to No complaints this time..Set complaintBlock to No complaints this time..

If complaintQuotes isn't emptyIf complaintQuotes isn't empty

Yes

Join complaintQuotes with a new line and save it as complaintBlock.Join complaintQuotes with a new line and save it as complaintBlock.

No steps

Set complaintSection to WHAT THEY COMPLAINED ABOUT (complaintCount as text)Set complaintSection to WHAT THEY COMPLAINED ABOUT (complaintCount as text) complaintBlock.

Set headerLine to Here is what viewers said on the last the length of videoLines as text videos from channelName.Set headerLine to Here is what viewers said on the last the length of videoLines as text videos from channelName.

Set countsBlock to Comments sorted: reviewedCount as textSet countsBlock to Comments sorted: reviewedCount as text Asked for something: requestCount as text Praised: praiseCount as text Complained: complaintCount as text Everything else: otherCount as text.

Set digestBody to headerLineSet digestBody to headerLine countsBlock requestSection praiseSection complaintSection VIDEOS CHECKED videoLines joined by a new line Every quote above is copied word for word from a comment on your channel; nothing here is wording the AI came up with.

GmailSend an email to digestRecipient.Send an email to digestRecipient. Subject: What your viewers said on channelNamedigestBody

If logSheetUrl isn't emptyIf logSheetUrl isn't empty

Yes

If a step below fails, save the error as logErrorIf a step below fails, save the error as logError

Try

Google SheetsAdd a row to logSheetTab in logSheetUrl.Add a row to logSheetTab in logSheetUrl.

On error

Show in the output: The digest was emailed but the run could not be logged to your spreadsheet..Show in the output: The digest was emailed but the run could not be logged to your spreadsheet..

No steps