Google Spreadsheets Paper Test By Calling Google’s Spreadsheets API
I have made one post about doing paper test by using google app script. For a fully automated paper testing, you can use Google’s Spreadsheets API to track your paper test result. How to do it?
1. Connect to Google’s Spreadsheets API
There is a quickstart documentation. And I have posted mine:
2. okie dokie now, let’s create a function to call Google’s Spreadsheets API
3. finally we are here! Let’s actually do something.
How about let’s update the btc spot price? Yes, I know I can just use the Class UrlFetchApp
instead of creating my own function…But why not 🤓🤓🤓?
And you can even schedule it yourself 😃
4. However…
Soon I hit my google spreadsheet API limits… It would be so much easier if I just wrote a local csv file and started a http server to refresh the page every 5 second… 😓
Read other posts