Sign up for updates

Get a weekly update every Sunday with our announcements, company updates and a behind-the-scenes of what our community are building.
Over 11,000 people get our updates, join us!
You're in 😍- check your email to get started. Tweet me what you want to build to see how to do it without code.
Oops! Something went wrong while submitting the form.
⭠ all tutorials

Live sports scoring app with Glide

This tutorial is available for pro members only

Request access

Submitted by Noah

Create an app that displays live scores for professional golf tournaments. This will also work to display any live data from an HTML table.

Instructions

  1. Set up a Google Sheet where you will store the data from your HTML table
  1. 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)
  1. Import the Data from the HTML table by using the google sheets formula ‘=IMPORTHTML’
  • Add the URL inside of 2 quotation marks “www.urlhere.com
  • 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


  1. Make sure the table is formatted how it should be in Google Sheets and has the correct information
  1. Log in to Glide and Create a New App
  1. Select the Google Sheet that has the data from the table you want to use
  1. Customize and format the homepage of your App how you want it to look-for my purposes I want to see the golfer’s name and their current score to par
  1. Clicking into a “component” or golfer in my case allows me to see all data from the table, and you can add or remove any of the information you’d like to display or hide


g

The full tutorial is available for pro members only

Request access

Submitted by Noah

Create an app that displays live scores for professional golf tournaments. This will also work to display any live data from an HTML table.

Instructions

  1. Set up a Google Sheet where you will store the data from your HTML table
  1. 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)
  1. Import the Data from the HTML table by using the google sheets formula ‘=IMPORTHTML’
  • Add the URL inside of 2 quotation marks “www.urlhere.com
  • 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


  1. Make sure the table is formatted how it should be in Google Sheets and has the correct information
  1. Log in to Glide and Create a New App
  1. Select the Google Sheet that has the data from the table you want to use
  1. Customize and format the homepage of your App how you want it to look-for my purposes I want to see the golfer’s name and their current score to par
  1. Clicking into a “component” or golfer in my case allows me to see all data from the table, and you can add or remove any of the information you’d like to display or hide


g

Added to your list!
Oops! Something went wrong while submitting the form.
Marked as complete!
Oops! Something went wrong while submitting the form.
Mark as completeSave to watch later
Take the quiz
Lesson details

Submitted by Noah

Create an app that displays live scores for professional golf tournaments. This will also work to display any live data from an HTML table.

Instructions

  1. Set up a Google Sheet where you will store the data from your HTML table
  1. 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)
  1. Import the Data from the HTML table by using the google sheets formula ‘=IMPORTHTML’
  • Add the URL inside of 2 quotation marks “www.urlhere.com
  • 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


  1. Make sure the table is formatted how it should be in Google Sheets and has the correct information
  1. Log in to Glide and Create a New App
  1. Select the Google Sheet that has the data from the table you want to use
  1. Customize and format the homepage of your App how you want it to look-for my purposes I want to see the golfer’s name and their current score to par
  1. Clicking into a “component” or golfer in my case allows me to see all data from the table, and you can add or remove any of the information you’d like to display or hide


g

Previous submissions
No items found.
Supporting details

You must be a member to view the full lesson

Get started with
Makerpad today

The #1 platform for no-code education. Join over 10k others and discover what's possible.

Business

Multiple seat access, hire talent and custom training.

Learn more
Individuals

Unlimited all-access to our online bootcamps and community.

Get started
Email updates
You're in 😍- check your email to get started. Tweet me what you want to build to see how to do it without code.
Oops! Something went wrong while submitting the form.

Ready to get started?

Join the community and start turning your ideas into solutions