ZReviewTender uses brand new App Store & Google Play API to fetch App reviews and integration your workflow.

• [CH Readme] ZReviewTender - 免費開源的 App Reviews 監控機器人

• Support fetch App Store (iOS App/Mac OS App...) Reviews
• Support fetch Google Play Console Android App Reviews
• [Default Processor] Resend newst Reviews to specify Slack Channel
• [Default Processor] Support Auto-translate Review's content to your language by Google Translate
• [Default Processor] Support Auto-Log Review to Google Sheet
• Flexible extension, you can develop your own Processor(a.k.a plugin) for suit your workflow.
• Lightweight implementation, only log latest review timestamp, not save all reviews in local storage.
• Support Filter, you can add custom filter condition to filter out which reviews you need
• Based on Official API(AndroidpublisherV3 & Brand New AppStoreConnect API), no more workaround or session expired problem
• Quick depoly with Github Repo Template/Github Action
• 100% Ruby@RubyGem

Deploy with Gitub Repo Template 🚀🚀🚀

• no need host/server ✅
• no need environment requirement ✅
• no engineering background knowledge ✅
• only need configuration ✅
• total free ✅

Github Action Proivde 2,000+ mins/month for free. ZReviewTender will cost ~= 30s per time, default run every 6 hours will cost 4 times/day * 30s/per time * 30days = 60 mins/month

⚠️️️️️ MUST CREATE PRIVATE REPO, TO KEEP YOUR CREDENTIAL FILES SAFE. ⚠️️️️️

1. make sure you have Ruby in your environment (I use 2.6.5p114)
2. make sure you have Bundle in your environment (I use 2.3.13)
3. type gem install ZReviewTender in terminal

1. MacOS comes with a System Ruby pre-installed, but we are NOT Recommend to use that, using rvm/rbenv's Ruby instead.
2. install rbenv or rvm to manage Ruby environment
3. install Ruby through rbenv/rym (you can install ruby version 2.6.X)
4. change the systme ruby to rbenv/rvm's Ruby
5. type which ruby in terminal to make sure current Ruby is NOT /usr/bin/ruby
6. type gem install ZReviewTender in terminal

1. Clone this repo
2. Setup ruby environment
3. run bundle install
4. execute with bundle exec bin/ZReviewTender

ZReviewTender uses yaml file to config Apple/Google Review Bot Setting.

[Recommended] use ZReviewTender -i generator apple.yml & android.yml config yml files.

