Stats Reporter

Keep daily progress statistics of your free bot without using a database.

Features

• Collecting daily server and vote count statistics.
• Sends your day's stats and growth rate live to your Discord Webhook.
• No database requirements.

Build on Google Infrastructure

You can probably do these operations more easily with Terraform or Yaml. But because I don't know, I prefer to follow the path below.

Remember, you need Google Cloud SDK for setup.

1. First, install repository

git clone https://github.com/asena-team/stats-reporter && cd stats-reporter

2. Set static variables

# App Name
APP="stats-reporter"

# Get the current project
PROJECT=$(gcloud config get-value core/project 2> /dev/null)

3. Create service account and download credentials with IAM

# Create a service account
gcloud iam service-accounts create $APP \
    --description="Optional Stats Reporter Description" \
    --display-name=$APP

# Create and download credentials for the service account
gcloud iam service-accounts keys create credentials.json \
    --iam-account "$APP@$PROJECT.iam.gservice.account.com"

4. Enable the Google Sheets API

gcloud services enable sheets.googleapis.com

5. Create a new spreadsheet and give access to the IAM account

• Create a new Google Sheet if you don’t have one already: sheets.new
• Share the Google Sheet with the service account email (above) as an editor:

(Click that Share button in the top-right of your Sheet.)

(The service account email should autocomplete for a valid service account.)

6. Build container image and upload Cloud Container Registry

gcloud builds submit --tag "gcr.io/$PROJECT/$APP"

7. Deploy Cloud Run app with using container image

gcloud run deploy $APP \
    --image="gcr.io/$PROJECT/$APP" \
    --platform=managed \
    --memory=256Mi \
    --region=us-central1 \
    --args="--bot_id=$BOT_ID,--webhook_id=$WEBHOOK_ID,--webhook_token=$WEBHOOK_TOKEN,--dbl_token=$DBL_TOKEN,--sheet_id=$SHEET_ID"

8. Bind IAM Policy

# Authorize your service account with `roles/run.invoker` to access your applation
gcloud run services add-iam-policy-binding stats-reporter \
    --member="$APP@$PROJECT.iam.gserviceaccount.com" \
    --role="roles/run.invoker"

9. Create a new Cron Scheduler

• It allows to collect statistics by sending requests to our application at the end of each day.

# --timezone="Your Time Zone"
gcloud scheduler jobs create http asena-stats \ 
    --schedule="0 0 * * *" \
    --uri="https://your.cloud.run.app/run" \
    --http-method=GET \ 
    --timezone="Europe/Istanbul" \
    --oidc-service-account-email="$APP@$PROJECT.iam.gserviceaccount.com"

Local Run & Test

⚠️If you are running locally as a tool, you need to set the '--cli' parameter

go run . \
  --bot_id $BOT_ID \ 
  --webhook_id $WEBHOOK_ID \
  --webhook_token $WEBHOOK_TOKEN \
  --dbl_token $DBL_TOKEN \
  --sheet_id $SHEET_ID \
  --cli

Images

(Incoming daily report. It is in Turkish language but you can translate it into English language very easily.)

---

(A few spreadsheet features.)