I was inspired by BreadStickNinja’s chart in a recent thread and wanted to do something similar to keep track of my own progress. Behold: https://docs.google.com/spreadsheets/d/1ksaH_F_58xCtp-coCAUC8MVx9O9VqWcBEt65p11y0uY/edit?usp=sharing This is updated automatically every day at 5 am thanks to a…

Sorry, didn’t notice your post… To capture these, you need to add two lines to the script, starting at row 30 of the original version: cell.offset(1,8).setValue(doc.user_information.level); cell.offset(1,9).setValue(doc.user_information.posts_count);Don’t forget to add the columns on the actu…

eninny said... Sorry, didn't notice your post... To capture these, you need to add two lines to the script, starting at row 30 of the original version: cell.offset(1,8).setValue(doc.user_information.level); cell.offset(1,9).setValue(doc.user_information.posts_count); Don't …

I added a few lines to the script so that it logs your level: //writes Level to Collumn I cell.offset(1,8).setValue(level); //Writes the level to Collumn J for when the level has changed if(cell.offset(0,8).getValue() - cell.offset(1,8).getValue() ==0){ cell.offset(1,9).setValue(“”); } els…

[image] Maxinoume: qCUetd6.png800x274 78.5 KB I know that this topic was dead for over a year now, but I can’t seem to figure out how to do this. How did you put vertical bars by the level markers. I can’t find any option in the chart settings that enables this feature, some help please …

You need to add it yourself at the end of the data sheet under Notes, and it’ll be added by itself.

[image] konekush: You need to add it yourself at the end of the data sheet under Notes, and it’ll be added by itself. Thank you so much!!

Wow this really took off haha. 見てくれてありがとうございます。

I customised it some (added a lot of other api data), but I never would’ve been able to think/do it without your template. Thank you!

This is what happens when you don’t use WK for four months, then come back to find you’ve forgotten a whole bunch :neutral_face: [image]

Hi! I just wanted to say THANK YOU VERY MUCH FOR THIS! I just started, and I love data. So I’m so happy that I can easily track my progress every day. Thank you very much for sharing!

WaniKani API + Google Docs Awesomeness

WaniKani API And Third-Party Apps

wsegatto July 10, 2021, 2:17pm 57

This script is broken. If you faced the issue below, please move to the latest script in the link below:

"Request failed for https://www.wanikani.com returned code 410. Truncated server response: {"code":410,"message":"This endpoint has been removed. Please use our latest API."

Topic		Replies	Views
Self-updating WaniKani Statistics & Data Spreadsheet API And Third-Party Apps	30	5194	November 22, 2020
Self-Updating WaniKani Spreadsheet to Track Progress for API 2.0 API And Third-Party Apps	44	2888	November 5, 2021
WaniKani Google Sheet—Pull data from API version 2 to Sheet API And Third-Party Apps	35	5829	May 24, 2023
[Unsupported] Progress Chart Script API And Third-Party Apps	43	6448	March 17, 2019
[WebApp] WaniKani Timemachine! API And Third-Party Apps	99	10150	March 3, 2024

WaniKani API + Google Docs Awesomeness

Related topics