Create an app that displays live scores for professional golf tournaments. This will also work to display any live data from an HTML table.
Set up a Google Sheet where you will store the data from your HTML table
Go to the URL of the HTML table you want to import from. This can be a table of golf scores or other sports scores, or it can be any HTML table that has live data (there isn’t a live golf tournament for me to test with at the moment, so I’m using scores from The Open this past weekend)
Import the Data from the HTML table by using the google sheets formula ‘=IMPORTHTML’
Add the query inside the formula (for a table this will be “table” inside of the quotation marks again)
The last part of the formula is the trickiest part-the index, which starts at 1, tells the formula which table (or list) should be returned from the webpage. If you aren’t sure, I’d suggest starting with the number 1, and counting up from there until you get the data you’re looking for
Make sure the table is formatted how it should be in Google Sheets and has the correct information