Teyvat Central Banking Systems

Using Google Sheets to save logs for Genshin Impact, such as:

Primogems - earning and spending
Genesis Crystals - earning and spending
Resins - spending
Mora earning

Project Website

Visit the Genshin Impact collection of Google Sheets tools:

https://gensheets.co.uk

Google Add-on

Teyvat Central Banking Systems is available on Google Workspace Marketplace from 19th November 2021. https://workspace.google.com/marketplace/app/teyvat_central_banking_systems/523809188356

Preview

Tutorial

Change Language

Use Auto Import from miHoYo

Use Auto Import from HoYoLAB

Template Document

If you prefer to use the Teyvat Central Banking Systems document with embedded script, you can make a copy here: spreadsheet link: https://docs.google.com/spreadsheets/d/1VrNIbZGj2XhVZv7eRMgoSO3xUhOm0EVFGFqW0y1BLpI/edit

How to compile script

This project uses https://github.com/google/clasp to help compile code to Google Script.

Run npm install -g @google/clasp
Edit the file .clasp.json with your Google Script
Run clasp login
Run clasp push -w