➜Use Auto Import from HoYoLAB
While feedback URL is the best method of extracting data, there is no method to extract Mora. Instead we will use the HoYoLAB login to access the Travellers Diary Tool API. This mimic seeing the history in the history log, and it only goes back from 3 months worth of History.
Bring up the developer tool using 'F12', find cookie www.hoyolab.com or webstatic-sea.mihoyo.com (Visting Daily Check-In) and copy ltoken.
On the Dashboard sheet, make sure the drop down is set as 'Auto Import from HoYoLAB'
Paste the ltoken
Get your HoYoLAB UID, which is different to your Genshin Impact UID.
Using the cookie you can find the HoYoLAB UID as ltuid, same place you have found your ltoken.
Visit your Account info URL: https://www.hoyolab.com/accountCenter
Enter your HoYoLAB UID