VR Game Developer

Dashboard Actions Banner Art Image

Grades Dashboard Google Action

This Action allows you to ask Google Assistant about your grades. It retrieves grade information from Powerschool SIS and displays it as part of a conversation with Google Assistant.

The Action's webhook endpoint is now hosted on my own server. A configuration webpage, available at makes POST requests to separate routes on my endpoint that control user data, such as creating, editing, and deleting user information.

Through building and deploying this, I learned:

  • Using Google Actions Console
  • More Python skills:
    • Creating a Flask application
    • Parsing JSON
    • Using Postman to test requests
    • Creating a SQLite database
    • Using a Gunicorn server
  • Server hosting:
    • Setting up a personal cloud server
    • Multipass containers & network bridging
    • Configuring Ubuntu Server
    • Using Cloudflare DNS
    • Reverse proxy based on hostname with nginx
    • Getting SSL certificates from Let's Encrypt
  • Web app creation:
    • Creating a persistant login system using Flask
    • Using Bootstrap for quickly designing multiple pages
    • Displaying flash messages as feedback for user's actions
    • Sharing database between web app and endpoint

Take a look at the code on GitHub: