if you use a google sheets link it has to be set to public! top right, click share and set general access to anyone with the link as a viewer.

the translation progress tool only checks whether the cell is not empty!
it does not care about anything else. if you wanna take notes right click on a cell and press "comment"! made by nyutie - on github - meow meow :3