1. Reference the apple.example.yml example config yaml file. (Please rename apple.example.yml to apple.yml if you've downloaded from reference.)
2. fill configuration in yaml file:

Go to App Store Connect -> Keys -> App Store Connect API

appStoreConnectIssueID：

appStoreConnectP8PrivateKeyID & appStoreConnectP8PrivateKeyFilePath：

Create a new API Key:

• Name: ZReviewTender
• Access: App Manager

• appStoreConnectP8PrivateKeyID: Key ID
• appStoreConnectP8PrivateKeyFilePath: /AuthKey_XXXXXXXXXX.p8, Download API Key and placed it to /config/ folder (releated path with config yml file)

appID:

appID: App Store Connect -> App Store -> General -> App Information -> Apple ID

3. after filled out configuration in yaml file, rename apple.example.yml to apple.yml

• follow the steps of Creating a service account in offcial documentation, to create a service account of GCP and download the GCP JSON Private Key.
• make sure the service account have the right access you need (e.g. Google Translate/Google Ancdroid Publisher API/Google Sheet...)

1. Download the android.example.yml config yaml file. (Please rename android.example.yml to android.yml if you've downloaded from reference.)
2. fill configuration in yaml file:

packageName:

packageName: find Android App packageName in Google Play Console -> Dashboard -> App

playConsoleDeveloperAccountID & playConsoleAppID:

find in Google Play Console -> Dashboard -> App -> Page URL:

https://play.google.com/console/developers/**playConsoleDeveloperAccountID**/app/**playConsoleAppID**/app-dashboard

keyFilePath:

Follow the GCP Started Document to created a Google Cloud Project Service Account and linked it to your Google Play Console, enable Google Play Android Developer API in Google Play Console -> Setup -> API Access.

• make sure the service account have the right access

keyFilePath: /gcp_key.json the key path of GCP JSON Private Key, placed it to /config/ folder (releated path with config yml file).

• class: FilterProcessor, no need to chane, it's point to lib/Processors/FilterProcessor.rb
• enable: true/false enable this Processor or Not
• keywordsInclude: ["KEYWORD1","KEYWORD2"…] filter out the Review that contains those keywords
• ratingsInclude: [1,2…] 1~5 filter out the Review that contains rating
• territoriesInclude: ["zh-hant","TWN"…] filter out the Review that from those territories (Territor(TWN/JPN...) for Apple / Language(zh-hant,en...) For Android)

• class: GoogleTranslateProcessor, no need to chane, it's point to lib/Processors/GoogleTranslateProcessor.rb
• enable: true/false enable this Processor or Not
• googleTranslateAPIKeyFilePath: /gcp_key.json Google Translate GCP Service Account JSON Private Key File Path *.json,placed it to /config/ folder (releated path with config yml file)
• make sure the service account have the right access(Google Translate API)
• googleTranslateTargetLang: zh-TW Target translated language
• googleTranslateTerritoriesExclude: ["zh-hant","TWN"…] (Territor(TWN/JPN...) for Apple or Language(zh-hant,en...) For Android review that didn't need to translate.

• class: SlackProcessor, no need to chane, it's point to lib/Processors/SlackProcessor.rb
• enable: true/false enable this Processor or Not
• slackTimeZoneOffset: +08:00 timezone of display review created time
• slackAttachmentGroupByNumber: 1 specify how many Reviews will group by in same Slack Message (in Attacment)
• slackBotToken: xoxb-xxxx-xxxx-xxxx Slack Bot Token
• slackBotTargetChannel: CXXXXXX Channel ID (Not Channel Name), and you need to add Slack Bot to this Channel
• slackInCommingWebHookURL: https://hooks.slack.com/services/XXXXX the old send message to slack way, will deprecated.

Please note, this is a legacy custom integration - an outdated way for teams to integrate with Slack. These integrations lack newer features and they will be deprecated and possibly removed in the future. We do not recommend their use. Instead, we suggest that you check out their replacement: Slack apps.

ZReviewTender will use slackBotToken by default.

• class: GoogleSheetProcessor, no need to chane, it's point to lib/Processors/GoogleSheetProcessor.rb
• enable: true/false enable this Processor or Not
• googleSheetAPIKeyFilePath: /gcp_key.json Google Sheet GCP Service Account JSON Private Key File Path *.json,placed it to /config/ folder (releated path with config yml file)
• make sure the service account have the right access(Google Translate API)
• googleSheetTimeZoneOffset: +08:00 timezone of display review created time
• googleSheetID: Google Sheet ID, you can get it on google sheet url: e.g. https://docs.google.com/spreadsheets/d/`googleSheetID`/
• googleSheetName: Sheet Name, e.g. Sheet1
• values: [] # Columns Data you can uses magic variable below to compose string.

%TITLE% for review's title
%BODY% for review's content
%RATING% for review's rating 1~5
%PLATFORM% for review's platform Apple or Android
%ID% for review's ID
%USERNAME% for review's reviewer username
%URL% for link to review
%TERRITORY% for review's territory (language for android e.g. zh-Hant, en)
%APPVERSION% for review's reviewer app version
%CREATEDDATE% for review's created date

• keywordsInclude: ["KEYWORD1","KEYWORD2"…] filter out the Review that contains those keywords you want's log to google sheet
• ratingsInclude: [1,2…] 1~5 filter out the Review that contains rating you want's log to google sheet
• territoriesInclude: ["zh-hant","TWN"…] filter out the Review that from those territories you want's log to google sheet (Territor(TWN/JPN...) for Apple / Language(zh-hant,en...) For Android)

*make sure you have add service account to your google sheet collaborate with edit permission.

1. Clone this repo project (due to ZReviewTedner is a completely Gem, you can't modify it dynamically)
2. Reference Processor.rb, make a copy and devlop the feature you want

initialize

• config: config yml parameter
• configFilePath: config yml file path
• baseExecutePath the path that user execute ZReviewTender

processReviews(reviews, platform)

• Input Function
• you will receive latest reviews list, you can decide what you want to do, e.g. transform or filter...
• Review Struct: lib/Models/Review.rb
• Remember return the result reviews, for next Processor uses

3. Add your Processor & Processor Parameter needed to config.yml, processors: section
4. Test & Run!
5. Done!

*processors are data flow chain and sort sensitive.

• set enable to false or just remove that Processor Setting Block in config yml

if you're not install with Gems, you should use bundle exec ruby bin/ZReviewTender to excute.

Generate config yml file

ZReviewTender -i

will generate apple.yml and android.yml in config/ folder.

Check Both Apple & Android App's latest Reviews

ZReviewTender -r

will uses apple.yml and android.yml in config folder.

Check Both Apple & Android App's latest Reviews, specify Config YAML file path

ZReviewTender --run=CONFIG_FOLDER

Check Apple App's latest Reviews

ZReviewTender -a

will uses apple.yml in config folder.

Check Apple App's latest Reviews, specify Config YAML file path

ZReviewTender --apple=PATH_TO_APPLE_CONFIG_YAML_FILE

Check Android App's latest Reviews

ZReviewTender -g

will uses android.yml in config folder.

Check Android App's latest Reviews, specify Config YAML file path

ZReviewTender --googleAndroid=PATH_TO_ANDROID_CONFIG_YAML_FILE

Clean last check timestamp log(back to init state)

ZReviewTender -d

Show current ZReviewTender version

ZReviewTender -v

Upgrade ZReviewTender to latest release version(only RubyGem)

ZReviewTender -n

you will received an init success message in your Slack Channel!

ZReviewTender will also created latestCheckTimestamp/Apple, latestCheckTimestamp/Android to log ZReviewTender latest checked Review Timestamp and created execute.log for log excute error.

• You could use crontab or any schedule service to execute ZReviewTender periodicity
• e.g. in crontab: 15 */6 * * * ZReviewTender -r
• please note that, google api only allow retrieve the reviews that users have created or modified within the last week, so could not set the time period more than one week.

ZReviewTender App Reviews Automatic Bot

name: ZReviewTender
on:
  workflow_dispatch:
  schedule:
    - cron: "15 */6 * * *" #check new review every 6 hour.

jobs:
  ZReviewTender:
    runs-on: ubuntu-latest
    steps:
    - name: ZReviewTender Automatic Bot
      uses: ZhgChgLi/ZReviewTender@main
      with:
        command: '-r'

you can change command to others ZReviewTender's command.

⚠️️️️️ MUST KEEP YOUR CREDENTIAL FILES SAFE, DO NOT EXPOSE ON THE INTERNET. ⚠️️️️️

This repository is for research purposes only, the use of this code is your responsibility.

• Code authors take NO responsibility and/or liability for how you choose to use any of the source code available here.
• By using any of the files available in this repository, you understand that you are AGREEING TO USE AT YOUR OWN RISK.
• ALL files available here are for EDUCATION and/or RESEARCH purposes ONLY.

• ZMediumToMarkdown lets you download Medium post and convert it to markdown format easily.

• ZhgChg.Li (CH)
• ZhgChgLi's Medium (CH)

If this is helpful, please help to star the repo or recommend it to your friends.

Please feel free to open an Issue or submit a fix/contribution via Pull Request. :)