CryptoBlades-Stamina-Reminder

A simple Google Sheet reminder for CryptoBlades Stamina using Google App Script.

How to Setup in your Google Account to avoid #ERROR

1. open the google sheet link : https://docs.google.com/spreadsheets/d/1dEoCj4R6eNjPXwhPuw5XVMVh-nJuN74FM79QNlSakvk/edit?usp=sharing

2. Make a Copy because you can't edit my google sheet.

3. Rename and Saved to your drive by clicking OK button, and it will open your copy.

4. Notice the #ERROR! under the Value, this means that you need to allow permission to access the script.

5. Under Tools, Click Script Editor, It will open new tab

6.Click Run and Review permission, If the dialog box doesn't appear, close the tab and repeat step 5.

7. Click the account you want to have access. make sure to choose same account in your current browser.

8. Google will promt a warning, Just Click Advanced then..

Click the "Go to....(Unsafe) and click Allow button

9. Remove the "m" under Library >... > Remove > and click Remove Library

10. Add new Library by clicking + sign. You need to get "Script ID*" so click cancel then go to step 11.

11. Under Project Settings, Click the Copy Icon to get the Script ID.

12. Go back to the Editor, then add Library, paste the Script ID. click Lookup > Click Add button

13. Click Run, and wait.. you must see Logs same in the picture below.

14. Now, We will add Trigger to run the script continuosly.

15. Choose theTime-driven and Every minute Interval , then click save.

16. Go back to your Google sheet copy. and "#ERROR" should disappear.

17. You can now set up reminder: Guide on how to use the reminder is on youtube: https://youtu.be/D2kBA5Scd0c