Sort product feedback into themes

Every day, the feedback on your feedback tab is read and each piece is sorted by AI into one of the themes you define, with its tone judged as positive, neutral or negative. Each sorted item is written to a separate tab, and a short rollup is posted to your product channel in Slack.

You get a Slack message with two or three sentences on which themes came up most and anything that reads as urgent, followed by the full sorted list. Feedback that fits none of your themes is filed as Other rather than forced into the nearest one, and frustrated feedback is recorded as negative, not softened. Each item reaches the sorted tab before the rollup is attempted, so a failure in the summary costs you the commentary, never the sorted feedback. It posts on quiet days too, because a rollup that goes silent looks the same as one that has broken.

You need a feedback tab with a 'Feedback' column, a second tab for the sorted results, your list of themes and a Slack channel.

Run every day.Run every day.

Set feedbackUrl to blank.Set feedbackUrl to blank.

Set themes to blank.Set themes to blank.

Set slackChannelId to blank.Set slackChannelId to blank.

Set feedbackTab to Feedback.Set feedbackTab to Feedback.

Set sortedTab to Sorted.Set sortedTab to Sorted.

Set maxRows to 200.Set maxRows to 200.

Google SheetsRead the rows of feedbackUrl. Save it as sheet.Read the rows of feedbackUrl. Save it as sheet.

Set sorted to an empty list.Set sorted to an empty list.

For each item in sheet.rows:For each item in sheet.rows:

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

Try

Trim item.Feedback and save it as comment.Trim item.Feedback and save it as comment.

If comment isn't emptyIf comment isn't empty

Yes

ClaudeAsk Claude: 'Sort one piece of product feedback into EXACTLY one of the themes listed below, and judge its tone. Reply with two lines and nothing else:Ask Claude: 'Sort one piece of product feedback into EXACTLY one of the themes listed below, and judge its tone. Reply with two lines and nothing else: THEME: the theme name, copied exactly from the list TONE: one of positive, neutral, negative If it fits none of the themes, use the theme name Other. Do not invent a new theme, and do not soften the tone - feedback that reads as frustrated is negative. Themes: themes The feedback: comment'. Save it as verdict. Maximum response length: 40

Trim verdict.response_text and save it as sortedAs.Trim verdict.response_text and save it as sortedAs.

If sortedAs isn't emptyIf sortedAs isn't empty

Yes

Add - sortedAs | comment to the end of sorted and save it as sorted.Add - sortedAs | comment to the end of sorted and save it as sorted.

Google SheetsAdd a row to sortedTab in feedbackUrl.Add a row to sortedTab in feedbackUrl.

No

No steps

No

No steps

On error

Show in the output: Could not sort a feedback row: sortError as text.Show in the output: Could not sort a feedback row: sortError as text.

If sorted is emptyIf sorted is empty

Yes

SlackSend a message to slackChannelId.Send a message to slackChannelId.*Feedback rollup* Nothing new to sort today.

No

Join sorted with a new line and save it as sortedList.Join sorted with a new line and save it as sortedList.

If a step below fails, save the error as rollupErrorIf a step below fails, save the error as rollupError

Try

ClaudeAsk Claude: 'Below is today's product feedback, already sorted into themes. Write two or three sentences for a product channel: which themes came up most, what the tone was, and anything that reads as urgent. Use only what is here - do not infer how many users are affected or how important something is.Ask Claude: 'Below is today's product feedback, already sorted into themes. Write two or three sentences for a product channel: which themes came up most, what the tone was, and anything that reads as urgent. Use only what is here - do not infer how many users are affected or how important something is. sortedList'. Save it as written. Maximum response length: 400

Trim written.response_text and save it as rollup.Trim written.response_text and save it as rollup.

SlackSend a message to slackChannelId.Send a message to slackChannelId.*Feedback rollup* (the length of sorted as text) rollup sortedList

On error

SlackSend a message to slackChannelId.Send a message to slackChannelId.*Feedback rollup* (the length of sorted as text) _Rollup unavailable today._ sortedList