# Can I get live data from a website? **URL:** \ **Category:** Ask for Help\ **Created:** [October 2, 2022, 4:31pm UTC](https://community.glideapps.com/t/can-i-get-live-data-from-a-website/50709 "2022-10-02T16:31:49Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Alexander\_Rubino](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexander_rubino/32/48638_2.png) [@Alexander\_Rubino](https://community.glideapps.com/u/Alexander_Rubino)\ **Post date:** [October 2, 2022, 4:31pm UTC](https://community.glideapps.com/t/can-i-get-live-data-from-a-website/50709/1 "2022-10-02T16:31:49Z")
Is it possible to get live data from a website’s table? I’m trying to copy the data from a basketball ranking and put it into a list in my glide app. Can I do that? From this website: [https://basketligaen.dk](https://basketligaen.dk) ![Screenshot 2022-10-02 at 18.29.20](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/c/ec8682784069287175c42002f2b45116c72835f9.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 2, 2022, 4:37pm UTC](https://community.glideapps.com/t/can-i-get-live-data-from-a-website/50709/2 "2022-10-02T16:37:14Z")
Possible, but not simple. You’d probably need to write your own plugin column to do it. If the site has an API available (either free or paid), then it would be a little easier. It could most likely be done using an automation tool such as Zapier or Make. ---
**Author:** ![Alexander\_Rubino](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexander_rubino/32/48638_2.png) [@Alexander\_Rubino](https://community.glideapps.com/u/Alexander_Rubino)\ **Post date:** [October 2, 2022, 6:02pm UTC](https://community.glideapps.com/t/can-i-get-live-data-from-a-website/50709/3 "2022-10-02T18:02:45Z")
I have tried for an hour now with no luck. I’ve tried converting the website’s data into a google sheet, and then into glide. (I know this will take longer, but that doesn’t matter that much in this case.) However, I just get a big pile of code. I’m kind of lost right now, do you have any tips or guidance in my situation? Link to my google sheet: [Sports Teams - Google Sheets](https://docs.google.com/spreadsheets/d/1uH1QKzUztUwz-yPw-JkmreYntDtxFKA22DHPd8-1nSM/edit#gid=1499042045) Optional link to a new website I found, that maybe is easier for getting the API: [Basketball: Basketligaen 2022/2023 stillinger - Livesport.com  ](https://www.livesport.com/dk/basketball/danmark/basketligaen/tabeloversigt/) ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [October 3, 2022, 1:02am UTC](https://community.glideapps.com/t/can-i-get-live-data-from-a-website/50709/4 "2022-10-03T01:02:14Z")
Hi! Today i also try to use fetch json in Glide and have fail ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/d/ed8fe369cbfe99d4cac03d882eec2a18c383283e.png) Previosly it works perfectly, but now Fetch JSON dont workind any way. May be it is temporary trouble and you can try later. Just have a time for coffe. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 3, 2022, 1:14am UTC](https://community.glideapps.com/t/can-i-get-live-data-from-a-website/50709/5 "2022-10-03T01:14:03Z")
The error tells you what is wrong. The response is not valid JSON. Try loading the URL in a browser and see what you get. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 3, 2022, 1:16am UTC](https://community.glideapps.com/t/can-i-get-live-data-from-a-website/50709/6 "2022-10-03T01:16:04Z")
Please try this. ```auto =IMPORTHTML("https://www.livescore.com/en/football/team/horsens-ic/2063/tables/11443/","table",1) ``` ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/4/54106378b73f31e67ff48688b5746fbb3122095d.jpeg) ---
**Author:** ![Alexander\_Rubino](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexander_rubino/32/48638_2.png) [@Alexander\_Rubino](https://community.glideapps.com/u/Alexander_Rubino)\ **Post date:** [October 3, 2022, 5:22am UTC](https://community.glideapps.com/t/can-i-get-live-data-from-a-website/50709/7 "2022-10-03T05:22:11Z")
@ThinhDinh Will this automatically update my sheet, when the website updates? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 3, 2022, 8:41am UTC](https://community.glideapps.com/t/can-i-get-live-data-from-a-website/50709/8 "2022-10-03T08:41:37Z")
This claims that the formula refreshes every hour. > **[IMPORTHTML Function Google Sheets | Coupler.io Blog](https://blog.coupler.io/importhtml-function-google-sheets/)** > > A tutorial on how you can pull tables and lists from web pages into Google Sheets using the IMPORTHTML function. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/5/d50adcc7b404a268e680b96a979c47cb5e292f2e.jpeg)