$npx -y skills add hanamizuki/solopreneur --skill gplay-review-managementReview monitoring, filtering, and automated responses for Google Play. Use when managing user reviews and feedback.
| 1 | # Review Management for Google Play |
| 2 | |
| 3 | Use this skill when you need to monitor and respond to user reviews. |
| 4 | |
| 5 | ## List Reviews |
| 6 | |
| 7 | ### Get all reviews |
| 8 | ```bash |
| 9 | gplay reviews list --package com.example.app |
| 10 | ``` |
| 11 | |
| 12 | ### Get all reviews with pagination |
| 13 | ```bash |
| 14 | gplay reviews list --package com.example.app --paginate |
| 15 | ``` |
| 16 | |
| 17 | ### Table output (human-readable) |
| 18 | ```bash |
| 19 | gplay reviews list \ |
| 20 | --package com.example.app \ |
| 21 | --output table |
| 22 | ``` |
| 23 | |
| 24 | ## Filter Reviews |
| 25 | |
| 26 | ### By rating |
| 27 | ```bash |
| 28 | # Get 1-star reviews |
| 29 | gplay reviews list --package com.example.app \ |
| 30 | | jq '.reviews[] | select(.rating == 1)' |
| 31 | |
| 32 | # Get 5-star reviews |
| 33 | gplay reviews list --package com.example.app \ |
| 34 | | jq '.reviews[] | select(.rating == 5)' |
| 35 | |
| 36 | # Get reviews with 3 stars or less |
| 37 | gplay reviews list --package com.example.app \ |
| 38 | | jq '.reviews[] | select(.rating <= 3)' |
| 39 | ``` |
| 40 | |
| 41 | ### By date |
| 42 | ```bash |
| 43 | # Reviews from last 7 days |
| 44 | DATE_7_DAYS_AGO=$(date -u -v-7d +%Y-%m-%dT%H:%M:%SZ) |
| 45 | gplay reviews list --package com.example.app \ |
| 46 | | jq --arg date "$DATE_7_DAYS_AGO" \ |
| 47 | '.reviews[] | select(.comments[0].userComment.lastModified.time > $date)' |
| 48 | ``` |
| 49 | |
| 50 | ### By language |
| 51 | ```bash |
| 52 | # English reviews only |
| 53 | gplay reviews list --package com.example.app \ |
| 54 | | jq '.reviews[] | select(.comments[0].userComment.language == "en")' |
| 55 | ``` |
| 56 | |
| 57 | ### Machine-translated review text |
| 58 | Use the built-in `--translation-language` flag to get review text translated by Google, rather than reading it in the original language: |
| 59 | ```bash |
| 60 | gplay reviews list --package com.example.app --translation-language en-US |
| 61 | ``` |
| 62 | |
| 63 | ### Reviews containing keywords |
| 64 | ```bash |
| 65 | # Find reviews mentioning "crash" |
| 66 | gplay reviews list --package com.example.app \ |
| 67 | | jq '.reviews[] | select(.comments[0].userComment.text | contains("crash"))' |
| 68 | ``` |
| 69 | |
| 70 | ## Get Specific Review |
| 71 | |
| 72 | ```bash |
| 73 | gplay reviews get \ |
| 74 | --package com.example.app \ |
| 75 | --review REVIEW_ID |
| 76 | ``` |
| 77 | |
| 78 | ## Reply to Reviews |
| 79 | |
| 80 | ```bash |
| 81 | gplay reviews reply \ |
| 82 | --package com.example.app \ |
| 83 | --review REVIEW_ID \ |
| 84 | --text "Thank you for your feedback! We've fixed this issue in version 1.2.3." |
| 85 | ``` |
| 86 | |
| 87 | ## Automated Review Response |
| 88 | |
| 89 | ### Script to reply to unreplied 1-star reviews |
| 90 | ```bash |
| 91 | #!/bin/bash |
| 92 | |
| 93 | PACKAGE="com.example.app" |
| 94 | |
| 95 | # Get all unreplied 1-star reviews |
| 96 | gplay reviews list --package $PACKAGE --paginate \ |
| 97 | | jq -r '.reviews[] | select(.rating == 1 and (.comments | length == 1)) | .reviewId' \ |
| 98 | | while read REVIEW_ID; do |
| 99 | echo "Replying to review: $REVIEW_ID" |
| 100 | gplay reviews reply \ |
| 101 | --package $PACKAGE \ |
| 102 | --review "$REVIEW_ID" \ |
| 103 | --text "Thank you for your feedback. We're sorry to hear about your experience. Please email support@example.com so we can help resolve this issue." |
| 104 | done |
| 105 | ``` |
| 106 | |
| 107 | ## Review Analytics |
| 108 | |
| 109 | ### Count reviews by rating |
| 110 | ```bash |
| 111 | gplay reviews list --package com.example.app --paginate \ |
| 112 | | jq '[.reviews[] | .rating] | group_by(.) | map({rating: .[0], count: length})' |
| 113 | ``` |
| 114 | |
| 115 | ### Average rating calculation |
| 116 | ```bash |
| 117 | gplay reviews list --package com.example.app --paginate \ |
| 118 | | jq '[.reviews[].rating] | add / length' |
| 119 | ``` |
| 120 | |
| 121 | ### Most common words in reviews |
| 122 | ```bash |
| 123 | gplay reviews list --package com.example.app --paginate \ |
| 124 | | jq -r '.reviews[].comments[0].userComment.text' \ |
| 125 | | tr '[:upper:]' '[:lower:]' \ |
| 126 | | tr -s ' ' '\n' \ |
| 127 | | sort | uniq -c | sort -rn | head -20 |
| 128 | ``` |
| 129 | |
| 130 | ## Monitor for Specific Issues |
| 131 | |
| 132 | ### Find crash-related reviews |
| 133 | ```bash |
| 134 | gplay reviews list --package com.example.app --paginate \ |
| 135 | | jq '.reviews[] | select(.comments[0].userComment.text | test("crash|freeze|hang"; "i"))' |
| 136 | ``` |
| 137 | |
| 138 | ### Find reviews mentioning competitors |
| 139 | ```bash |
| 140 | gplay reviews list --package com.example.app --paginate \ |
| 141 | | jq '.reviews[] | select(.comments[0].userComment.text | test("competitor_name"; "i"))' |
| 142 | ``` |
| 143 | |
| 144 | ### Find reviews with refund requests |
| 145 | ```bash |
| 146 | gplay reviews list --package com.example.app --paginate \ |
| 147 | | jq '.reviews[] | select(.comments[0].userComment.text | test("refund|money back"; "i"))' |
| 148 | ``` |
| 149 | |
| 150 | ## Monitoring Dashboard |
| 151 | |
| 152 | Create a simple review dashboard: |
| 153 | |
| 154 | ```bash |
| 155 | #!/bin/bash |
| 156 | PACKAGE="com.example.app" |
| 157 | |
| 158 | echo "=== Review Dashboard ===" |
| 159 | echo "" |
| 160 | |
| 161 | # Total reviews |
| 162 | TOTAL=$(gplay reviews list --package $PACKAGE --paginate | jq '.reviews | length') |
| 163 | echo "Total reviews: $TOTAL" |
| 164 | |
| 165 | # Rating distribution |
| 166 | echo "" |
| 167 | echo "Rating distribution:" |
| 168 | gplay reviews list --package $PACKAGE --paginate \ |
| 169 | | jq -r '.reviews[] | .rating' \ |
| 170 | | sort | uniq -c | sort -rn |
| 171 | |
| 172 | # Avg rating |
| 173 | AVG=$(gplay reviews list --package $PACKAGE --paginate \ |
| 174 | | jq '[.reviews[].rating] | add / length') |
| 175 | echo "" |
| 176 | echo "Average rating: $AVG" |
| 177 | |
| 178 | # Unreplied reviews |
| 179 | UNREPLIED=$(gplay reviews list --package $PACKAGE --paginate \ |
| 180 | | jq '[.reviews[] | select(.comments | length == 1)] | length') |
| 181 | echo "" |
| 182 | echo "Unreplied reviews: $UNREPLIED" |
| 183 | |
| 184 | # Recent 1-star |
| 185 | echo "" |
| 186 | echo "Recent 1-star reviews:" |
| 187 | gplay reviews list --package $PACKAGE \ |
| 188 | | jq -r '.reviews[] | select(.rating == 1) | "\(.comments[0]. |