Sorts each day's product feedback into your own themes, writes it to a tab and posts a rollup to Slack.
Uses
Claude
Google Sheets
Slack
Sort product feedback into themes
feedbackUrl to blank.Set feedbackUrl to blank.themes to blank.Set themes to blank.slackChannelId to blank.Set slackChannelId to blank.feedbackTab to Feedback.Set feedbackTab to Feedback.sortedTab to Sorted.Set sortedTab to Sorted.maxRows to 200.Set maxRows to 200.feedbackUrl. Save it as sheet.Read the rows of feedbackUrl. Save it as sheet.sorted to an empty list.Set sorted to an empty list.item in sheet.rows:For each item in sheet.rows:sortErrorIf a step below fails, save the error as sortErrorTry
item.Feedback and save it as comment.Trim item.Feedback and save it as comment.comment isn't emptyIf comment isn't emptyYes
themes
The feedback:
comment'. Save it as verdict.
Maximum response length: 40verdict.response_text and save it as sortedAs.Trim verdict.response_text and save it as sortedAs.sortedAs isn't emptyIf sortedAs isn't emptyYes
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.sortedTab in feedbackUrl.Add a row to sortedTab in feedbackUrl.No
No steps
No
No steps
On error
sortError as text.Show in the output: Could not sort a feedback row: sortError as text.sorted is emptyIf sorted is emptyYes
slackChannelId.Send a message to slackChannelId.*Feedback rollup*
Nothing new to sort today.No
sorted with a new line and save it as sortedList.Join sorted with a new line and save it as sortedList.rollupErrorIf a step below fails, save the error as rollupErrorTry
sortedList'. Save it as written.
Maximum response length: 400written.response_text and save it as rollup.Trim written.response_text and save it as rollup.slackChannelId.Send a message to slackChannelId.*Feedback rollup* (the length of sorted as text)
rollup
sortedListOn error
slackChannelId.Send a message to slackChannelId.*Feedback rollup* (the length of sorted as text)
_Rollup unavailable today._
sortedList